Re: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled
- From: hboothe@xxxxxxx
- Date: 29 Mar 2007 06:56:35 -0700
On Mar 29, 5:22 am, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
hboo...@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"
Hey, Bob, thank you. I replaced the conn string with a simple one I
found at the site you listed, for Native Client OLE DB and was able to
reference the computer as (local) with no problems. Changing the
connection string seems to have fixed the problem (it's pulling the
query that I was speaking of in the 0.4 to 1.2 second range
consistently and did not freeze/hang and drag on for 3 minutes 59
seconds. I'm going to call it good until I get back to the office
where I can beat up a Vista test box I have to learn more. I've
obviously been missing some important information.
Thank you again for your reply, time, and help.
--HC
.
- References:
- Prev by Date: Re: snapshot isolation level
- Next by Date: Re: MDAC 2.8 EULA
- Previous by thread: Re: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled
- Next by thread: snapshot isolation level
- Index(es):
Relevant Pages
|
|
