ADO connection string disaster

Article View: borland.public.cppbuilder.database.ado

Article #440

Back to borland.public.cppbuilder.database.ado Previous Next

#440

From: anguspickton
Date: Mon, 06 Mar 2006 20:22

22 lines
2098 bytes

Hi,
I have an app that uses the following connection string to vfp

"Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties="Driver={Microsoft Visual FoxPro
Driver};UID=;SourceDB=C:\DATA.DBC;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"

which used to work just fine. Then out of the blue, when ever the app
tried to connect to the database, the program hangs and odly, the disk
hives??  From a known good backup, i restored first tthe db, then
msdasql.dll, msdasqlr.dll, and then vfpoledb.dll. All with the same
disatrous results.Of course re-booting did nothing!! OS is wk2.

Finally, i discovered an alternative connection string,
"Provider=vfpoledb;Data Source=C:\DATA.DBC;"

which works just fine.

So can someone please tell me what the problem is with the first string
and why this should make the disk hive, and the app hang, when
previously this same app was connecting and working just fine. Thanks
in advance, angus.

Technical Details

Message-ID: <1141676569.519695.310680@e56g2000cwe.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e56g2000cwe.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,ea8d77dda226cc38,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e56g2000cwe.googlegroups.com!not-for-mail
From: anguspickton@yahoo.com
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO connection string disaster
Date: 6 Mar 2006 12:22:49 -0800
Organization: http://groups.google.com
Lines: 23
Message-ID: <1141676569.519695.310680@e56g2000cwe.googlegroups.com>
NNTP-Posting-Host: 203.109.245.20
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1141676574 28004 127.0.0.1 (6 Mar 2006 20:22:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 6 Mar 2006 20:22:54 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: e56g2000cwe.googlegroups.com; posting-host=203.109.245.20;
   posting-account=ZTyragwAAADD5NU2qacQAnvlAmk2aFx1