What is the connection string for oleDBConnection for Paradox?

[Dan V.]

What is the connection string for a System.Data.OleDb.OleDBConnection for
Paradox 10?
I am trying to use the same connection object and switch between Paradox 10
and MS Access 2000.

I tried: Conn :=
OleDBConnection.Create('Provider=Microsoft.JET.OLEDB.4.0; Data
Source=C:\Adverse.db; Extended Properties=Paradox 5.x');

but I get "could not find installable ISAM" and I when I look in the ODBC
Administrator I have the Microsoft Paradox driver installed.

 

[Dan V.]

Resolved: (but now I have to register this driver on every machine I run
this on I guess...)

-if Paradox ISAM is not registered then:
Register the dll: Mspbde40.dll Paradox
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Paradox

-To register dll automatically: Double-click the dll and open with
C:\Winnt\System32\regsvr32.exe

Connection String is: Conn :=
OleDBConnection.Create('Provider=Microsoft.JET.OLEDB.4.0; Data Source=' + s
+ '; Extended Properties=Paradox 7.x');

See: Microsoft Knowledge Base Article - 209805

 

[Rob Panosh]

take a look at www.connectionstrings.com

 

[Dan V.]

1) I did, earlier but they don't have a paradox section. Unless I am
supposed to look a the Access section, and OLE DB?

2) I was just wondering when I use OleDbConnection does that mean I am not
using ADO.NET??