This is what I'm using:
Oracle 9i
oraConn.Open "DRIVER={Microsoft ODBC for
Oracle};UID=xxxxx;PWD=xxxxx;SERVER=esgprd;ConnectString=esgprd;"
Note: In the ODBC Data Source Administration dialog, under the
System DSN tab, I have an entry called "esgprd"
Oracle 10g
oraConn.Open "Provider=OraOLEDB.Oracle;Data Source=jchoeprd;User
Id=xxxxx;Password=xxxxx"
Note: In the ODBC Data Source Administration dialog, under the
System DSN tab, I have an entry called "jchoeprd"
Regards,
Jon
At 01:49 PM 11/30/2004 -0500, Brian Rasche wrote:
>Try: oraConn.Open "dsn=SR7","userid","password"
>
>Brian Rasche
>DBA/Systems Analyst
>Titlsville, FL, USA
>----- Original Message -----
>From: "Allan Alli "
><oracledba-ezmlmshield-x23351425.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Sent: November 30, 2004 1:38 PM
>Subject: Oracle and ASP
>
>
> >I am trying to connecto to Oracle via ASP. Unfortunately I just get a super
> >long timeout without any errors. I am using the connection information for
> >DSN and the oracle dsn is working with SQL*PLUS and any other ODBC
> >application
> >
> > please advise
> >
> > Dim oraConn
> > Set oraConn = Server.CreateObject("ADODB.Connection")
> >
> > oraConn.Open "DRIVER={Oracle ODBC
> > Driver};DSN=SR7;UserID=*****;Password=*****;"
> >
> > oraConn.close
> >
> > _______________________________________________
> > Allan Alli
> >
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> >
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page