Hi

	If you visit 

		http://195.99.184.152/defaultn.asp

	you will get an error





	The code for the file     defaultn.asp    is shown below





	The database table        analize.dbf     can be downloaded from      

http://195.99.184.152/analize.dbf







	I cannot find any documentation for Microsoft Jet Database Engine version 4.0





	I suspect that the error relates to an absence of a Database Name BUT I do not 

have a Database defined - only a Stand Alone Table called "analize.dbf"





	How do I correct the Error ??

	Where do I find documentation on Jet version 4 ??





	Help please



Thank You In Anticipation (I hope)

Pete (Northolt UK)







PS I have the Jet Programmers Guide Second Edition - it does not cover version 4 - it does not 

even mention OLE DB or ADODB



PPS - This is a follow up in desperation - after failing to resolve the problem in the earlier post 

"MDAC 2.5 - The Killer"



PPPS - The Data Source path in the code below is correct - it is in the same folder as the ASP 

file - so permissions are not the problem !!









********************************

   The code for "defaultn.asp"

********************************





DIM RSAn



const dbConAn = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data 

Source=c:\inetpub\ibrus;Extended Properties=dBASE 5.0;"



Set ConAn= Server.CreateObject("ADODB.Connection")

ConAn.ConnectionTimeout = 15

ConAn.CommandTimeout = 30

ConAn.Open dbConAn







MySQL = "insert into analize (email, cdate_time, referer, scriptname, ip_address ) values ('"

MySQL = MySQL & "x" & "', '"

MySQL = MySQL & now & "', '"

MySQL = MySQL & "a" & "', '"

MySQL = MySQL & Request.ServerVariables( "SCRIPT_NAME" ) & "', '"

MySQL = MySQL & Request.ServerVariables("REMOTE_ADDR") & "')"



Response.Write MySQL



Set RSAn = ConAn.Execute( MySQL )

You should be able to find information on Jet 4.0 (SP3) and

MDAC2.6, OLE etc... at



www.microsoft.com/data



Tons of information available from this site if you dig deep

enough.











-----Original Message-----

From: Peter Byers [mailto:pb@s...]

Sent: 24 March 2001 02:20 AM

To: ASP Databases

Subject: [asp_databases] Jet version 4





Hi

	If you visit

		http://195.99.184.152/defaultn.asp

	you will get an error





	The code for the file     defaultn.asp    is shown below





	The database table        analize.dbf     can be downloaded

from

http://195.99.184.152/analize.dbf







	I cannot find any documentation for Microsoft Jet Database

Engine version 4.0





	I suspect that the error relates to an absence of a

Database Name BUT I do not

have a Database defined - only a Stand Alone Table called

"analize.dbf"





	How do I correct the Error ??

	Where do I find documentation on Jet version 4 ??





	Help please



Thank You In Anticipation (I hope)

Pete (Northolt UK)







PS I have the Jet Programmers Guide Second Edition - it does

not cover version 4 - it does not

even mention OLE DB or ADODB



PPS - This is a follow up in desperation - after failing to

resolve the problem in the earlier post

"MDAC 2.5 - The Killer"



PPPS - The Data Source path in the code below is correct -

it is in the same folder as the ASP

file - so permissions are not the problem !!









********************************

   The code for "defaultn.asp"

********************************





DIM RSAn



const dbConAn 

"Provider=Microsoft.Jet.OLEDB.4.0;Password=;User

ID=Admin;Data

Source=c:\inetpub\ibrus;Extended Properties=dBASE 5.0;"



Set ConAn= Server.CreateObject("ADODB.Connection")

ConAn.ConnectionTimeout = 15

ConAn.CommandTimeout = 30

ConAn.Open dbConAn







MySQL = "insert into analize (email, cdate_time, referer,

scriptname, ip_address ) values ('"

MySQL = MySQL & "x" & "', '"

MySQL = MySQL & now & "', '"

MySQL = MySQL & "a" & "', '"

MySQL = MySQL & Request.ServerVariables( "SCRIPT_NAME" ) &

"', '"

MySQL = MySQL & Request.ServerVariables("REMOTE_ADDR") &

"')"



Response.Write MySQL



Set RSAn = ConAn.Execute( MySQL )