How does one configure ASP servers for Oracle?
Submitted by admin on Sun, 2005-11-06 03:19.
Follow these steps to ensure your server can connect to Oracle:
- Make sure that you can use simple ASP pages. Upload (FTP) the example above to your server and see if you can access it via a Web Browser.
- Install the Oracle Client CD on your server. This will install SQL*Net, OO4O (Oracle Objects for OLE) and the Oracle ODBC drivers on your system.
- Configure SQL*Net and ensure you can tnsping and connect your Oracle database. This is done by adding an entry to the TNSNAMES.ORA file or by using utilities like the "Net Easy Configurator" to do it for you. See the SQL*Net FAQ for details.
- Optionally configure ODBC by creating a System DSN (Data Source Name). This can be done from the "32-Bit ODBC Administrator" in the Control Pannel. Alternatively one can use OO4O (no configuration required), or "DSNless" ODBC connection. See the ODBC FAQ for details.
- You are ready to GO!!!
»
- Login to post comments

