database connection

leonardpogrady · January 28th, 2010, 03:32 AM

The priority issue is the dsn less database connection. I have attempted to use the following in the connection wizard-

Code:

MM_dsnname_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
   "Data Source=" & Server.Mappath("../db/products.mdb") & ";" & _ 
   "User Id=admin;" & _
   "Password="

Above is exactly how I copied into the connection wizard box in one line. Do I need to alter this to suit my set up and include the actual path to the database, I have attempted this and it still does not work.

Imar · January 29th, 2010, 11:22 AM

Hi Leonard,

Take a look at this:

Server.Mappath

This is ASP code that executes at run-time. I don't think that DW is able to handle that at design time... Can't recall exactly, though. It's been a while since I worked with DW... ;-)

Imar