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
>
>



Oracle LazyDBA home page