🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Driver for ADO to open Paradox Files?

#3663
From: David Evennou
Date: Fri, 28 Jun 2002 13:12
39 lines
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-mail
References: <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