I am fairly new to using Dream Weaver MX 2004 for application use in websites. I am working on a site hosted by an ISP who does not support system DSN, only file DSN. I am trying to make a connection to my db's (I can create DSN if needed) and am struggling with the connection string.

When I do get connected to my db, only some of the functions actually work. I can do basic inserts of record sets, but when I try to create user authenticaion through a login form, I click submit and it gives me an error page.

Here is the connection string I am using:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPat("/access_db/press.mdb"

I am using ASP/VB for the server technologies. Am I just screwing up my pages, or is there something I am missing.

Any help is greatly appreciated.

_______________________
Joe Schaffer
Schaffer Technologies
www.schaffertechnologies.com

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPat<b>h</b>("/access_db/press.mdb"

Sorry, I had the typo in the message. In the connection string I am using it is correct. I think the issue may be that the db is requiring a username and password, and I do not have that in the connection string. It may not need the username and password to retrieve data, but to put it.

Is there code to add username and password to the connection string?

_______________________
Joe Schaffer
Schaffer Technologies
www.schaffertechnologies.com