Question
80004005 asp using javascript
i am using dreamweaver mx with ms_access. I set up an asp
page that works great when I run it locally on my own system. I
upload this page to my host and BAM. I get an error.
---------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/Car_Gallery.asp, line 12
-----------------------
I know this means I can connect to the database. The permissions appear to be correct. So now I dont know what to do... here is the first few lines of my webpage.
---------------------------------
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/myCars.asp" -->
<%
var csCars__MMColParam = "Y";
if (String(Request("MM_EmptyValue")) != "undefined" &&
String(Request("MM_EmptyValue")) != "") {
csCars__MMColParam = String(Request("MM_EmptyValue"));
}
%>
<%
var csCars = Server.CreateObject("ADODB.Recordset");
csCars.ActiveConnection = MM_myCars_STRING;
----------------------------------------
Connections/myCars.asp has the following code.
___________________________
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_myCars_STRING = "dsn=myCars;"
%>
_______________________
Everything looks good to me but I always get the same error. Where should I start to debug this error? could i write a small page to determine where my site is breaking? does the Connections/myCars.asp need to be in a different directory. my root directory on the server is at: automixm/wwwRoot/connections/ and my webpages are in automixm/wwwRoot/ *.
Any help would be great. thanks
---------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/Car_Gallery.asp, line 12
-----------------------
I know this means I can connect to the database. The permissions appear to be correct. So now I dont know what to do... here is the first few lines of my webpage.
---------------------------------
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/myCars.asp" -->
<%
var csCars__MMColParam = "Y";
if (String(Request("MM_EmptyValue")) != "undefined" &&
String(Request("MM_EmptyValue")) != "") {
csCars__MMColParam = String(Request("MM_EmptyValue"));
}
%>
<%
var csCars = Server.CreateObject("ADODB.Recordset");
csCars.ActiveConnection = MM_myCars_STRING;
----------------------------------------
Connections/myCars.asp has the following code.
___________________________
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_myCars_STRING = "dsn=myCars;"
%>
_______________________
Everything looks good to me but I always get the same error. Where should I start to debug this error? could i write a small page to determine where my site is breaking? does the Connections/myCars.asp need to be in a different directory. my root directory on the server is at: automixm/wwwRoot/connections/ and my webpages are in automixm/wwwRoot/ *.
Any help would be great. thanks
AdChoices