Hi
I am trying to move an Access 2000 database into MYSQL 3.27.47nt running on
a Win2K machine. MYODBC with the 3.51 drivers is also installed.
MYSQL is running and readily responds to SQL queries using the DOS window at
the mysql> prompt. However, when linking the MYSQL database with ADO and VB6
the response is slow and there is a lot of disk activity before an answer is
returned. It is a lot slower than the original Access2000/VB6 setup.
A DSN-less code is being used to link VB6/ADO to MYSQL. The connection
string is listed below:
con.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& " DATABASE=GIS;" _
& "UID=Admin;PWD=africa; OPTION=16386"
If of any relevance, within the WinMySQLAdmin on the Environment Tab, MYODBC
is stated as not found eventhough it has been loaded.
Any pointers on how to get rid of the disk churning and get a normal
response in this set up would be much appreciated.
Thanks
Simon
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
