I have a MySQL database on a remote server.
when i connect to it using Heidisql it open pretty instantly
but.. using an ADO connection string
server=xxx.xxx. 218.237;db=xxxx x2;driver={MySQ L ODBC 3.51 driver};uid=myi d;pwd=9997xxx
it takes about 20 seconds to connect - thereafter everything works fast enough
I can even use an ODBC DSN - the ODBCtest button is quick, but usa ADO to connect via the ODBC is just as slow
anyone know why??? please
I am using Visual Basic.NET 2003
when i connect to it using Heidisql it open pretty instantly
but.. using an ADO connection string
server=xxx.xxx. 218.237;db=xxxx x2;driver={MySQ L ODBC 3.51 driver};uid=myi d;pwd=9997xxx
it takes about 20 seconds to connect - thereafter everything works fast enough
I can even use an ODBC DSN - the ODBCtest button is quick, but usa ADO to connect via the ODBC is just as slow
anyone know why??? please
I am using Visual Basic.NET 2003