Skip to Main Content

APEX

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!

ODBC Connecting to a Oracle database with VBSCRIPT

686235Feb 20 2009 — edited Feb 20 2009
I am new to this so please excuse my ignorance!

I have written many web applications using Access,SQL and VBScript but now need to use a more robust database. I have also used Oracle Database Express as a practice environment for SQL.

Now I need to set up and be able to connect to and use an Oracle database from a web application hosted on a Windows web server. I have found hints that the ODBC driver is:

Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;

I installed Oracle Database Express on my computer (which has IIS installed) to practice. Can I set up a database in Oracle Database Express and connect to it online using the above driver? If so, any ideas what should be the value in "Server=myServerAddress"? Any clues on setting up Uid and Pwd?

Thanks in advance if you can help! I would really appreciate it!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2009
Added on Feb 20 2009
1 comment
479 views