?
Solved

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

Posted on 2002-06-15
4
Medium Priority
?
376 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 100 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

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 informatio…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

800 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