Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 2 of 2 total |
DBISAM LinkedServer MSSQL |
Thu, Nov 17 2011 4:56 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |