Skip to main content
L
Ludi5C3C
Participant
August 31, 2020
Question

DB connection

  • August 31, 2020
  • 2 replies
  • 360 views

I use Dreamweaver CS4, ASP, an Access database and a web space via Aruba with a purchased domain:
Some time ago I had a site of a commercial nature, within which I had also created protected pages using the Dreamweaver tools, complete with connection to the Access database. I used the connection string method to connect to the database where the ID and pass were fetched to access these pages. Everything has always worked properly.
Then I closed the site.
Now I have bought a new domain with its web space always on Aruba. I have tried to make protected pages with the same method again, but when I try to connect to the database, the connection doesn't work. Tried and tried, but nothing. Has something changed?
The connection string is as follows:
"driver = {Microsoft Access Driver (* .mdb)}; dbq =" & Server.MapPath ("/ data / database.mdb")
Hope someone can answer and maybe help solve the problem.
Thank you

    This topic has been closed for replies.

    2 replies

    Nancy OShea
    Community Expert
    Nancy OSheaCommunity Expert
    Community Expert
    August 31, 2020

    I agree with everything Ben_M said.

     

    I'll also add, ASP is 20+ year old technology.  I'm not sure if Visual Studio can support classic ASP anymore. And the Access database is not good on the web.  It's too slow compared with SQL and other server-side databases. 

    See this tutorial on creating dynamic web pages with ASP.NET and SQL data.

    https://www.tutorialspoint.com/asp.net_wp/asp.net_wp_overview.htm

     

    Nancy O'Shea— Product User & Community Expert
    L
    Ludi5C3CAuthor
    Participant
    September 9, 2020

    Thank you. I know that that is an older program. That's what I used in fact 20 years ago. But I had a site that still worked until a couple of years ago. I thought I could still use it. Access worked fine, as the database was only meant to verify ID and password. Thanks for the tip anyway

    Nancy OShea
    Community Expert
    Nancy OSheaCommunity Expert
    Community Expert
    September 9, 2020

    20 year old technology is obsolete. You have much catching up to do.  If you don't have a lot of IDs and passwords, you could put them in a flat file (XML, JSON or CSV).

     

    Nancy O'Shea— Product User & Community Expert
    B
    Community Expert
    Ben MCommunity Expert
    Community Expert
    August 31, 2020

    DW CS4 is 12 years old so a lot has changed since then which includes Adobe dropping support for ASP and .NET. It was not being updated enough and was deprecated a few versions back so you are likely running into an issue where your web host has continued to update their server to the current ASP standards and your version of DW is outdated.  If you are trying to develop in ASP/.NET I would recommend looking into the latest release of Visual Studio ( https://visualstudio.microsoft.com ).  

    L
    Ludi5C3CAuthor
    Participant
    September 9, 2020

    Thanks a lot. It was what I supposed. What do you think about KompoZer?

    B
    Community Expert
    Ben MCommunity Expert
    Community Expert
    September 9, 2020

    That software is older than most versions of Dreamweaver and wouldn't help with your ASP issue and hasn't been actively developed in almost a decade. For the development you need, only Visual Studio will likely solve your issue.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices