Physical Path To Database

kvarnerexpress

Nov 8 2005, 10:16 PM

I'm trying to learn asp using vbscript and am specifically trying to connect to a database.

I am getting the following error from the following code:

Quote:

QUOTE

Server.MapPath(), ASP 0172 (0x80004005)
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
/html/objconn.asp, line 11

The code is as follows.

Code:

CODE

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("C:\Documents and Settings\jk\My Documents\testdb.mdb"))

set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT Companyname, Contactname FROM Customers", conn

Would very much appreciate any help as to where i'm going wrong here. Many Thanks,kvarnerexpress

magiccode9

Nov 9 2005, 09:42 AM

QUOTE

Server.MapPath(), ASP 0172 (0x80004005)
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
/html/objconn.asp, line 11

as you can see, the error message stated that you should provide a virtual path instead of physical path, so, in this case:

virtual path means the url address exclude the domain name parts, for instance, the url of www.abc.com/forum/admin/index.php would be /forum/admin.
physical path means from local drive name + path to resourse data, for instance, as your code written in above post.
since then, have a change the Server.MapPath(physical path) statement to Server.MapPath(virtual path).

P.S. FYI, virtual path you provides can be relative virtual path. and you go here to learn more.

- hope this help

Recent Queries:-

change physical path database - 4.61 hr back. (1)
asp the path parameter for the mappath method must be a virtual path. a physical path was used. - 7.69 hr back. (1)
change physical path to virtual path asp - 19.86 hr back. (1)
asp.net find virtual path for .mdb database - 24.29 hr back. (1)
www physical path - 30.28 hr back. (1)
the path parameter for the mappath method must be a virtual path. a physical path was used. - 2.42 hr back. (5)
get virtual path using vbscript - 35.90 hr back. (1)
server.mappath(), asp 0172 (0x80004005) the path parameter for the mappath method must be a virtual path. a physical path was used. - 36.00 hr back. (2)
php physical path to domain name - 39.18 hr back. (1)
determine path of database - 46.61 hr back. (1)
vbscript physical path - 47.57 hr back. (1)
"the path parameter for the mappath method must be a virtual path. a physical path was used." - 56.85 hr back. (1)
the path parameter for the mappath method must be a virtualpath. a physical path was used. - 57.41 hr back. (1)
the path parameter for the mappath method must be a virtual path - 66.37 hr back. (1)

Similar Topics

Keywords : physical, path, database

Best Tools For Website
Building website with database support (6)

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE