Environmental configuration:
Database server: UNIX ORACLE9I
Web external network server: Windows2000 IIS5.0
Now you have to connect IIS5.0 and database server.
First, in Windows2000, there must be drivers of the Oracle database, and MS is not own, usually by installing Oracle clients, to
http://www.oracle.com/technology/software/products/oracle9i/index.html Download, to register, slow speed. Download, the installation is complete to restart.
Then, configure Oracle's client, open: Start -> Program -> Oracle - OraHome-> Network Administration-> Net8 Configuration Assistant: Local Network Service Name Configuration -> Add -> Next -> Server Name: (Database Server Oracle name) -> Connection is TCP-> Host Name: (Database server IP) -> Network service name (self-take, after calling in the program) This will be completed, can be tested if successfully explains the configuration
Finally, it is to connect characters in the program MS.
Http://www.connectionstrings.com/ can have many ways, I use provider = msdaora.1; password = ***; user ID = ***; data source =; persist security info = true; where DATA Source is the network service name configured above.
