I’m not sure if that would help, but it happened to me once, what I did
is, I gave the IUSER and IWAM users write and read access on the bin
directory in Oracle home, then I restarted the server (windows 2000
Advanced Server)
> 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
>
>


Fahed Ibraham Yoseph
Senior DBA
MCDBA
OCP
965 665-6210


Oracle LazyDBA home page