Has Someone used Brinkster? Need Help!

[RJL1]

I got my site built with a lot of help from SCHASE and all the people that have answered my questions. I have one final question for this project. I got an account with Brinkster but have run into trouble setting the db connection to work. I followed 2 different tutorials on the web and have read their FAQ but still cannot get it to work. Has anyone used Brinkster that might have some suggestions.

Thanks
RJL1

 

[schase]

yeah I have

hang on lemme see. "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[schase]

ok, now it's been awhile, but we can figure it out.

MM_myconnection_STRING= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/username/db/Data_Base_Name_Here.mdb&quot

Obviously change the myconnection and username and data_base_name_here to reflect your stuff. "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[RJL1]

This is hwo my files looks

<%
// FileName=&quot;Connection_ODBC_conn_dsn.htm&quot;
// Type=&quot;ADO&quot;
// DesigntimeType=&quot;ADO&quot;
// HTTP=&quot;false&quot;
// Catalog=&quot;&quot;
// Schema=&quot;&quot;
var MM_login_STRING = &quot;dsn=login;&quot;
%>

Thanks
RJL1

 

[schase]

are you on the free account or the paid one? &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[RJL1]

I'm on the free account until the 1st of the year. I will switch to the paid or might go with stormhost. For the time I will use Brinkster (FREE) for testing.

Thanks
RJL1

 

[schase]

ok, the free accounts only have DSN-less connections.

so make your connection page something like this.

<%
// FileName=&quot;Connection_ODBC_conn_dsn.htm&quot;
// Type=&quot;ADO&quot;
// DesigntimeType=&quot;ADO&quot;
// HTTP=&quot;false&quot;
// Catalog=&quot;&quot;
// Schema=&quot;&quot;
var MM_login_STRING = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & Server.MapPath(&quot;/username/db/login.mdb&quot
%>

I'm assuming that login is the database name.

Change username to whatever your username is.

give er a go and let us know. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[RJL1]

Thanks.got a meeting to attend but will try it tonight and if it works I will post the link.

Thanks again
Ricardo

 

[RJL1]

I got the first page to load but if I try to login this is what I get

ADODB.Recordset error '800a0bb9'

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

/lunamedia/login.asp, line 14

 

[Cheech]

It looks like your sql statement is wrong. Have a look at this

http://www.macromedia.com/support/ultradev/ts/documents/recordset_error_800a0bb9.htm

The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[RJL1]

I did but could not see where the sql statement was in my page. I could not find anything that resembled the examples.
I have the files uploaded to brinkster if anyone could look at them.

http://www10.brinkster.com/lunamedia/login.asp

Thanks
Ricardo

 

[RJL1]

Here is the code for the login page

<%@LANGUAGE=&quot;JAVASCRIPT&quot;%>
<!--#include file=&quot;Connections/login.asp&quot; -->
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables(&quot;URL&quot;
if (Request.QueryString!=&quot;&quot MM_LoginAction += &quot;?&quot; + Request.QueryString;
var MM_valUsername=String(Request.Form(&quot;user_name&quot);
if (MM_valUsername != &quot;undefined&quot {
var MM_fldUserAuthorization=&quot;&quot;;
var MM_redirectLoginSuccess=&quot;search.asp&quot;;
var MM_redirectLoginFailed=&quot;fail.asp&quot;;
var MM_flag=&quot;ADODB.Recordset&quot;;
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_login_STRING;
MM_rsUser.Source = &quot;SELECT username, password&quot;;
if (MM_fldUserAuthorization != &quot;&quot MM_rsUser.Source += &quot;,&quot; + MM_fldUserAuthorization;
MM_rsUser.Source += &quot; FROM users WHERE username='&quot; + MM_valUsername.replace(/'/g, &quot;''&quot + &quot;' AND password='&quot; + String(Request.Form(&quot;password&quot).replace(/'/g, &quot;''&quot + &quot;'&quot;;
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(&quot;MM_Username&quot = MM_valUsername;
if (MM_fldUserAuthorization != &quot;&quot {
Session(&quot;MM_UserAuthorization&quot = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value);
} else {
Session(&quot;MM_UserAuthorization&quot = &quot;&quot;;
}
if (String(Request.QueryString(&quot;accessdenied&quot) != &quot;undefined&quot; && false) {
MM_redirectLoginSuccess = Request.QueryString(&quot;accessdenied&quot;
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>

Thanks
Ricardo

 

[schase]

What version of Access are you using? &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[RJL1]

Office XP (what's that 2002)I also have access 2000 & 97

Ricardo

 

[schase]

I've had this happen when I was using Access97, moved it up to Access2000 and the problem went away.

Try saving it down to Access2000. and give that a shot. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[RJL1]

saved as 2000 still no luck. I notice that my documents are JavaScript. Does it make a difference if they are JS or VB (as far as the db connection).
The site is really simple search site I could do it over in VB.

Ricardo

 

[schase]

It might if Brinkster doesnt support it.

If you want to - you can email me your stuff I can upload it to my server and check it out.

It'd narrow the possiblity of jsp &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[RJL1]

I would appreciate that send your e-mail to rluna@uwtlogistics.com I will reply with the files

Thanks
Ricardo

 

[schase]

ok, got it.

reserved names was the problem - just tossin some really wierd stuff out.

will email it back shortly. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[schase]

ok - pasting below an earlier post I did on reserved names.

Note the list on MM is not conclusive.

I altered login.asp & fail.asp. And where if you are only 4 or 5 pages so far - I would totally remove the jsp delete the site in site definations - redo the site in site definations (except choosing asp this time) and redo the recordsets and such. Its only a few pages - and will save you time further down the road.

If you look at the database - you'll notice I did some pretty extensive name alterations. - and the database then worked.
+++++++++++++++++++++++++++++++++++++++++++++++++++++
your into naming conventions - or rather needing them. (reserved name fields)

in databases - I always start my databases with db

like dbSchase.mdb

tables are started with tbl like tblChase
and fields inside the table are fld like fldChase.

Queries begin with qry

and so on.

as far as the asp side - i name all text fields with txt
all Dim's with str, all Session variables with sv, all cookies with ck......

like txtChase

http://www.macromedia.com/support/ultradev/ts/documents/insert_into.htm

Check that link out - see all databases use certain words - and you cannot use them again (without some extra effort) if you do you make it all confused (like me)

so sticking to something like I put above will not only get you away from reserved names - you will always know what is what (or where).
&quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart