Wednesday, August 5, 2009

MS Access DB & Dreamweaver 8?

Hello,



I created an Access Database and I%26#039;m using DW8 as my web authoring tool. I was able to make a connection to the database with DW and even created recordsets, but when I try to preview the .ASP page I created with the dynamic content using the testing server , nothing displays. I%26#039;m using Apache for the Web Server. I uploaded the page and the DB to my hosting server to see if it was something with my PC, but the same thing occurs online.



MS Access DB %26amp; Dreamweaver 8?





First a little advice. Post your code it helps troubleshoot the issue.



If you are using apache, my advice is to switch to MySQL. You can export your Access database to a comma seperated value and then import it into MySQL. There are some MySQL gui engines that are very similar to SQL Server Enterprise Edition.



It could be your connection string or the way you are opening and closing the connection. If you are running this on Linux, you might find PHP easier to use.



Here are some helpful resources:



ASP:



http://www.asp101.com - review the samples for help



ADO: (for connection strings)



http://www.carlprothman.net/Default.aspx...



PHP:



http://www.php.net/docs.php - Good online documentation



Make sure you use server.createobject to make your ado connection to the database and recordset.



Hope this help you a little.

No comments:

Post a Comment