I am not sure about my Access DSN connection..

[yoni]

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:

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.

[jerrydigital]

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:

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

[brazenskies]

It's more than likely an error in your connection string!

You'll need to post your code