I'm retarded please help

[jegray]

I am very much a beginner in dealing with connection statments. I am getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/default.asp, line 32


Here is my connection include:

<%
FileName="Connection_odbc_conn_dsn.htm"
Type="ADO"
HTTP="false"
Catalog=""
Schema=""
var MM_connCustomers_STRING = "dsn=access_customers2.dsn;"
%>

Here is my javascript page coding:

<%@LANGUAGE="JAVASCRIPT"%>

<!--#include file="Connections/connCustomers.asp" -->
<script language=vbscript runat=server>
cr = Request.Form("cbxRemember")
If (cr = "yes") Then
Response.Cookies("ckPassword") = Request.Form("txtPassword")
Response.Cookies("ckPassword").Expires = Date + 90

End If

</script>
<script language=vbscript runat=server>
cr = Request.Form("cbxRemember")
If (cr = "yes") Then
Response.Cookies("ckUserID") = Request.Form("txtusername")
Response.Cookies("ckUserID").Expires = Date + 90

End If

</script>
<%
var rsLogin = Server.CreateObject("ADODB.Recordset");
rsLogin.ActiveConnection = MM_connCustomers_STRING;
rsLogin.Source = "SELECT * FROM customers";
rsLogin.CursorType = 0;
rsLogin.CursorLocation = 2;
rsLogin.LockType = 3;
rsLogin.Open();
rsLogin_numRows = 0;
%>
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Request.QueryString;
var MM_valUsername=String(Request.Form("txtusername")) ;
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="AccessGroup";
var MM_redirectLoginSuccess="LoginOK.asp";
var MM_redirectLoginFailed="Register.asp";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_connCustomers_STRING;
MM_rsUser.Source = "SELECT ID, UserID, Password, AccessGroup, PA, ITB, PDA, UNV1, UNV2, UNV3, UNV4, UNV5, UNV6, UNV7, ICMS, CFocus, Formation";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
MM_rsUser.Source += " FROM customers WHERE UserID='" + MM_valUsername + "' AND Password='" + String(Request.Form("txtpassword")) + "'";
MM_rsUser.CursorType = 0;
MM_rsUser.CursorLocation = 2;
MM_rsUser.LockType = 3;
MM_rsUser.Open();
if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
// username and password match - this is a valid user
Session("MM_Username") = MM_valUsername;
Session('svID') = MM_rsUser.Fields('ID').Value;
Session('svAccessGroup') = MM_rsUser.Fields('AccessGroup').Value
Session('svPA') = MM_rsUser.Fields('PA').Value;
Session('svITB') = MM_rsUser.Fields('ITB').Value;
Session('svPDA') = MM_rsUser.Fields('PDA').Value;
Session('svUNV1') = MM_rsUser.Fields('UNV1').Value;
Session('svUNV2') = MM_rsUser.Fields('UNV2').Value;
Session('svUNV3') = MM_rsUser.Fields('UNV3').Value;
Session('svUNV4') = MM_rsUser.Fields('UNV4').Value;
Session('svUNV5') = MM_rsUser.Fields('UNV5').Value;
Session('svUNV6') = MM_rsUser.Fields('UNV6').Value;
Session('svUNV7') = MM_rsUser.Fields('UNV7').Value;
Session('svICMS') = MM_rsUser.Fields('ICMS').Value;
Session('svFocus') = MM_rsUser.Fields('CFocus').Value;
Session('svFormation') = MM_rsUser.Fields('Formation').Value;
if (MM_fldUserAuthorization != "") {
Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorizati on).Value);
} else {
Session("MM_UserAuthorization") = "";
}
if (String(Request.QueryString("accessdenied")) != "undefined" && true) {
MM_redirectLoginSuccess = Request.QueryString("accessdenied");
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>
<script language=vbscript runat=server>
' *** Set A Session Variable
' *** MagicBeat Server Behavior - 2006 - by Jag S. Sidhu - www.magicbeat.com

</script>

The site is bieng hosted by godaddy and a valid dsn is in place under the name:
access_customers2.dsn

Please help this is driving me nuts. It will serve to be a login and customer information update.

Thanks

[PEB]

I think that you can use the ODBC to link your external tables fto Access and then you can treat them as an ordinary Acces table :)

[miata718]

I got the same problem like u, unfortunately godaddy.com's tech support is helpless, plus no refund if cancel, totally rip off. I beleive godaddy.com should help us to setup the site and make it work in order to earn our business.

I am very much a beginner in dealing with connection statments. I am getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/default.asp, line 32


Here is my connection include:

<%
FileName="Connection_odbc_conn_dsn.htm"
Type="ADO"
HTTP="false"
Catalog=""
Schema=""
var MM_connCustomers_STRING = "dsn=access_customers2.dsn;"
%>

Here is my javascript page coding:

<%@LANGUAGE="JAVASCRIPT"%>

<!--#include file="Connections/connCustomers.asp" -->
<script language=vbscript runat=server>
cr = Request.Form("cbxRemember")
If (cr = "yes") Then
Response.Cookies("ckPassword") = Request.Form("txtPassword")
Response.Cookies("ckPassword").Expires = Date + 90

End If

</script>
<script language=vbscript runat=server>
cr = Request.Form("cbxRemember")
If (cr = "yes") Then
Response.Cookies("ckUserID") = Request.Form("txtusername")
Response.Cookies("ckUserID").Expires = Date + 90

End If

</script>
<%
var rsLogin = Server.CreateObject("ADODB.Recordset");
rsLogin.ActiveConnection = MM_connCustomers_STRING;
rsLogin.Source = "SELECT * FROM customers";
rsLogin.CursorType = 0;
rsLogin.CursorLocation = 2;
rsLogin.LockType = 3;
rsLogin.Open();
rsLogin_numRows = 0;
%>
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Request.QueryString;
var MM_valUsername=String(Request.Form("txtusername")) ;
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="AccessGroup";
var MM_redirectLoginSuccess="LoginOK.asp";
var MM_redirectLoginFailed="Register.asp";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_connCustomers_STRING;
MM_rsUser.Source = "SELECT ID, UserID, Password, AccessGroup, PA, ITB, PDA, UNV1, UNV2, UNV3, UNV4, UNV5, UNV6, UNV7, ICMS, CFocus, Formation";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
MM_rsUser.Source += " FROM customers WHERE UserID='" + MM_valUsername + "' AND Password='" + String(Request.Form("txtpassword")) + "'";
MM_rsUser.CursorType = 0;
MM_rsUser.CursorLocation = 2;
MM_rsUser.LockType = 3;
MM_rsUser.Open();
if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
// username and password match - this is a valid user
Session("MM_Username") = MM_valUsername;
Session('svID') = MM_rsUser.Fields('ID').Value;
Session('svAccessGroup') = MM_rsUser.Fields('AccessGroup').Value
Session('svPA') = MM_rsUser.Fields('PA').Value;
Session('svITB') = MM_rsUser.Fields('ITB').Value;
Session('svPDA') = MM_rsUser.Fields('PDA').Value;
Session('svUNV1') = MM_rsUser.Fields('UNV1').Value;
Session('svUNV2') = MM_rsUser.Fields('UNV2').Value;
Session('svUNV3') = MM_rsUser.Fields('UNV3').Value;
Session('svUNV4') = MM_rsUser.Fields('UNV4').Value;
Session('svUNV5') = MM_rsUser.Fields('UNV5').Value;
Session('svUNV6') = MM_rsUser.Fields('UNV6').Value;
Session('svUNV7') = MM_rsUser.Fields('UNV7').Value;
Session('svICMS') = MM_rsUser.Fields('ICMS').Value;
Session('svFocus') = MM_rsUser.Fields('CFocus').Value;
Session('svFormation') = MM_rsUser.Fields('Formation').Value;
if (MM_fldUserAuthorization != "") {
Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorizati on).Value);
} else {
Session("MM_UserAuthorization") = "";
}
if (String(Request.QueryString("accessdenied")) != "undefined" && true) {
MM_redirectLoginSuccess = Request.QueryString("accessdenied");
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>
<script language=vbscript runat=server>
' *** Set A Session Variable
' *** MagicBeat Server Behavior - 2006 - by Jag S. Sidhu - www.magicbeat.com

</script>

The site is bieng hosted by godaddy and a valid dsn is in place under the name:
access_customers2.dsn

Please help this is driving me nuts. It will serve to be a login and customer information update.

Thanks

[Cori]

jegray did you ever find the solution? It's been years since I've used ASP and I usually used VBScript not Javascript. Any help that goDaddy has provided has been with examples of VBScript and they say it's a coding issue and won't help. bleh to them! :)

I have pretty much the same problem where "Data source name not found and no default driver specified" is the error I get.

My code looks similar to above, any thoughts from anyone on what is missing?

Thanks, Cori