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