Home All Groups Group Topic Archive Search About

Performance of VB.NET 2003 with Access / MySQL ....

Author
8 Feb 2006 10:24 AM
RPK
I want to know about the compatibility issues of "MySQL" with VB.NET 2003?
Does VB.NET 2003 works fine with MySQL or not.

Secondly, what is the maximum database size of MS Access after which the
performance degrades. I heard that MS Access is not recommended for very
large databases.

Author
8 Feb 2006 11:45 AM
Ken Tucker [MVP]
Hi,

        Yes it does.  I would recommend using the dot net connector
available from there web site.

http://dev.mysql.com/downloads/connector/net/1.0.html

Ken
---------------------
Show quoteHide quote
"RPK" <R**@discussions.microsoft.com> wrote in message
news:9E06DF06-4ABD-4955-81EC-027384E37B52@microsoft.com...
>I want to know about the compatibility issues of "MySQL" with VB.NET 2003?
> Does VB.NET 2003 works fine with MySQL or not.
>
> Secondly, what is the maximum database size of MS Access after which the
> performance degrades. I heard that MS Access is not recommended for very
> large databases.
Author
9 Feb 2006 1:04 AM
Dennis
It works but I have had trouble using parametizerized queries and insert
statements with parameters and ended up building a long sql string without
parameters.
--
Dennis in Houston


Show quoteHide quote
"RPK" wrote:

> I want to know about the compatibility issues of "MySQL" with VB.NET 2003?
> Does VB.NET 2003 works fine with MySQL or not.
>
> Secondly, what is the maximum database size of MS Access after which the
> performance degrades. I heard that MS Access is not recommended for very
> large databases.