Solved

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

Posted on 2002-06-15
4
362 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Html CheckBox obtain Its Value 5 37
MS SQL 2008 and stored prodcures and dates 5 27
Making Table Thru ASP Response.write 5 19
Table doesn't show the lines! 3 24
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
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/…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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