Integration

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Microsoft ODBC - VBScript - hosted on WIndows using Oracle Database Express

686235Feb 19 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!

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2009

Added on Feb 19 2009

#application-servers, #oracle-application-server-general

1 comment

583 views