Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Apr 2007
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I am not sure about my Access DSN connection..

    Hi all.
    I am using GoDaddy.com's hosting service.
    I am not sure if the problem is my code or their server.

    I use the following code as my connection to the Access Database:
    Code:
    dsn_name = "access_IsraelPharm.dsn"
    sDSNDir = Server.MapPath("_dsn")
    connectstr = "filedsn=" & sDSNDir & "/" & dsn_name
    Set oConn = Server.CreateObject("ADODB.Connection")
    oConn.Open connectstr
    
    qry = "SELECT * FROM Drugs"
    Set oRS = oConn.Execute(qry)
    oRs.close
    Set oRs = nothing
    Set oConn = nothing
    The thing is that sometimes it works and sometimes it does not.
    When I first load the page, it works. If I then click Refresh, I get
    Provider error '80004005'

    Unspecified error

    /makeanorder.asp, line 7
    If I then wait a few minutes and click refresh again, it might work....and so forth and so forth.

    So, My question is....
    Is the problem in my code (is something being left open, that is causing the failure) or is my problem on their end?

    Thanks.

  • #2
    New to the CF scene
    Join Date
    Oct 2008
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hello,

    I am having the same problem with godaddy.com.

    Their customer service reps say they cannot assist in 3rd party coding issues so they are no help at all.

    The error I get is:

    Provider error '80004005'
    Unspecified error

    and this error points me towards the following line of code:

    Code:
    oConn.Open connectstr
    is this a server error caused by godaddy? or is there some weird issue with my code. It has worked perfectly before and was working yesterday. But, today I got this error without making any changes. Any help would be greatly appreciated. I don't want to continue using godaddy if this error is on their end.

    Jerious

  • #3
    Regular Coder
    Join Date
    May 2008
    Location
    Oxford, UK
    Posts
    422
    Thanks
    14
    Thanked 27 Times in 27 Posts
    It's more than likely an error in your connection string!

    You'll need to post your code


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •