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 MS SQL Server?

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 MS SQL Server?

Article :	00832
Last Reviewed :	19th July 2005
Revision :	1

You get this error message if you have added a linked server to a Easysoft Data Access for ISAM data source 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 if your running on Unix add into your ODBC data source the following lines:-

schema_null = 1
catalog_null = 1

If running on Windows using REGEDIT find your data source within the key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI and add 2 new string values:-

schema_null = 1
catalog_null = 1

This data source should not be used in conjunction with the Easysoft Administrator as it may report key information incorrectly.

Applies To

Products
- Easysoft ODBC-ISAM Driver
Applications
- Microsoft SQL Server

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

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 MS SQL Server?

Applies To

Knowledge Base Feedback