<div>
Try this:<br />
<br />
Dim cn<br />
Set cn = Server.CreateObject(&quot;ADODB<wbr />.Connectio<wbr />n&quot;)<br />
cn.Open &quot;Provider=MSDAORA;Data Source=YourServer;User ID=YourUserID;Password=You<wbr />rPassword&quot;<wbr />
</div>


Try this:

Dim cn
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=MSDAORA;Data Source=YourServer;User ID=YourUserID;Password=YourPassword"

<div>
Oracles advice is that you should use the microsoft driver for 7 but theirs for 8i.
</div>


Oracles advice is that you should use the microsoft driver for 7 but theirs for 8i.

<div>
As I understand it, you also need to make sure that you have the Oracle Client software installed on the machine that will be using this connection.
</div>


As I understand it, you also need to make sure that you have the Oracle Client software installed on the machine that will be using this connection.

<div>
<div class="content wysiwyg-content">
Anyone can help me with my ASP, I'm try to using Oracle 8i as my database but I can't connect with Oracle when I using DSN, can anyone help me what should I do ?<br />
I'm using Oracle 8i with IIS 5.0 and Win2000 Advance Server. I had add my &quot;system DSN&quot;.<br />
<br />
Ya, what the difference between &quot;Microsoft ODBC for Oracle&quot; and &quot;Oracle ODBC driver&quot; ? which one should I used for my DSN ?<br />
<br />
Can anyone answer regarding to my question please ?
</div>
</div>


Anyone can help me with my ASP, I'm try to using Oracle 8i as my database but I can't connect with Oracle when I using DSN, can anyone help me what should I do ?
I'm using Oracle 8i with IIS 5.0 and Win2000 Advance Server. I had add my "system DSN".

Ya, what the difference between "Microsoft ODBC for Oracle" and "Oracle ODBC driver" ? which one should I used for my DSN ?

Can anyone answer regarding to my question please ?

Howto ASP with Oracle 8i + Win2000 Advance Server + IIS 5.0

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.