Chisel Software

ODBC and ISAM

Contents:

What is ODBC?
ODBC Resources on the Internet
ODBC Driver Development
ODBC Frequently Asked Questions

What is ISAM?
ISAM Resources on the Internet

Free Downloads

What is ODBC?

In 1991 Microsoft introduced Open Database Connectivity (ODBC) as a standard way for PC applications to access data in corporate database systems.

The theory is that, so long as your database supplier provided an ODBC interface, you the user could choose any PC application, which is "ODBC compliant", and direct access to corporate data is guaranteed.

In practice ODBC has been an outstanding success, supported by every leading database supplier and many PC applications. So long as your database supplier provides an ODBC interface, you the user can choose any "ODBC compliant" PC application, such as Chisel Software's QUERYer and dBOrganiser.

ODBC Resources on the Internet

ODBC Drivers Development

Use these tools to develop an ODBC driver for any platform of computer, to access either local or network databases.

 

ODBC Frequently Asked Questions

Need Help Using ODBC with Microsoft SQL Server?
See the SQL Server Developer's Resource Kit page for technical materials targeted at developers of large-scale SQL Server applications.

Need Answers to ODBC Questions?
Get the answers to the questions Microsoft Support Engineers get most frequently
by clicking here.

Q. Where can I get ODBC?

Q. How can I redistribute "just" ODBC 3.5?

Q. Is there an MDAC redistribution with just ODBC or OLE DB?

Q. How do I find Knowledge Base (KB) Articles for ODBC?

Q. Where do I obtain the latest 16- or 32-bit version of the SQL Server driver?

Q. Where do I obtain the latest 32-bit version of the ORACLE driver?

Q. Where do I obtain the latest 16-bit version of the ORACLE driver?

Q. Where do I obtain the latest 32-bit versions of the Access, Paradox, dBASE, FoxPro, Excel, and Text drivers?

Q. Where do I obtain the latest 16-bit versions of the Access, Paradox, dBASE, FoxPro, Excel, and Text drivers?

Q. How do I obtain the ODBC 3.0 SDK?

Q. Where can I get sample code for SQLTables and SQLColumns?

Q. How do I check the current version of the SQL Server Driver?

Q. My application uses ODBC and it is failing. How do I determine what ODBC call is not working correctly?

Q. My Visual Basic application fails with the message "ODBC Call Failed " or with the message "ODBC Call Failed -3146". How do I debug this?

Q. Is there a Microsoft White Paper that explains how to use ODBC with SQL Server?

Q. How do I configure my ODBC driver for SQL Server when I need to deal with DBCS?

Q. I get an error message "The odbc resource dll (<path>\<filename>) is a different version that the (<path>\filename). You need to reinstall the odbc components to ensure proper operation" How do I resolve this?

Q. What is ODBC Connection pooling?

Q. How do I enable connection pooling in an ODBC Application ?

Q. My SQL query works from ISQL/W, but not from ODBC. How do I resolve this?

Q. I am getting the error message "[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt". How do I resolve this?

Q. I am getting the error message [Microsoft][ODBC SQL Server Driver] Unable to load communication module. Driver has not been correctly installed." How do I resolve this?

Q. How does the application using Microsoft SQL Server ODBC Driver process the stored procedure return codes and output parameters to an ODBC application ?

Q. What do I need to do for redistributing/installing the driver manager and a driver?

Q. What is the relationship of INSTCAT.SQL to the odbc driver for SQLServer?

Q. I am getting the error message "The ODBC catalog stored procedures installed on server MySQLServerName are version 6.50.193; version 07.00.0324 or later is required to ensure proper operation. Please contact your system administrator" using MDAC SQLServer driver. How do I resolve this?

Q. IIS queries to SQLServer are generating error 1326. How do I resolve this?

Q. I am getting the error message "Microsoft OLE DB Provider for ODBC Drivers error '80004005'[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" within Active Server Pages. How do I resolve this?

 

What is ISAM?

ISAM (Indexed Sequential Access Method) refers to indexed databases such as Btrieve, dBASE, FoxPro and Paradox.

The Microsoft Jet database engine can reference these databases through user-installable drivers. The locations for these ISAM drivers are maintained in the Windows Registry. These entries are created automatically when you install a database application such as Microsoft Access, or QUERYer. If you change the location of these drivers, you need to make the corrections in the Registry.

The most efficient way to access ISAM databases is to attach them to an existing Microsoft Jet database. Attaching a table creates a reference to the ISAM database and saves it in the Jet database. This stored link keeps a record of the database's structure only - none of the ISAM data is stored in the Jet database. Once the ISAM databases are attached you can access them using all of Jet's functionality.

ISAM Resources on the Internet

Free Downloads

The following material is available as free resources from the Microsoft web site. To download a product, click on the icon to the left of the product description.

Microsoft Data Access Components (Redistribution or Full-Install)
The Microsoft Data Access Components (MDAC) are the key technologies that enable Universal Data Access. MDAC 1.5c includes the latest versions of the following components:
- ActiveX Data Objects
- OLE DB Provider for ODBC
- ODBC Driver Manager
- Updated ODBC drivers for Microsoft SQL Server, Microsoft Access and Oracle.

ODBC 3.0 Software Development Kit (SDK)
The SDK provides tools, utilities, and samples to help you develop and use your ODBC 3.0 application or driver.

Updated ODBC 3.0 Driver Manager
The ODBC Driver Manager Update contains the latest version of the ODBC 3.0 core components.

ODBC 3.0 Programmer's Reference
You can download the ODBC 3.0 specification in Help file format, or preview it from your browser.

Visual FoxPro ODBC Version 1.0
Provides access to Visual FoxPro 3.0 and FoxPro 2.x tables, as well as Visual FoxPro 3.0 databases.

Installable ISAM Drivers
These self-installing files contains the drivers necessary for accessing dBase, Excel, FoxPro, Paradox and Text databases from Jet. They also ensure that Windows Registry entries are correct.

isam25 - Jet 2.5 drivers (16-bit) 522 Kb
isam30 - Jet 3.0 drivers (32-bit) 712 Kb

 

If you have any questions, please contact support@chiselsoftware.com.
 

About Us | Products | Downloads | Order | Support/Services | Contact Us

Copyright © 1998-2005 Chisel Software, All Rights Reserved