Solved

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

Posted on 2002-06-15
4
359 Views
Last Modified: 2012-08-14
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 ?
0
Comment
Question by:shawvoel
4 Comments
 
LVL 1

Accepted Solution

by:
loveneesh_bansal earned 50 total points
ID: 7080305
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
 
LVL 8

Expert Comment

by:drittich
ID: 7080564
Try this:

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

Expert Comment

by:mouatts
ID: 7081077
Oracles advice is that you should use the microsoft driver for 7 but theirs for 8i.
0
 

Expert Comment

by:mzaruba
ID: 7091796
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now