Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread DBISAM LinkedServer MSSQL
Thu, Nov 17 2011 4:56 AMPermanent Link

munerf


I'm connect DBISAM with sql server via linked server. I've managed to connect it, I can see the tables and now I cannot perform any query without using OPENQUERY.

If I use the common sintax for linked servers:

SELECT * from [JJ].[C:\TEST]..[Processes]

I get two errors:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "JPM" reported an error. The provider did not give any information about the error.

Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "JPM". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

I think the problem is in  the catalog name ([C:\TEST]) that contains a backslash but I'm not sure...

I've configured ODBC Driver with:

Provider: dbisam
datasource: TEST
ProviderString: TEST
Location:localhost
Catalog:TEST

Thank you
Miguel
Mon, Nov 21 2011 12:36 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Miguel,

<< I think the problem is in  the catalog name ([C:\TEST]) that contains a
backslash but I'm not sure... >>

You are correct.  As far as I've been able to determine, there is no way to
use a DBISAM data source in a linked server without using OpenQuery.  I've
tried every combination of escapement, etc. possible and I just simply
cannot get the naming to work correctly.

--
Tim Young
Elevate Software
www.elevatesoft.com
Image