Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding the correct syntax to connect to Oracle db through VBscript

133277Aug 26 2004 — edited Aug 31 2004

I have shelled to a vbscript from asp code on the same page. This is the code I use to try and connect to an Oracle db as per subject above.

Set connection = createobject ("ADODB.Connection")
connection.open "DSN=servername; UID=username; PWD=password"

The error I am getting is as follows:
Internet Explorer Script Error.
[MicroSoft][ODBC Driver Manager]Data source name not found and no default driver specified.

On the web server I have specified an "Oracle ODBC Driver"
Is it not possible to do what I am trying?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2004

Added on Aug 26 2004

#general-database-discussions

8 comments

1,012 views