Rewriting Pardox System In VB and need help.

[beaver2]

I currently have a system that is written in Paradox but want to rewrite it in VB so that it is more Windows active.

I want to leave the databases in Paradox. The rewason is that I have 5 years of files that I dont want to convert.

By reading the VB information it seems that I can access the Paradox files using ADO with the ODBC driver.

I do not know how to do this.
Can anybody provide me with examples on;
1) Code on using a sql command to access the Paradox Database.
2) What software do I have to install to use ODBC for the Paradox database ?
3) Any other example that would help me get started.

I am using Windows 98 and 95 in a Peer to Peer network.

 

[vb5prgrmr]

Create you ODBC DSN to you tables and use the data form wizard to create an example for you.

Good Luck

 

[paulbent]

The ODBC drivers can be downloaded from

http://www.microsoft.com/data/odbc/

MDAC 2.6 SP1 + Jet 4.0 SP3 (separate downloads) are good all round choices.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[harebrain]

See

[URL unfurl="true"]http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForParadox[/URL]

for an example of using an ODBC driver with Paradox.

The paragraph also contains several other pointers to using Paradox databases with MDAC, although some might be a little dated.

HTH,
David