p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_howto thread: MDAC 2.5 - THE KILLER !!


Message #1 by "Peter Byers" <pb@s...> on Wed, 21 Mar 2001 12:33:50
I would delete the DSN and recreate it and see what happens.


-----Original Message-----
From: Ankur Kalsi [mailto:ankurak@q...]
Sent: 21 March 2001 16:07
To: How To
Subject: RE: MDAC 2.5 - THE KILLER !!


I would try DSN-Less or System DSN. It seems like ODBC can not find you
database.

-----Original Message-----
From: Peter Byers [mailto:pb@s...]
Sent: Wednesday, March 21, 2001 6:18 AM
To: How To
Subject: Re: MDAC 2.5 - THE KILLER !!


MORE INFO


********************************************************
A fragment from the ASP file
********************************************************


<%
session.LCID = 2057

const dbConAn = "FILEDSN=c:\inetpub\ibrus\info\analize"
Set ConAn = Server.CreateObject( "ADODB.Connection" )
ConAn.Open dbConAn

DIM RSAn


MySQL = "insert into analize (email, cdate_time, referer, scriptname,
ip_address ) values ('"
MySQL = MySQL & SESSION( "SAFETEXT_EMAIL" ) & "', '"
MySQL = MySQL & now & "', '"
MySQL = MySQL & Request.ServerVariables("HTTP_REFERER") & "', '"
MySQL = MySQL & Request.ServerVariables( "SCRIPT_NAME" ) & "', '"
MySQL = MySQL & Request.ServerVariables("REMOTE_ADDR") & "')"

Set RSAn = ConAn.Execute( MySQL )


%>





********************************************************
The contents of the DSN file
********************************************************

[ODBC]
DRIVER=Microsoft dBase Driver (*.dbf)
UID=admin
UserCommitSync=Yes
Threads=3
Statistics=0
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=dBase 5.0
DriverId=533
Deleted=1
DefaultDir=C:\inetpub\ibrus\DATA
CollatingSequence=ASCII




********************************************************
The error message
********************************************************



Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC dBase Driver] '(unknown)' is not a valid path. Make sure
that
the path name is spelled correctly
and that you are connected to the server on which the file resides.


  Return to Index