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

Easysoft ODBC-ISAM Driver

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 data in Microsoft SQL Server?

Article:
00832
Last Reviewed:
19th January 2024
Revision:
1

You get this error if you add ISAM ODBC Driver linked server and your table names don't have a schema or catalog name e.g.: 

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, add the following lines to your DSN in /etc/odbc.ini:

schema_null = 1
catalog_null = 1

If running on Windows, use Regedit to add string values to your data source in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI: 

schema_null = 1
catalog_null = 1

The edited data source should not be used with the Easysoft Administrator.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)