July 22, 2009 at 9:40 am
I have a linked server setup in 2000 with no catalog defined. I can see the table list in Enterprise Manager when I expand tables, so I know I have a good connection.
My question is, how do I reference the tables in SQL with no catalog defined? I have setup linked servers to other SQL Servers and had no problem in SQL, I just had to fully qualify the table. (server.database.dbo.tablename)
I try the following and get the following error:
select * from linkedserver...tablename
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.].
The linked server I am trying to access is IEX and the odbc driver I'm using is Simba ODBC. I can access this server through DTS and everything works. I'm just looking for a way to get around setting up a DTS package everytime I want a job to pull data from an IEX server.
Any help anyone can give one this would be greatly appreciated. Thanks in advance.
July 22, 2009 at 10:19 am
FIXED IT!!!!
When you setup the linked server, click on Provider Options, then check Level Zero Only.
Finding this way to access a linked server basically makes all my DTS jobs on my server obsolete.
WOOOO HOOO!!!!~!!
March 28, 2011 at 4:17 pm
So I'm linked, I have the catalogue, but it shows up as default schema and I cannot query it using a 4 part identifier, only openquery. Have you found a way around this?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply