Use ASP to connect remote Oracle database Method!

oracle| Data | The database first finds Tnsnames.ora settings under the Oracle installation directory under the Networkadmin folder. If the configuration is as follows (service_name to be clear, 8i the following version is SID):

Assume remote server IP is: 192.168.1.12
Database name is: Data

To modify a configuration file:

svn=
(description=
(address_list=
(Address= (PROTOCOL=TCP) (host=192.168.1.12) (port=1521))
)
(Connect_data=
(Service_name=data)
)
)

Connection method:
Setoracleconn=server. CreateObject ("Adodb.connection")
Oracleconn.open "PROVIDER=ORAOLEDB.ORACLE;DATASOURCE=SVN; Userid=system; Password=manager; "