#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    1
    Rep Power
    0

    Classic ASP Code (connection string) cannot work on Windows 7 64 bit


    Hi All,
    I have a program that is working 5 yrs ago. (on Windows XP 32 bit. It was decommissioned and now we need to put it back to service on Windows 7 64 bit platform.

    I keep having issue with the connection. Any help would be appreciated!

    http://www.iis.net/learn/application-frameworks/running-classic-asp-applications-on-iis-7-and-iis-8/using-classic-asp-with-microsoft-access-databases-on-iis

    Regards,
    Nironto

    Code:
    set conntemp=server.createobject("adodb.connection")
    conntemp.connectionstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\inetpub\wwwroot\car\car.mdb" 
    conntemp.Open
    "Error below"
    --------------------------------
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    /car/record.asp, line 136
    -------------------------------
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,428
    Rep Power
    4539
    If you have a version of windows 7 that offers XP mode virtualization that may work.

    The access drivers aren't automatically installed in windows 7, and I don't know if there are even any 64bit drivers for Access and Windows 7. Make a visit to the microsoft website and see what's available.

    Comments on this post

    • Nironto agrees
    ======
    Doug G
    ======
    The man who doesn't read good books has no advantage over the man who can't read them.
    --Mark Twain
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    1
    Rep Power
    0
    You certainly have set the office?
    or you can use my code below
    PHP Code:
    Set rsconnect=Server.CreateObject("ADODB.Connection")
    partconnect="PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE=" SERVER.MAPPATH("folder\folder\databasename.mdb")
    rsconnect.Open partconnect 

IMN logo majestic logo threadwatch logo seochat tools logo