January 21, 2004 at 3:16 pm
My client has a brand new w/2000 server with SQL Server/2003 installed (not by me). I'm attempting to link his Oracle database to it via linked server. Once done, I can view all the Oracle tables, but when I attempt the simplest view (SELECT * FROM [tablename]), I get an error, " returned as invalid column definition". The column appears to always point the the primary key of the Oracle table.
Please help!
Thanks, John
January 21, 2004 at 6:53 pm
Hi John
Strange indeed, I am a little concerned about your select statement, doesnt follow the typical standard for linked server queries, but your post might me a simple demo rather than the physical query used. I have a ss2k instance, hooked to a v9.2 oracle db, the link is very simple (i think you have that already), and an example query is:
select * from MYORACLE..OEMUSER.VDK_TABLE
Where OEMUSER is the schema owner of the table.
I would revisit this for starters, then perhaps review:
http://www.microsoft.com/sql/techinfo/tips/administration/addingoracle.asp
and this
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280106
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
January 22, 2004 at 1:06 am
Hi John,
In the ORACLE Metalink you can find the Note:191368.1: "How to use SQL Analyzer with the Oracle Provider for OLE DB and SQL Server 2000". I had the same problem and this document was very useful for me.
Best regards.
Javier
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply