Connecting SQL Server to ORACLE Views

• PAUL717

  SSC-Addicted

  Points: 428

  More actions

  October 9, 2001 at 5:56 am

  #63905

  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 ??

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 9, 2001 at 5:26 pm

  #418780

  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

  Andy
  Connect with me on LinkedIn

• PAUL717

  SSC-Addicted

  Points: 428

  More actions

  October 30, 2001 at 9:16 am

  #419500

  Thanks for all.

  The problem was that the driver for Oracle was named MSDAORA.1 on windowsXP while it was MSDAORA on windows2000 ...

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  October 30, 2001 at 12:35 pm

  #419505

  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

  steve@dkranch.net