Error 80004005 - Unspecified error ? HELP! 1

[JewelsInVa]

Here's my problem:
The website was working fine all last week, and then today, when I needed to make sure all things were ready to go for launching the website, I get this error. I get it when I click on any of the pages that involve opening the database.

I just don't understand why it doesn't work now, though, since we haven't changed a thing. It's sporadic, since sometimes the page will load, sometimes not, and then sometimes refreshing, the page will load/sometimes not.

Provider error '80004005'

Unspecified error

ProfileEntry.asp, line 10

Anyone know what might be the problem?

 

[onpnt]

do you have the code in reference?

sounds like a permission or connection string issue _______________________________________________
_{{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }}
_______________________________________________
for the best results to your questions: FAQ333-2924

http://www.onpntw

 

[JewelsInVa]

Line 9 - Set DatabaseConnection = Server.CreateObject ("ADODB.Connection&quot
Line 10 -DatabaseConnection.Open "LegAppSurvey"

It (the database) has the default privelages, and we haven't had any problems entering/displaying data on the pages until now.

Thanks for helping me.

 

[onpnt]

my advice, go to a DSN-Less connection
there has got to be a error in the DSN set up or such. either that or there is a error else where in the code that is pointing to the open statement. _______________________________________________
_{{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }}
_______________________________________________
for the best results to your questions: FAQ333-2924

http://www.onpntw

 

[JewelsInVa]

Thanks for you help , but I am a little confused by "DSN-Less", I didn't think a database driven site would work without it. Oh well. I'll play with it some more and see what happens.

 

[onpnt]

there's two way to connect to your databases
DSN and DSN-Less connections
your's a DSN connection being
DatabaseConnection.Open "LegAppSurvey"
can be replaced by the more common and faster connection of a DSN-Less connection. the best advantages are you don't have to set the DSN up and it is faster and basically all around more efficient.
syntax for a DSN-Less connection is simple
here's a access example
set cnn = server.createobject("ADODB.Connection&quot
cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\database.mdb"

or the OLE DB method

set cnn = server.createobject("ADODB.Connection&quot
cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:\database.mdb"

the first should only be used for small applications as it is not very reliable and causes unexpected errors also is more but is version compatible.





_______________________________________________
_{{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }}
_______________________________________________
for the best results to your questions: FAQ333-2924

http://www.onpntw

 

[onpnt]

Should have added teh first method is a ODBC connection string. the one that can often cause unable to open registry key and unspecified errors _______________________________________________
_{{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }}
_______________________________________________
for the best results to your questions: FAQ333-2924

http://www.onpntw

 

[JewelsInVa]

Just to add that the problem disappeared and all I did was remove the DSN from the server, reboot, add it again, and reboot. Not sure the significance here. But it did the trick for now. I researched this error on a couple forums, and it's really sporadic. I hope this may be of some help to others.

Thanks for your help too, because I will look into it when working on my other current project.