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 


Interactive Paradox Articles  |  Beyond Help Articles  |  Tips & Tricks Articles  


Tricks for Using ODBC Drivers to Access Paradox Tables
© 2003 Allen Mulvey

Preface

When using ODBC drivers to access Paradox tables (with IIS, for example), the following error can occur:
#Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MERANT][ODBC Paradox driver][Paradox]Network initialization failed.
This article covers how to avoid this problem.


Configuring the ODBC Driver

The above error usually means the IIS user can't access the Network Control Folder (NetDir). Check both the share permissions and the NTFS security settings. The IIS user needs to modify the .net file and create lock files in the database folder. Also be sure the IIS user is pointing to the same NetDir that everyone else is using.

This error references the Merant (Intersolv) driver. The Microsoft driver has some other issues. The Microsoft driver insists on using mapped drives for network shares but these mappings don't exist when no one is logged on to the server. To resolve this, I go into the registry under [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC] and make sure the following keys have UNC values rather than mapped drives: (Note: You do not need to double the backslashes if entering directly into regedit; only if you merge from a .REG file.)
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\YourDSNName\Engines\Paradox]
"ParadoxNetPath"="\\\\servername\\netdir"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\YourDSNName]
"DefaultDir"="\\\\servername\\tableFolder"
This is not a problem with the Intersolv driver as it will accept UNC names directly.


Other ODBC-Related articles

Using ColdFusion with Paradox Tables

Using ODBC Data Sources

Accessing an ODBC Data Source from Paradox


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: 07 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.