To use the system data source to configure IIS + InterDev + ASP

I. Server Side
1. Modify ORACLE_HOME/network/ADMIN/tnsnames. ora and add a TNS, for example:
TgpmsTNS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.15.248) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = ycdb)
)
)
2. Set the system data source (DSN) in the ODBC console in the control panel. For example:
Data Source Name: tgpmsdb (any name)
User name: xuy_3g
Server: tgpmstns (TNS set in step 1)

Ii. Client
1. Configure TNS as the server: tgpmstns
2. Configure DSN as per the server: tgpmsdb

3. Set InterDev on the client
1. Open InterDev, create a new project, and select the server address as 192.168.16.41: 9999.
2. Select an existing project, for example, cyweb
3. Right-click global. Asa, select add data connect, and select the machine data source. You can find the DSN connection string in global. Asa. Its content is:
DSN = tgpmstns
User ID = xuy_3g
Password = 8888
Uid = xuy_3g
Server = tgpmstns