PDA

View Full Version : setup DSN


Renoaccessprogrammer
11-08-2004, 08:36 AM
As for DSN, you can setup DSN for your access databases in the control panel. You will have to recode the database connection string in your website.





How do i recode this in Dreamweaver mx does anyone know where there ay be a tutorial about this. I have the asp web site working perfect on my computer with a local host and remote host folders set up. Now its time to upload it and i have no idea how to.





I have lots of Access experience but little asp experience.

bruce
11-08-2004, 10:08 AM
I suggest you OleDB (or DSNLess connection). see http://kb.discountasp.net/article.aspx?id=10191

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

Renoaccessprogrammer
11-08-2004, 10:14 AM
Where do i add this code to?

bruce
11-09-2004, 08:58 AM
In your page that connect to the db.,

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

Renoaccessprogrammer
11-09-2004, 09:02 AM
ok, i figured it out but now there seems to be another problem with the site, it says the database connection cannot be longer than 10 characters so i will have to change it on over 30 pages. So it'll be awhile. But thanks for your help