ODBC error 80004005 on server

[michaelinitaly]

When I run my site on my local server no problem, when run it a www.comeseeitaly.com (pick any lanugage) get the following.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/home.asp, line 15

Line 15 is "Menu.ActiveConnection = MM_access_adventure_STRING"
which is calling my connection page "access_adventure.asp" which has the following

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_access_adventure_STRING
MM_access_adventure_STRING = "dsn=access_adventure;"
%>


I have called Godaddy about 5 times and all the guys can say is "script error" like little robots. I asked them why they think this and they say look it points to line 15 in the error code ... Everything I have found on the web regarding this error normaly points to user permission errors on the users machine. As I said before, it runs fine on my local server.
any help would be great.

[Newsgroup_User]

Did you create the DSN on the server machine and connect to it .. and yes ..
set the permissions, but that's usually a different error. This one is not
finding the connection at all.


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: Dreamweaver CS3: The Missing Manual,
DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"michaelinitaly" <webforumsuser@macromedia.com> wrote in message
news:f8a3se$4bi$1@forums.macromedia.com...
> When I run my site on my local server no problem, when run it a
> www.comeseeitaly.com (pick any lanugage) get the following.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
>
> /home.asp, line 15
>
> Line 15 is "Menu.ActiveConnection = MM_access_adventure_STRING"
> which is calling my connection page "access_adventure.asp" which has the
> following
>
> <%
> ' FileName="Connection_odbc_conn_dsn.htm"
> ' Type="ADO"
> ' DesigntimeType="ADO"
> ' HTTP="false"
> ' Catalog=""
> ' Schema=""
> Dim MM_access_adventure_STRING
> MM_access_adventure_STRING = "dsn=access_adventure;"
> %>
>
>
> I have called Godaddy about 5 times and all the guys can say is "script
> error"
> like little robots. I asked them why they think this and they say look it
> points to line 15 in the error code ... Everything I have found on the web
> regarding this error normaly points to user permission errors on the users
> machine. As I said before, it runs fine on my local server.
> any help would be great.
>

[michaelinitaly · Accepted solution]

Thank you Nancy, I did create the dsn and I have been telling the support staff all along that the problem is with the dsn. They just keep repeating like drones.. script error script error... I keep telling them that line 15 is just calling the dsn and gets no response.. their response.. script error.. anyway I have just gone in and created a dsn less connection and the site is up. Thank you for your help.