Oooops! The connection string has some extra quotes in it. It should look like:
"Provider=msdaora;Data Source=OracleServer.world;User Id=sa;Password=;"
>Ah! You won't see the OLEDB drivers in the ODBC manager. OLEDB cuts out the ODBC middle man.
>
>What you use is a connection string to connect to the ORACLE db. Here's what the ORACLE connection string should look like:
>
>"Provider=msdaora;"Data Source=OracleServer.world;User Id=sa;Password=;"
>
>Obviously the Data Source, User ID, and Password will be different for you. I got that example from
www.able-consulting.com/ADO_Conn.htm.
>
>HTH
>
>>Then I just use the ODBC driver?
>>Becasue I did this and in the:
>>ODBC Manager I was exepecting to see something like.
>>"MICROSOFT OLEDB provider for oracle"
>>
>>But I did n't
>>
>>Thanks for the reply!
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams