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