dsnless connection in oracle9i

hi,

I need to create a dsnless connection in oracle9i for my asp application.
Can u plz help me in that.Its very urgent.



From http://www.developmentnow.com/g/61_2004_3_0_0_0/inetserver-a sp-db.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Re: dsnless connection in oracle9i

On Wed, 20 Apr 2005 07:43:08 GMT, POONAM SINGH V wrote:

>hi,
>
>I need to create a dsnless connection in oracle9i for my asp application.
>Can u plz help me in that.Its very urgent.
>
>
>
>From http://www.developmentnow.com/g/61_2004_3_0_0_0/inetserver-a sp-db.htm
>
>Posted via DevelopmentNow.com Groups
>http://www.developmentnow.com


Here is one way:
myconn= Server.CreateObject("ADODB.Connection");
myconn.ConnectionTimeout = 15;
myconn.CommandTimeout = 30;
myConnString="Provider=MSDAORA;Password=secret;User ID=myuser;Data Source=yourtnsnamesentry;"
myconn.ConnectionString=myConnString
myconn.Open;

It uses MS's provider you can also use Oracle's by substituting OraOLEDB.Oracle.1 for MSDAORA ( assumes you have
installed the Oracle OLE DB stuff)

Re: dsnless connection in oracle9i

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProvi derForOracleFromOracle

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"POONAM SINGH V" wrote in message
news:dc534d55-8bc7-4b42-b577-ae0e64857a4e@msnews.microsoft.c om...
> hi,
>
> I need to create a dsnless connection in oracle9i for my asp application.
> Can u plz help me in that.Its very urgent.
>
>
>
> From http://www.developmentnow.com/g/61_2004_3_0_0_0/inetserver-a sp-db.htm
>
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com