oConn.Open connectstr error

[jerrydigital]

Hi,

My website was working perfectly for the past week but now I am getting an error without making any changes. I am using Godaddy as my server provider.

The error occurs on the line of code below:

oConn.Open = connectstr

Have you heard of other godaddy clients that have this error? when i contact them, they are no help at all. they tell me they can't help with 3rd party scripting but my code was working just fine yesterday.

[DrBunchman]

Hi Jerry,

If you haven't made any changes to your scripts then GoDaddy must have done something at their end.

What's the error that you are getting?

Dr B

[jerrydigital]

Hi, the error code I get is:

Provider error '80004005'

Unspecified error

/accountpage.asp, line 23


It seems to occur if I upload my webpages to the ftp client but forget to upload my access database. When i attempt to login, I get an error and realize I forgot to upload my database. After I reload all my pages on the ftp client including the database, that's when I get the error code above.

The problem is, I cannot seem to figure out how to fix this. I delete my dsn and recreate another one several times and usually it starts working after a few hours. I contacted godaddy but they just don't try or have no clue what's going on and tell me they cannot help me. It's pretty frustrating to say the least.

Any idea why this occurs and any quick fixes to enable me to get my website back online?

Thanks - Jerry

[DrBunchman]

Hi Jerry,

Sounds like a tricky one as it doesn't seem to be a consistent problem. I've googled that error message and found this:

80004005, Microsoft OLE DB Provider for ODBC Driver Error 80004005, Microsoft Jet Database Engine Error 80004005, Error 80004005, Provider Error 80004005

Is there anything here which helps you?

Does the website normally work if you don't forget to upload the database when making changes?

Dr B

[GazMathias]

You might also want to check if all connection to the DB are being closed properly.

Gaz.

[jerrydigital]

Thanks for your responses. It is the craziest thing. My website is running beautifully today. The problem only occurs if I delete all my web pages and my database off of the ftp client. Then load them again and try to login to my web page without loading the database.

If I load the database along with the web pages, it works fine. It only gives me the error I mentioned if I forget to add the database. The problem is, after I get the error, it doesn't fix itself when I load the database. I reset the dsn a few times and usually it works a day later.

It seems like the server freezes my account for a certain amount of time or something to that extent. However, my server host, Godaddy.com, doesn't have any answers. Kind of frustrating but if I am not forgettful, everything works. So, my solution is to have a sticky note on my computer telling me to remember to load the database.

I really appreciate everyone's help on this board. You have no clue how much you helped me along my journey to get my first asp website up and running. When I started, I had no clue what asp was. But I stumbled across bytes.com and now I have an online business. Keep up the great work!

Jerry