Top incoming search terms for this post

1 Comment Already

dhvrm Said,
October 15th, 2009 @7:37 pm  

Your server is going to need a driver for Oracle. That means ODBC or OLE. You need one or the other in order to connect.

Assumung you truly cannot use ODBC, which I doubt, here’s an OLE connection string using Data Access Components:

Provider=MSDAORA;Data Source=114.91.65.12:1521; User ID=userName; Password=userPassword;”

If that doesn’t work, you can try this:

Provider=OraOLEDB.Oracle; Data Source=114.91.65.12:1521; User Id=myUsername; Password=myPassword;

And I’d go ahead and try ODBC, since I’ve never heard of a Web server with OLE but without ODBC:

Driver={Microsoft ODBC Driver for Oracle}; ConnectString=114.91.65.12:1521; Uid=myUsername; Pwd=myPassword;

In all the strings above, you need to remove the spaces following semicolons (;)

Related Post

Please Leave Your Comments Below

Please Note: All comments will be moderated

Powered by Yahoo! Answers