Testing Online

[hellfreezes]

Hi,

My site works fine offline but when uploaded i get the homepage but when i try
to login i get this message : "ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/index.asp, line 14"

Here is the code :

<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/connectDB.asp" -->
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" +
Server.HTMLEncode(Request.QueryString);
var MM_valUsername=String(Request.Form("username"));
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="";
var MM_redirectLoginSuccess="welcome.asp";
var MM_redirectLoginFailed="loginFail.asp";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_connectDB_STRING;
MM_rsUser.Source = "SELECT username, password";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," +
MM_fldUserAuthorization;
MM_rsUser.Source += " FROM logusers WHERE username='" +
MM_valUsername.replace(/'/g, "''") + "' AND password='" +
String(Request.Form("password")).replace(/'/g, "''") + "'";
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;
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" && false) {
MM_redirectLoginSuccess = Request.QueryString("accessdenied");
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>

any thing to try would be great.

[hellfreezes]

This is the connectDB.asp

<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""

MM_connectDB_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/Database/cheats.mdb")

%>

[Murray *ACE*]

Have you sset up the DSN on the server?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================


"hellfreezes" <webforumsuser@macromedia.com> wrote in message
news:efdgft$bgh$1@forums.macromedia.com...

> This is the connectDB.asp
>
> <%
> // FileName="Connection_odbc_conn_dsn.htm"
> // Type="ADO"
> // DesigntimeType="ADO"
> // HTTP="false"
> // Catalog=""
> // Schema=""
>
> MM_connectDB_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("/Database/cheats.mdb")
>
> %>
>
>

[hellfreezes]

I`m a noob and wouldn`t know how to do that. My host is not helpful at all.

There is ODBC connections and it says to "Create new Data Source" then
"Name:" and "Database path: Home directory for cheatit.co.uk\"

My database is in "Database/" dir and its called cheats.mdb

Does that create a connection to my database from my homepage?

or create a new database?

[Murray *ACE*]

Ask your host to set up a DSN for you. If they are no help, remind them
that you pay for their service (I assume you do). Or consider moving to a
host that will help you.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================


"hellfreezes" <webforumsuser@macromedia.com> wrote in message
news:efds8t$pjq$1@forums.macromedia.com...

> I`m a noob and wouldn`t know how to do that. My host is not helpful at
> all.
>
> There is ODBC connections and it says to "Create new Data Source" then
> "Name:" and "Database path: Home directory for cheatit.co.uk\"
>
> My database is in "Database/" dir and its called cheats.mdb
>
> Does that create a connection to my database from my homepage?
>
> or create a new database?
>
>
>

[hellfreezes]

I was just thinking the same thing.


Can you recommend any good value hosting?

as i`m on a tight budget

thx for the reply

[Murray *ACE*]

Sorry - I tend not to pay attention to the bargain hosts. But you can
probably get plenty of good recommendations here....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================


"hellfreezes" <webforumsuser@macromedia.com> wrote in message
news:efdv94$6c$1@forums.macromedia.com...

>I was just thinking the same thing.
>
>
> Can you recommend any good value hosting?
>
> as i`m on a tight budget
>
> thx for the reply

[Deaf Web Designer]

Be cautious and careful when you look at bargain hosts. Dig further and do some
thorough research for EACH hosts. Some have excellent tech support, some claims
that they have tech support, but are very lousy service.

I like Dreamhost, which is based in southern California and have been very
happy with the service for almost three years. However, I'd leave at that as it
is.