Tuesday, August 17, 2010

Microsoft.Jet.OLEDB.4.0 - connection open - can not test in dreamweaver?

Please i need help with Dreamweaver CS3, Windows XP pro running IIS and ASP pages dealing with an access database.





Im using a DNS less connection string:





Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\data.mdb





it works,, but when i press the F12 key to preview what i am doing, i get an error because the connection is already being used by dreamweaver. So if i close dreamweaver, i can see the pages fine... but it is a pain and i know it shouldn't be like this.





i also tried with:


Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\data.mdb





but this does not work even having dreamweaver closed.





Do you know any workaround for this?


Thanks a lot

Microsoft.Jet.OLEDB.4.0 - connection open - can not test in dreamweaver?
The problem is the way Dreamweaver shows you a preview page. Rather than showing you the actual page, it shows you a temp page it makes.





A better fix to your problem is to simply put the file to your server after you edit it, then visit the file's real URL with a browser. For example, if you are working on default.asp, just open default.asp in your browser, and every time you save and put the page on your site, just refresh your browser page.


No comments:

Post a Comment