E.2.2 Remote Database Connections

FrontPage supports direct access to ODBC databases without defining a Data Source Name. FrontPage constructs a Connection String and stores it in Global.asa. For example:
Application("Remote_ConnectionString") = "DRIVER={Microsoft ODBC for Oracle};SERVER=DBSRV;UID=demo;PWD=demo"
This example creates a remote connection using ODBC to the Oracle database named "DBSRV." Notice that the connection string contains the username and password for accessing the database.
Note:
When the connection string only contains a reference to an Oracle driver, but does not refer the Oracle version, Chili!Soft ASP will assume the database is Oracle 7. If you are using Oracle 8, change the connection string from "Oracle" to "Oracle 8."
Copyright © 2000 Chili!Soft
|