Solved

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

Posted on 2002-06-15
4
363 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
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 video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

724 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