Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Why do I get the error "Invalid schema or catalog specified for provider 'MSDASQL'. OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.] when trying to access ISAM data in Microsoft SQL Server?

You get this error if you add an ISAM ODBC driver linked server and your table names don't have a schema or catalog name. For example: 

SELECT * FROM ISAM...PART
Server: Msg 7313, Level 16, State 1, Line 1 Invalid schema or catalog specified for provider 'MSDASQL'.
OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.].

To resolve this on UNIX and Linux, add the following lines to your data source in /etc/odbc.ini:

schema_null = 1
catalog_null = 1

On Windows, use regedit to add these string values to your data source in the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI subkey: 

schema_null = 1
catalog_null = 1

Note The edited data source can't be used with the Easysoft Administrator.