Article View: borland.public.cppbuilder.database.ado
Article #3663Re: Driver for ADO to open Paradox Files?
From: David Evennou
Date: Fri, 28 Jun 2002 13:12
Date: Fri, 28 Jun 2002 13:12
39 lines
2359 bytes
2359 bytes
I only need to open (ReadOnly) a db table in the C:\ directory. I dropped a TADOTable on the form with the following properties: ConnectionString - "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\;Extended properties=Paradox 5.x;" ReadOnly - True TableDirect - True TableName - Buyer.db When I try to set "Active = True", I get the error "[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified." It seems like the ConnectionString is not being read. I am running BCB5 Pro on Win2K Pro. Please help, Thanks, David Evennou "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message news:3d1b95ef_1@dnews... > Microsoft Jet (Access) provider. Connection string is > > "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Your_DB_Path;Extended > properties=Paradox 5.x;" > > In recordset use "Select * from FileName" (filename is without extension). > > The Paradox database driver will work in one of two modes, depending upon > whether the Borland Database Engine (BDE) is installed. Paradox data is only > updateable with the BDE. Without the BDE, the Paradox data can be Read, > Exported, or Linked to read-only. > > Regards, > Vassiliev V.V. > http://www.oledbdirect.com
Technical Details
Message-ID:
<3d233536$0$222$4d4ebb8e@read.news.nl.uu.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!supernews.com!news.cs.utwente.nl!newshunter!cosy.sbg.ac.at!newsrouter.chello.at!amsnews01.chello.com!newsfeed.wxs.nl!transit.news.xs4all.nl!195.129.110.18.MISMATCH!bnewspeer00.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!read.news.nl.uu.net!not-for-mailReferences:
<3d1ae904_1@dnews> <3d1b95ef_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,5a9c7e3c24dcf922 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-07-03 10:34:40 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!supernews.com!news.cs.utwente.nl!newshunter!cosy.sbg.ac.at!newsrouter.chello.at!amsnews01.chello.com!newsfeed.wxs.nl!transit.news.xs4all.nl!195.129.110.18.MISMATCH!bnewspeer00.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!read.news.nl.uu.net!not-for-mail From: "David Evennou" <dae@data-masters.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3d1ae904_1@dnews> <3d1b95ef_1@dnews> Subject: Re: Driver for ADO to open Paradox Files? Date: Fri, 28 Jun 2002 09:12:46 -0400 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Lines: 42 Message-ID: <3d233536$0$222$4d4ebb8e@read.news.nl.uu.net> NNTP-Posting-Host: ns.hiscom.nl X-Trace: 1025717558 read.news.nl.uu.net 222 130.78.143.1 X-Complaints-To: abuse@nl.uu.net