DSNLess troubles

[shank]

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={Micros oft Access Driver (*.mdb)};" & _
"Dbq=c:\inetpub \wwwroot\author s.mdb;" & _
"Uid=admin; " & _
"Pwd="
%>

[qwestion]

On Fri, 16 Jul 2004 21:26:30 -0400, "shank" <sh***@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={Micros oft Access Driver (*.mdb)};" & _
"Dbq=c:\inetpub \wwwroot\author s.mdb;" & _
"Uid=admin; " & _
"Pwd="
%>

[shank]

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

<qw******@qwest ion.com> wrote in message
news:40******** ********@news.d allas.sbcglobal .net...

On Fri, 16 Jul 2004 21:26:30 -0400, "shank" <sh***@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. Thefollowing 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={Micros oft Access Driver (*.mdb)};" & _
"Dbq=c:\inetpub \wwwroot\author s.mdb;" & _
"Uid=admin; " & _
"Pwd="
%>

[Bob Lehmann]

Show the code where oConn is instantiated.

Bob Lehmann

"shank" <sh***@tampabay .rr.com> wrote in message
news:7a******** *************@t wister.tampabay .rr.com...

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

<qw******@qwest ion.com> wrote in message
news:40******** ********@news.d allas.sbcglobal .net...

On Fri, 16 Jul 2004 21:26:30 -0400, "shank" <sh***@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.

Thefollowing string works fine within the Dreamweaver interface. But when Iupload 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={Micros oft Access Driver (*.mdb)};" & _
"Dbq=c:\inetpub \wwwroot\author s.mdb;" & _
"Uid=admin; " & _
"Pwd="
%>

[dlbjr]

Set Conn = CreateObject("A DODB.Connection ")
Conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0; " & _
"Data Source=c:\inetp ub\wwwroot\auth ors.mdb; " & _
"Jet OLEDB:Database; "

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

Application("Co nnString") = "Provider=Micro soft.Jet.OLEDB. 4.0; " & _
"Data Source=c:\inetp ub\wwwroot\auth ors.mdb; " & _
"Jet OLEDB:Database; "

Then use it on any page as so:

Set Conn = CreateObject("A DODB.Connection ")
Conn.Open Application("Co nnString")

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

--
dlbjr
Pleading sagacious indoctrination!