DSNLess troubles

I'm trying to setup an Access DSNLess connection on my local computer. The
following string works fine within the Dreamweaver interface. But when I
upload to my server (locally) I get this error. Can anyone lend some
insight?
thanks

Object required: 'oConn'
/Connections/conn.asp, line 2

<%
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\inetpub\wwwroot\authors.mdb;" & _
"Uid=admin;" & _
"Pwd="
%>

qwestion
Fri Jul 16 21:01:34 CDT 2004

On Fri, 16 Jul 2004 21:26:30 -0400, "shank" <shank@tampabay.rr.com>
wrote:

oConn was never created.

get down to the lower calls... brutha!

>I'm trying to setup an Access DSNLess connection on my local computer. The
>following string works fine within the Dreamweaver interface. But when I
>upload to my server (locally) I get this error. Can anyone lend some
>insight?
>thanks
>
>Object required: 'oConn'
>/Connections/conn.asp, line 2
>
><%
>oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
> "Dbq=c:\inetpub\wwwroot\authors.mdb;" & _
> "Uid=admin;" & _
> "Pwd="
>%>
>
>

shank
Fri Jul 16 21:29:23 CDT 2004

>>get down to the lower calls... brutha!<<
Translate that if you don't mind...

<qwestion@qwestion.com> wrote in message
news:40f8871f.110378359@news.dallas.sbcglobal.net...
> On Fri, 16 Jul 2004 21:26:30 -0400, "shank" <shank@tampabay.rr.com>
> wrote:
>
> oConn was never created.
>
> get down to the lower calls... brutha!
>
> >I'm trying to setup an Access DSNLess connection on my local computer.
The
> >following string works fine within the Dreamweaver interface. But when I
> >upload to my server (locally) I get this error. Can anyone lend some
> >insight?
> >thanks
> >
> >Object required: 'oConn'
> >/Connections/conn.asp, line 2
> >
> ><%
> >oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
> > "Dbq=c:\inetpub\wwwroot\authors.mdb;" & _
> > "Uid=admin;" & _
> > "Pwd="
> >%>
> >
> >
>

Bob
Fri Jul 16 22:10:05 CDT 2004

Show the code where oConn is instantiated.

Bob Lehmann

"shank" <shank@tampabay.rr.com> wrote in message
news:7a0Kc.30286$KP6.1399394@twister.tampabay.rr.com...
> >>get down to the lower calls... brutha!<<
> Translate that if you don't mind...
>
> <qwestion@qwestion.com> wrote in message
> news:40f8871f.110378359@news.dallas.sbcglobal.net...
> > On Fri, 16 Jul 2004 21:26:30 -0400, "shank" <shank@tampabay.rr.com>
> > wrote:
> >
> > oConn was never created.
> >
> > get down to the lower calls... brutha!
> >
> > >I'm trying to setup an Access DSNLess connection on my local computer.
> The
> > >following string works fine within the Dreamweaver interface. But when
I
> > >upload to my server (locally) I get this error. Can anyone lend some
> > >insight?
> > >thanks
> > >
> > >Object required: 'oConn'
> > >/Connections/conn.asp, line 2
> > >
> > ><%
> > >oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
> > > "Dbq=c:\inetpub\wwwroot\authors.mdb;" & _
> > > "Uid=admin;" & _
> > > "Pwd="
> > >%>
> > >
> > >
> >
>
>

dlbjr
Fri Jul 16 22:37:18 CDT 2004

Set Conn = CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=c:\inetpub\wwwroot\authors.mdb; " & _
"Jet OLEDB:Database;"

Use OLE Exclusive for speed.
Place the connection string in the global.asa file.

Application("ConnString") = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=c:\inetpub\wwwroot\authors.mdb; " & _
"Jet OLEDB:Database;"

Then use it on any page as so:

Set Conn = CreateObject("ADODB.Connection")
Conn.Open Application("ConnString")

This will allow you to edit the connection string at any time and effect all connections.

--
dlbjr
Pleading sagacious indoctrination!