Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Database connection

Posted 31 Jan 2006 00:03:36
1
has voted
31 Jan 2006 00:03:36 asim khan posted:
Hi

i am try to establish a coonection to access datadase , but everytime i try to click on Build button from database panel in dreamweaver Mx. nothing happend. Dont know wat to do?

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.
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

Reply to this topic