Forums
This topic is locked
Database connection
Replies
Replied 31 Jan 2006 20:20:49
31 Jan 2006 20:20:49 Mike Mitchell replied:
Create the Access database in Access (don't use a password right now - you can always create one later).
Place it in the directory on your Webserver.
Follow Dreamweaver's instructions on how to create a DSN.
Try again. Usually, I find that most often the trouble is that my IIS is not properly processing the wwwroot directory.
Good luck.
Place it in the directory on your Webserver.
Follow Dreamweaver's instructions on how to create a DSN.
Try again. Usually, I find that most often the trouble is that my IIS is not properly processing the wwwroot directory.
Good luck.
Replied 01 Feb 2006 05:35:23
01 Feb 2006 05:35:23 Javier Castro replied:
Try creating a DNS-less connection, it is supposse to be the way to go. I use it and have no problems. here is a sample code:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\websitefolder\databasefolder\databasename.mdb;"
Inetpub is where IIS stores your websites, then you have your website folder, then the database folder and lastly the database filename.
Good luck.
If you still have some doubt try this link, they explain nicely how to do it:
www.ultradevguru.com/tutorial/dsnless.htm
Cheers,
Javier
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\websitefolder\databasefolder\databasename.mdb;"
Inetpub is where IIS stores your websites, then you have your website folder, then the database folder and lastly the database filename.
Good luck.
If you still have some doubt try this link, they explain nicely how to do it:
www.ultradevguru.com/tutorial/dsnless.htm
Cheers,
Javier