ODBC Drivers error '80004005'

need help

[Ecstacy]

I am having the following error in asp page while connecting to the sql server.
<!---
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/parimal/software_subscription/include/dsnless_conn.inc, line 9
--->

Can anyone help me to solve it.

[Avellar]

Do you have a connection string specified that looks something like this:

dim conx

conx = "Provider=SQLOLEDB; DATASOURCE="yoursqlserver.thedomain.com";DATABASE=yourdatabasename;UID=yoursqluserid;PWD=yoursqlpassword"

[TallTroll]

The other possible candidate is not having set up an ODBC link on the server with the correct name (watch capitalisation). If the site works locally, but not remotely, that would be my bet on the info so far

[RZaakir]

Please post the code in dsnless_conn.inc

Be sure to substitute your server and passwords with x's or something.