I'd use the following DSN-less connection type and following recordset 
method instead of an ODBC method with the current sql arguments.

physpath = "d:\data\database.mdb"
set connection = server.createobject("adodb.connection")
connection.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & physpath

set rs = "server.createobject("adodb.recordset")
rs.open "Select * from table_name where field_name='"&variable&"'", 
connection

I never have problems using this method.

Good luck,

Bill

-----Original Message-----
From: "ASP Database Setup digest" <asp_database_setup@p...>
To: "asp_database_setup digest recipients" 
<asp_database_setup@p...>
Date: Wed, 26 Jun 2002 00:00:40 +0100
Subject: asp_database_setup digest: June 25, 2002

> -----------------------------------------------
> When replying to the digest, please quote only
> relevant material, and edit the subject line to
> reflect the message you are replying to.
> -----------------------------------------------
> 
> The URL for this list is:
> http://p2p.wrox.com/list.asp?list=asp_database_setup
> ASP_DATABASE_SETUP Digest for Tuesday, June 25, 2002.
> 
> 1. Re: Active Server error 80040e37
> 
> ----------------------------------------------------------------------
> 
> Subject: Re: Active Server error 80040e37
> From: m.dillissen@p...
> Date: Tue, 25 Jun 2002 16:08:32
> X-Message-Number: 1
> 
> Burc,
> 
> Did you find any solution/reason for this problem. I'm having the same 
> problem currently and I don't no what to do with it.
> 
> Thanks,
> Maarten
> 
> > Hi,
> > 
> > My problem is about connecting to a LDAP Service. I spent a lot of
> time 
> hoe to connect to our 
> > Netscape LDAP service and got a code from a coleage. The code has
> been 
> working without any 
> > probelms since I have installed Visual Studio.  I am using my
> computer, 
> Windows NT 
> > Workstation as a development machine. After I installed Visual
> Studio, 
> the connection to the 
> > LDAP fails. 
> > 
> > 
> > 	Set oConn = Server.CreateObject("ADODB.Connection") 
> > 	oConn.Provider = "ADsDSOObject" 
> > 
> > 	oConn.Open "ADs Provider" 
> > 	Set oRS = oConn.Execute(sSQL) 
> > 
> > the error appears on the last line.
> > 
> > Active Server error 80040e37. Element not found.
> > 
> > What might be the problem?
> > 
> > Thanks
> > Burc
> > 
> 
> 
> ---
> 
> END OF DIGEST
> 
> %%email.unsub%%
>