Hi All,

Im a newbie on here so Hello..... <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

I run a website dedicated to my local football\soccer team - www.stockportcounty.net

Im currently adding some database functionality to the site but having trouble connecting to the database when I upload the asp. Everything runs great locally using a local dsn.

The database is an Access database and is stored in a data folder at the root of the site and the asp pages are stored within a html folder which is also at the root of the site.

The error I am getting when I go to the online web page is:

ADODB.Recordset error '800a0bb9'

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

/2005_dbase.asp, line 5

The code in 2005_dbase.asp is as follows:

&lt;%@LANGUAGE="JAVASCRIPT"%&gt;
&lt;!--#include file="Connections/SCFC_Results.asp" --&gt;
&lt;%
var Seasons = Server.CreateObject("ADODB.Recordset";
Seasons.ActiveConnection = MM_SCFC_Results_STRING;
Seasons.Source = "SELECT DISTINCT Season FROM Results";
Seasons.CursorType = 0;
Seasons.CursorLocation = 2;
Seasons.LockType = 1;
Seasons.Open();
var Seasons_numRows = 0;
%&gt;
&lt;%
var Results__MMColParam = "1";
if (String(Request.Form("seasonselect") != "undefined" &&
String(Request.Form("seasonselect") != "" {
Results__MMColParam = String(Request.Form("seasonselect");
}
%&gt;
&lt;%
var Results = Server.CreateObject("ADODB.Recordset";
Results.ActiveConnection = MM_SCFC_Results_STRING;
Results.Source = "SELECT Comp, Home, Home_Score, Away_Score, Away, Date, Season FROM Results WHERE Season = '"+ Results__MMColParam.replace(/'/g, "''" + "'";
Results.CursorType = 0;
Results.CursorLocation = 2;
Results.LockType = 1;
Results.Open();
var Results_numRows = 0;
%&gt;
&lt;%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
Results_numRows += Repeat1__numRows;
%&gt;

I have everything to try and resolve this, I have been all over Google looking for tips but nothing seems to work.

Has anyone come across this error before? Do you have any udeas how I can resolve this?

Thanks in advance

Garf

you need to include the file adovbs.inc in your page.

you can download the file here:

n.1asphost.com/micahsantos/adovbs.txt

and rename it to adovbs.inc

hope this helps.