Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dataphile
Yak Posting Veteran
71 Posts |
 Posted - 2002-06-06 : 05:22:40
|
| Hi,I'm trying to create a linked server to a database using the Microsoft oledb provider for ODBC drivers. No there is no ole db driver for this database.I have sucessfully created the linked server and I can see the tablenames in Enterprise Manager.The trouble is that I get a defiant error message in query analyser :Server: Msg 7312, Level 16, State 1, Line 1Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.The four part name that I use is LINKEDSERVER.CATALOG.SCHEMA.TABLEas exposed by Enterprise Manager.The database that I'm trying to connect to is ImageSQL, but if there is anybody out there that got this scenario to work with Access, I will gladly take it from there. |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-06 : 09:24:04
|
| Never mind.Problem solved mission accomplished.Thanks. |
 |
|
|
|
|
|
Linked Server => oledb provider for ODBC drivers