Re: ADODB Connection Question

Our asp guy just did an adodb conn string for us at
http://www.artsource.co.za

I think a search from the main page should result in a resp.asp page which
will give you the dbConn and driver string

Let me know if this works

Andy

P.S. - I think our programmer lifted the string from either myAsp.com or
twoguysfromrola

----- Original Message -----
From: "Frank Boumphrey" <bckman(at)ix.netcom.com>
To: "Veronica Labarca" <vlabarca(at)uclink4.berkeley.edu>;
<hwg-techniques(at)hwg.org>
Sent: Tuesday, March 20, 2001 12:14 AM
Subject: 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