Help on Error '80004005 : 80004005'

[metaGenes]

Hi,

I'm having some probs here. i can load ASP pages on abyss web server, but when it wanna connects to a database, the following errors came out. Can anyone help me??? :?

I'm running abyss web server on Win XP.

Realli appreciate ur help.

Thanks! :)

Microsoft OLE DB Provider for ODBC Drivers- Error '80004005 : 80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

[aprelium]

This error means that something went wrong when the script you use was talking to ODBC driver which is responsible for accessing the Database.

You may find a similar issue and its workaround in http://www.macromedia.com/support/ultradev/ts/documents/sqlsetconnect.htm .
_________________
Support Team
Aprelium - http://www.aprelium.com

[metaGenes]

tks for ur reply.

but i still cant get the things working. it still cant connect to an access database. any idea wat can i do?? :(

Thanks alot.

[anna]

I have had this problem and it usually tells you what is missing. a .inc file etc. it should tell you what page the error is on and what line.

Open your code and look at it to make sure everything is correct. or you may have to move some files around.

that should help
If not I don't know.
Take care,
Anna

[mcwilliams132]

This could be a few problems...

#1...you don't have a System DSN connection created in the ODBC manager in windows. The DSN needs to have the path to the database you're using, whether it be an Access db or mySQL...

#2...you're connction string is wrong. make sure passwords and usernames match up. make sure you're creating a connection as:

myConn = Server.CreateObject("ADODB.Connection")

#3...you're missing the adovbs.inc file which has all the cryptic ADO constants -- so you don't have to remember them. you can download it at most ASP related sites or just do a search for the file on google.com. use it as a include file at the top of your page.
_________________
::::::::::::::::::::::::::::::::::::::::::::::::::
:: Jon-Paul LeClair
:: http://mcwilliamsworld.com
:: "Lobster sticks to magnet!"

[metaGenes]

hey guys,

thanks for the help. I will try them and see if my asp is working now.

thanks again! :D