logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > ASP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 01-03-2009, 03:29 AM   #1
mtrueblood
 
Join Date: Jan 2009
Location: Southeast Michigan
Posts: 1
Angry Issue with ASP pages NOT displaying with my GoDaddy hosted site

I initially developed my site on my local machine. The site worked like a charm. Now that I have uploaded my site, the dynamic pages do not display. I get the following error:

Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/sitename/contactus/index.asp, line 130

I have since created the "access_db" folder, moved my database to that folder, and generated a new DSN within my GoDaddy hosting account. Both had to be done to have my site hosted.

My connection.asp page code is:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connNAME_STRING
MM_connNAME_STRING = "dsn=access_alpha.dsn;"
%>

The error comes from the contact us page. I have copied a piece of the code where the error is calling from:

line 129
Set rs_contactus = Server.CreateObject("ADODB.Recordset")

line 130
rs_contactus.ActiveConnection = MM_connNAME_STRING

line 131
rs_contactus.Source = "SELECT * FROM tbl_contactus ORDER BY ID DESC"

Please help! I am not sure where to go from here....

Thanks - Matt
mtrueblood is offline   Reply With Quote
Old 01-03-2009, 05:13 PM   #2
domedia
Administrator
domedia's Avatar
 
Join Date: Dec 2003
Posts: 9,730
Default

Moving to the ASP forum
domedia is offline   Reply With Quote
Old 01-11-2009, 04:15 AM   #3
mangofreak
mangofreak's Avatar
 
Join Date: Jan 2006
Location: Toronto-Canada
Posts: 444
Default

Your connection string may not be right. Check this out to figure out your options:

http://www.connectionstrings.com/

For what I can see your connection string points to a local database. You need to do a mappath connection if the database is in the same directory as your files or find out what your database physical address is. You can find this by asking your provider or may be in the documentation of your webshost. Also there is a little code that may help here:

http://www.ultradevguru.com/tutorial/dsnless.htm
__________________
J.
DW | FW | HTML | CSS | ASP | some PHP | Windows | Ubuntu
mangofreak is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:38 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com