how to write oledb connection string for oracle8i(in a remote machine)

Question

How to write oledb connection string for oracle8i(in a remote machine)?

I mean the iis is setup in my machine(the win7 system),but the oracle8i is installed in another win xp system,how to write the connection string?

Answer 1

1st, the remote machine certainly needs an oracle client installed.

2nd, if you're unsure about the correct syntax try creating an empty *.udl file (0 byte) and double click it. This will open a dialog which lets you configure and test the connection. After that you've got the connection string inside the *.udl file.