🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Driver for ADO to open Paradox Files?

#3731
From: David Evennou
Date: Fri, 28 Jun 2002 13:12
39 lines
2090 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: <3d1c606b_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews
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-06-28 06:18:40 PST
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
Lines: 42
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
NNTP-Posting-Host: 64.18.237.75
Message-ID: <3d1c606b_2@dnews>
X-Trace: dnews 1025269867 64.18.237.75 (28 Jun 2002 06:11:07 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews