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

From: 	Pena, Rich [mailto:RPena@U...] 

Sent:	28 February 2000 21:43

To:	'peterm@w...'

Subject:	Question and Thanks for a 2 wonderful books!!!

Importance:	High



		I love your authoring in the Wrox books but one thing about

your information in the books...

		I have Beginning ASP 2.0 , and Beginning ASP Databases...



		Everything was about .mdb and SQL. I have not found a way to connect 

using dBase IV.

		Using ADO OLE db.  Like for example this would seem to

connect although it juast gives me errors:



		<%

		dim oConn

		dim oRS

		dim vCS

		dim strSource



		set oConn=Server.CreateObject("ADODB.connection")

		vCS = "Provider=Microsoft.Jet.OLEDB.4.0"

		vCS = vCS & "; Data

Source"=Server.mappath("f:\InetPub\www\Giddings\GasControl\") 

		oConn.ConnectionString = vCS

		oConn.Open



		set oRS = Server.CreateObject("ADODB.recordset")

		sqltxt = "SELECT TIME FROM CLOCK;"

		oRS.Open sqltxt, oConn

		Do until oRS.EOF

			Response.Write oRS("Time") & "<BR>"

			oRS.MoveNext

		Loop  'each clock record



		Response.Write "<Table Border=1 ><tr><td>"

		dim iCountProps

		iCountProps = 0 

		for each item in oConn.Properties

			iCountProps = iCountProps + 1

			Response.Write "<TR><TD>" & iCountProps & "</TD>"

			Response.Write "<TD>" & item.name & "</TD>"

			Response.Write "<TD>" & item.value & "</TD></TR>"

		NEXT

		Response.Write "</Table>"

		%>



		run that and I get the following error:

		Server.MapPath() error 'ASP 0172 : 80004005' 

		Invalid Path 

		/giddings/gascontrol/gascontrol.asp, line 22 

		The Path parameter for the MapPath method must be a virtual

path. A physical path was used. 





		I can't find anything on dbase IV connect types using asp

ADO OLEdb.



		Rich Pena

		Rpena@u...

		210 - 476 - 1117

Create an ODBC connection to the dBase file then use ADO via OBDC.



Shiraz









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

From:	Phil Perks [mailto:philp@w...]

Sent:	07 April 2000 17:36

To:	ASP Databases

Subject:	[asp_databases] I can't find anything on dbase IV connect types

using asp ADO OLEdb



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

From: 	Pena, Rich [mailto:RPena@U...]

Sent:	28 February 2000 21:43

To:	'peterm@w...'

Subject:	Question and Thanks for a 2 wonderful books!!!

Importance:	High



		I love your authoring in the Wrox books but one thing about

your information in the books...

		I have Beginning ASP 2.0 , and Beginning ASP Databases...



		Everything was about .mdb and SQL. I have not found a way to connect

using dBase IV.

		Using ADO OLE db.  Like for example this would seem to

connect although it juast gives me errors:



		<%

		dim oConn

		dim oRS

		dim vCS

		dim strSource



		set oConn=Server.CreateObject("ADODB.connection")

		vCS = "Provider=Microsoft.Jet.OLEDB.4.0"

		vCS = vCS & "; Data

Source"=Server.mappath("f:\InetPub\www\Giddings\GasControl\")

		oConn.ConnectionString = vCS

		oConn.Open



		set oRS = Server.CreateObject("ADODB.recordset")

		sqltxt = "SELECT TIME FROM CLOCK;"

		oRS.Open sqltxt, oConn

		Do until oRS.EOF

			Response.Write oRS("Time") & "<BR>"

			oRS.MoveNext

		Loop  'each clock record



		Response.Write "<Table Border=1 ><tr><td>"

		dim iCountProps

		iCountProps = 0

		for each item in oConn.Properties

			iCountProps = iCountProps + 1

			Response.Write "<TR><TD>" & iCountProps & "</TD>"

			Response.Write "<TD>" & item.name & "</TD>"

			Response.Write "<TD>" & item.value & "</TD></TR>"

		NEXT

		Response.Write "</Table>"

		%>



		run that and I get the following error:

		Server.MapPath() error 'ASP 0172 : 80004005'

		Invalid Path

		/giddings/gascontrol/gascontrol.asp, line 22

		The Path parameter for the MapPath method must be a virtual

path. A physical path was used.





		I can't find anything on dbase IV connect types using asp

ADO OLEdb.



		Rich Pena

		Rpena@u...

		210 - 476 - 1117



---

You are currently subscribed to asp_databases

Instead of using (" f:\InetPub\www\Giddings\GasControl")

you must use something like ("\Giddings\GasControl")

good luck!



> Source"=Server.mappath("f:\InetPub\www\Giddings\GasControl\") 



> /giddings/gascontrol/gascontrol.asp, line 22 

> The Path parameter for the MapPath method must be a virtual

> path. A physical path was used.