Question
Database problem, Please help
I have a simple login page made through Dreamweaver cs4, I
used access for the database, and Im running a coldfusion 8 server.
when I test the page on the testing server, I get redirected to the "Login Fail" page I created.
On the remote server I get...
Datasource nmelogin.mdb could not be found.
The error occurred in D:\home\nmemob.com\wwwroot\nme_mob_pages\nme_members_login.cfm: line 4
2 : <cfset MM_redirectLoginSuccess="doc/nme_mob_pages.cfm">
3 : <cfset MM_redirectLoginFailed="nme_invalid_login.cfm">
4 : <cfquery name="MM_rsUser" datasource="nmelogin.mdb">
5 : SELECT Field1,Field2,ID FROM Table1 WHERE Field1=<cfqueryparam value="#FORM.name#" cfsqltype="cf_sql_clob" maxlength="255"> AND Field2=<cfqueryparam value="#FORM.password#" cfsqltype="cf_sql_clob" maxlength="255">
6 : </cfquery>
Can anyone tell me what Im doing wrong?
when I test the page on the testing server, I get redirected to the "Login Fail" page I created.
On the remote server I get...
Datasource nmelogin.mdb could not be found.
The error occurred in D:\home\nmemob.com\wwwroot\nme_mob_pages\nme_members_login.cfm: line 4
2 : <cfset MM_redirectLoginSuccess="doc/nme_mob_pages.cfm">
3 : <cfset MM_redirectLoginFailed="nme_invalid_login.cfm">
4 : <cfquery name="MM_rsUser" datasource="nmelogin.mdb">
5 : SELECT Field1,Field2,ID FROM Table1 WHERE Field1=<cfqueryparam value="#FORM.name#" cfsqltype="cf_sql_clob" maxlength="255"> AND Field2=<cfqueryparam value="#FORM.password#" cfsqltype="cf_sql_clob" maxlength="255">
6 : </cfquery>
Can anyone tell me what Im doing wrong?
AdChoices