471,120 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,120 software developers and data experts.

ADO.NET slow connection to remote server

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=xxxxx2;driver={MySQL ODBC 3.51 driver};uid=myid;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
Apr 11 '08 #1
0 1093

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Nathaniel Sherman | last post: by
reply views Thread by Kevin Blount | last post: by
5 posts views Thread by Mitya Mitriev | last post: by
2 posts views Thread by =?Utf-8?B?SmltIE93ZW4=?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.