Re: ADODB Connection Question

You should be able to get the connection string from Oracle. Or else
you can use a datasource name.

Frank
----- Original Message -----
From: "Veronica Labarca" <vlabarca(at)uclink4.berkeley.edu>
To: <hwg-techniques(at)hwg.org>
Sent: Friday, March 16, 2001 11:29 PM
Subject: ADODB Connection Question


> Hi all,
> I hope this is the place for this question. I have an asp file where
I
> am querying an Access database. I will be changing this connection
to
> query the same tables which will be going on to an Oracle database.
I am
> having difficulties figuring out the connection string -
specifically
> how to specify the Driver. Can anyone point me to a place where I
can
> get this information? The code below is what I have now. Thanks in
> advance.
> Veronica
>
>
> Set cn = server.createObject ("ADODB.Connection")
> cn.open ("Driver={Microsoft Access Driver
> *.mdb)};DBQ=C:\staffdir\staffdir.mdb")
>

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA