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

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 ?
shawvoelAsked:
Who is Participating?
 
loveneesh_bansalConnect With a Mentor Commented:
make a udl and then try this

set conn = server.createobject("adodb.connection")

conn.open "file name = c:\aa.udl"

I hope you know that how we can make a udl.

Happy coding

loveneesh
0
 
drittichCommented:
Try this:

Dim cn
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=MSDAORA;Data Source=YourServer;User ID=YourUserID;Password=YourPassword"
0
 
mouattsCommented:
Oracles advice is that you should use the microsoft driver for 7 but theirs for 8i.
0
 
mzarubaCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.