January 15, 2003 at 7:08 am
I have created a linked server and am trying to query a table using the four-part name requirement (server.catalog.schema.table). I am getting a SQLSRV-07312 error. I'm guessing I am not setting my linked server up right. Can anyone help?
January 15, 2003 at 8:26 am
Can you post the select statement?
January 15, 2003 at 8:35 am
select * from admin.admin.cdba.dm2_user_tables
admin = linked server name
admin = database name
cdba = schema owner
January 15, 2003 at 8:44 am
Read KB article 280106 if you are trying to setup and query linked Oracle database. It may help.
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
January 15, 2003 at 12:03 pm
That link is very helpful. Is there a similar link that helps create a linked server for SQL Server?
Also, I successfully created a linked server for to an Oracle database, but am getting a SQLSRV-07399 error. Do you know anything about this error?
January 15, 2003 at 1:28 pm
It is very generic error message id. You have to refer to the article to try to resolve it.
In terms SQL linked server setup, you can refer to BOL.
January 15, 2003 at 3:19 pm
Also, there are other issues you may run into. Since we are talking Oracle here, what version and what driver are you trying to use?
January 16, 2003 at 2:22 am
try using
select * from [admin].admin.cdba.dm2_user_tables
January 22, 2003 at 7:45 pm
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply