UltimatePollASP - ODBC Drivers error '80004005'

[BASIC]

I get this error "Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
/UltimatePollASP/Include/constants_inc.asp, line 18 "

when I try to start UltimatePollASP from my browser.

Set up of the application went well all necessarily files uploaded.

Can someone please advice me what I might be overlooking.

Thanks in advance folks.

Regards

EP

[administrator]

Usually this occurs when one of the following occurs

1. The SQL database referenced by the connection string does not exist
2. The login referenced in the connection string is using an invalid password, doesn't have access to the database, or is simply invalid or disabled
3. Your connection string is otherwise malformed.

[BASIC]

Thanks for your reply...


1. The SQL database referenced by the connection string does not exist
ANS - 1. The database does exist

2. The login referenced in the connection string is using an invalid password, doesn't have access to the database, or is simply invalid or disabled

ANS - 2. The login referenced in the connection string is working OK as currently I am running other applications on the same database using the same connection string.

3. Your connection string is otherwise malformed.
ANS - 3. I followed the instructions provided by prezzatech on configuring the connString file in the includes folder.

Note: When you look at the error it mentions line 18 and something to do with the CONSTANTS, could this be where the problem is?

[administrator]

Likely the new tables were created with a different owner than the rest of your database....The next thing to test is to use Query Analyzer (or another SQL tool) to see if you can successfully query the Ultimate Poll tables. Most likely, the user you are using does not have permissions...Assuming you have knowledge of SQL permissions, you could also just check the permissions on the Ultimate Poll tables so that whatever user you are connecting with has full permission.

[BASIC]

Thanks to you all.

All is working now.

I solved the problem by making sure that I use an IP when refering to my live server.

I am so happy now.

[kumara]

Usually this occurs when one of the following occurs

1. The SQL database referenced by the connection string does not exist
2. The login referenced in the connection string is using an invalid password, doesn't have access to the database, or is simply invalid or disabled
3. Your connection string is otherwise malformed.

I am having the same error. Don't know how to access and correct this as per the aobve. Can you please tell me more details please ? How to go about fixing this? Thanks