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

 

[qwestion]

On Fri, 16 Jul 2004 21:26:30 -0400, "shank" <[email protected]>
wrote:

oConn was never created.

get down to the lower calls... brutha!

 

[shank]

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

 

[Bob Lehmann]

Show the code where oConn is instantiated.

Bob Lehmann

 

[dlbjr]

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

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 OLEDBatabase;"

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.