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

[Guest]

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.

 

[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

 

[Guest]

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.