Paradox Community
Search:

 Welcome |  What is Paradox |  Paradox Folk |  Paradox Solutions |
 Interactive Paradox |  Paradox Programming |  Internet/Intranet Development |
 Support Options |  Classified Ads |  Wish List |  Submissions 


Paradox OCX Internet/Intranet Articles  |  Non-OCX Internet/Intranet Articles  


Using ASP to Connect with Paradox Tables
© 2003 Chris Mallia

Preface

These are step-by-step instructions which I have found worked for me in using ASP in connecting with Paradox V9.0 tables using the DataDirect odbc driver.

Software Used Version
Paradox V9.0
Windows 2000 Server Latest with all service packs
DataDirect ODBC Driver v4.1
IIS V5.0

Once all the above software is installed, you can proceed with the following steps.


Creating a System DSN
  1. Close Paradox (if open)
  2. Go: Control Panel - Administrative Tools - Data Sources - System DSN
  3. Create a System DSN giving it a name (in this case, bkaccomodbc) choosing the DataDirect 4.1 ParadoxFile (*.db) driver.

    ODBC DSN

  4. Go to the Configure button and set the General details. As you can see I have used an alias which exists in the BDE to identify my working directory to the ODBC.

    ODBC DSN Setup

  5. Click on the Advanced tab, setting the following details:

    ODBC DSN Advanced

    The Network Directory should point to the PDOXUSERS.NET file and this should be the same as defined in the BDE. After setting all these just press on the "Test Connect" button to check that the connection is established.

Troubleshooting

If the connection is not established then you have to check a number of things:
  1. Check that idapi32.dll is in your Winnt/System32 folder
  2. Check that idapi32.dll is NOT in your BDE folder. Delete it if you find it here.
  3. In the BDE:
    1. Check that the net dir is pointing to your PDOXUSERS.NET file by going Configuration-Drivers-Native-Paradox-Net Dir
    2. Check that Local share is TRUE by going Configuration-System-Init-Local Share
    3. Check that Auto ODBC is TRUE by going Configuration-System-Init-Auto ODBC
    4. Go to DataBase tab and in the list of Databases you should see your ODBC connection (in this case bkaccomodbc)

The ASP Connection

In the asp code the following is done to establish the connection:
<%
  ConnectStr = "DSN=bkaccomodbc;"
  Set rs = Server.CreateObject("adodb.recordset")
  rs.open "select * from A_TableName where A_FieldName = 'ABC' ", ConnectStr
%>
where ConnectStr identifies the System DSN previously created. In the rs.open command full SQL statements can be made on tables which are currently specified in the directory as determined in the ODBC connection or as per alias used (in this case my alias was ":BKACCOM:").


Discussion of this article


 Feedback |  Paradox Day |  Who Uses Paradox |  I Use Paradox |  Downloads 


 The information provided on this Web site is not in any way sponsored or endorsed by Corel Corporation.
 Paradox is a registered trademark of Corel Corporation.


 Modified: 26 Jun 2003
 Terms of Use / Legal Disclaimer


 Copyright © 2001- 2003 Paradox Community. All rights reserved. 
 Company and product names are trademarks or registered trademarks of their respective companies. 
 Authors hold the copyrights to their own works. Please contact the author of any article for details.