![]() |
![]() |
|
![]() |
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.
Once all the above software is installed, you can proceed with the following steps. Creating a System DSN
Troubleshooting If the connection is not established then you have to check a number of things:
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. ![]() |
![]() |
|