October 9, 2001 at 5:56 am
I Tried to connect to ORACLE Views trough SQL Server with T-SQL
I tried this script
SELECT a.*
FROM OPENROWSET ('MSDAORA','data source=T30.WORLD;user id=xxxx;pwd=xxxx',
'select * from sapr3.users') AS a
I also tried with other values than MSDAORA like MSDAORA.1 or MSDAORA.1 but it always fails.
Can anybody help ??
October 9, 2001 at 5:26 pm
Hey Paul - don't know much about Oracle, but have you looked at this article?
http://support.microsoft.com/support/kb/articles/Q240/3/40.ASP
Andy
October 30, 2001 at 9:16 am
Thanks for all.
The problem was that the driver for Oracle was named MSDAORA.1 on windowsXP while it was MSDAORA on windows2000 ...
October 30, 2001 at 12:35 pm
Paul, thanks for the followup. That's good to know. Is it on all your XP boxes or is it this one alone?
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply