Re: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled



hboothe@xxxxxxx wrote:
The XP system, connecting over the network (crossover) connects
perfectly. Same program (EXE on both systems). It does NOT exhibit
ANY of the problems I'm about to describe on the Vista system with the
SQL Express 2005 SP2 installed.

I am using a DSN-less connection with a connection string like this:
Driver={SQL Server};server=(local)
\instancename;database=dbname;Uid=sa; Pwd=**********

All I can suggest is using the SQL Native Client instead of the obsolete
ODBC driver. See www,connectionstrings.com
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.