These two versions came with an ODBC driver that you can use to connect from other software to Paradox tables You should also realise that when you connect to Paradox data in this way the ODBC 'driver' provided is only the front-end: you also need to install and run a piece of software called the BDE - this also comes with Paradox. If you want to link to Paradox tables using ODBC (as you would, for example, if your data in Paradox continues to be updated) then you should get a copy of Paradox 9 or 10. Bigfella, I think I answered this a few days ago too:) Microsoft's ODBC driver only works with earlier versions of Paradox tables. Just to get to grips with the Paradox thing I have created a screen where you enter the Location number, I then want to read through the Location.db until I find that location and the display the name. Please tell me what I am doing wrong also what references should be loaded. I have tried with and without the '.DB' and with 'Paradox 5.x'. From Location.db' Set dbLocDB = DBEngine.OpenDatabase('C: samstock SamStock Data Location.DB', False, False, 'Paradox 7.X') Set rsLocRS = dbLocDB.OpenRecordset(sSql, dbOpenSnapshot) But receive the error that 'C: samstock SamStock Data Location.DB' is not a valid path. This is what I have entered - Dim dbLocDB As Database Dim rsLocRS As Recordset Dim sSql As String sSql = 'Select. Hi Veena, Many thanks once again, I must be being silly here.
.- INTERESTED IN THIS MESSAGE? RELATED CONTENT - Reduce Your IT Infrastructure and Services Cost by at Least 25%: Find out how from IBM & Jupiter Research (White Papers) What Kind Of Development Legacy Are You Leaving Behind? (Blogs) Visual Studio (Wiki) RE: How to remove ctrl-M using script (Groups) -.// '. Do I need ODBC connections for each table? Is there something else I need to load in VB? I would be most grateful if somebody could supply the basics. I am now being asked to extract information from a Paradox data base and so far have had no success. Regards Veena -Original Message- I am faily new to Vb using vb6 to connect to access. U need not create odbc for every table and give this connection string: Dim AConn As New ADODB.Connection With AConn ConnectionString = 'Provider=MSDASQL Persist Security Info=False Data Source=MyODBC' Open End With U have to add references 'Microsoft Active X Data Objects 2.0 Libraray' or higher if available. '-Original Message- HiNo Create One ODBC, While Creating ODBC, Select the Folder Name where all ur.db files are stored. .- INTERESTED IN THIS MESSAGE? RELATED CONTENT - Reduce Your IT Infrastructure and Services Cost by at Least 25%: Find out how from IBM & Jupiter Research (White Papers) What is AJAX? A nontechnical answer (Blogs) Visual Studio (Wiki) RE: Transmit record internet way (Groups) -.//. Is there something else I need to load in VB? Many thanks in anticipation. Do I need ODBC connections for each table? I am faily new to Vb using vb6 to connect to access. An ODBC driver that you can use to connect from other software to Paradox. In Paradox continues to be updated) then you should get a copy of Paradox 9 or 10.
Microsoft's ODBC driver only works with earlier versions of Paradox tables. 3.00.005 is packaged with Paradox 8 3.11.000 with Paradox 9.
However, read the user license before you distribute them! InterSolv driver 3.00.000 comes with WordPerfect Office 8, and is a limited-functionality version.
The Intersolv ODBC drivers are included on the Corel Paradox 8 and 9 CD's.