Re: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Thu, 29 Mar 2007 06:22:16 -0400
hboothe@xxxxxxx wrote:
The XP system, connecting over the network (crossover) connectsAll I can suggest is using the SQL Native Client instead of the obsolete
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=**********
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"
.
- Follow-Ups:
- References:
- Prev by Date: Re: WHILE LOOP NOT WORKING IN INCLUDE ASP FILE - LOOPING FOREVER
- Next by Date: Re: _com_error information
- Previous by thread: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled
- Next by thread: Re: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled
- Index(es):