Access Database connection Problem

[AnilNe]

Dear Friends,
I need to setup one web application.
The application works well when it is run in IIS which connection string as

<%
var MM_Journal_Thesis_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Websites\Journal_thesis\hellis.mdb"
%>

Now I need to upload this application on a website.
For that I have changed its physical path into Server.MapPath. The code is

<%
var MM_Journal_Thesis_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("../hellis.mdb")
%>

In this case, it gives error as
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

I have tried so many ways. But still getting the same problem. I have made this web application with Dreamweaver MX 2004.

Any help from your side will be highly appreciated.

With Regards,
Anil

 

[Chopstik]

What is the specific line on which it says that the error is occurring? Your error message appears (to me) to have something more to do with the recordset as opposed to the connection. Could you provide the code that you are using to return your recordset as well?

------------------------------------------------------------------------------------------------------------------------
"The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair."
--Dou

 

[DreXor]

ya what chopstik said said

looks like it's the opening of the recordset, you probably have parameters out of place or using the wrong adlock options

please post the code that follows what you posted, opening the connection and then using it on a recordset

DreX
aKa - Robert

 

[AnilNe]

Ok friends...here is the code for recordset. At the second like of the code, a file "journal_thesis.asp" is included which is just connection file and which has error as i try to use the Server.Mappath. Code of it is above.

The code for the file which is used to show records is

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/Journal_Thesis.asp" -->
<%
var Journal_Display_All = Server.CreateObject("ADODB.Recordset");
Journal_Display_All.ActiveConnection = MM_Journal_Thesis_STRING;
Journal_Display_All.Source = "SELECT vcrJournalTitle, vcrLocation, txtCollection FROM JournalTable ORDER BY vcrJournalTitle ASC";
Journal_Display_All.CursorType = 0;
Journal_Display_All.CursorLocation = 2;
Journal_Display_All.LockType = 1;
Journal_Display_All.Open();
var Journal_Display_All_numRows = 0;
%>
<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
Journal_Display_All_numRows += Repeat1__numRows;
%>

<%
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

// set the record count
var Journal_Display_All_total = Journal_Display_All.RecordCount;

// set the number of rows displayed on this page
if (Journal_Display_All_numRows < 0) { // if repeat region set to all records
Journal_Display_All_numRows = Journal_Display_All_total;
} else if (Journal_Display_All_numRows == 0) { // if no repeat regions
Journal_Display_All_numRows = 1;
}

// set the first and last displayed record
var Journal_Display_All_first = 1;
var Journal_Display_All_last = Journal_Display_All_first + Journal_Display_All_numRows - 1;

// if we have the correct record count, check the other stats
if (Journal_Display_All_total != -1) {
Journal_Display_All_numRows = Math.min(Journal_Display_All_numRows, Journal_Display_All_total);
Journal_Display_All_first = Math.min(Journal_Display_All_first, Journal_Display_All_total);
Journal_Display_All_last = Math.min(Journal_Display_All_last, Journal_Display_All_total);
}
%>
<%
// *** Recordset Stats: if we don't know the record count, manually count them

if (Journal_Display_All_total == -1) {

// count the total records by iterating through the recordset
for (Journal_Display_All_total=0; !Journal_Display_All.EOF; Journal_Display_All.MoveNext()) {
Journal_Display_All_total++;
}

// reset the cursor to the beginning
if (Journal_Display_All.CursorType > 0) {
if (!Journal_Display_All.BOF) Journal_Display_All.MoveFirst();
} else {
Journal_Display_All.Requery();
}

// set the number of rows displayed on this page
if (Journal_Display_All_numRows < 0 || Journal_Display_All_numRows > Journal_Display_All_total) {
Journal_Display_All_numRows = Journal_Display_All_total;
}

// set the first and last displayed record
Journal_Display_All_last = Math.min(Journal_Display_All_first + Journal_Display_All_numRows - 1, Journal_Display_All_total);
Journal_Display_All_first = Math.min(Journal_Display_All_first, Journal_Display_All_total);
}
%>
<% var MM_paramName = ""; %>
<%
// *** Move To Record and Go To Record: declare variables

var MM_rs = Journal_Display_All;
var MM_rsCount = Journal_Display_All_total;
var MM_size = Journal_Display_All_numRows;
var MM_uniqueCol = "";
MM_paramName = "";
var MM_offset = 0;
var MM_atTotal = false;
var MM_paramIsDefined = (MM_paramName != "" && String(Request(MM_paramName)) != "undefined");
%>
<%
// *** Move To Record: handle 'index' or 'offset' parameter

if (!MM_paramIsDefined && MM_rsCount != 0) {

// use index parameter if defined, otherwise use offset parameter
r = String(Request("index"));
if (r == "undefined") r = String(Request("offset"));
if (r && r != "undefined") MM_offset = parseInt(r);

// if we have a record count, check if we are past the end of the recordset
if (MM_rsCount != -1) {
if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last
if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount % MM_size);
} else {
MM_offset = MM_rsCount - MM_size;
}
}
}

// move the cursor to the selected record
for (var i=0; !MM_rs.EOF && (i < MM_offset || MM_offset == -1); i++) {
MM_rs.MoveNext();
}
if (MM_rs.EOF) MM_offset = i; // set MM_offset to the last possible record
}
%>
<%
// *** Move To Record: if we dont know the record count, check the display range

if (MM_rsCount == -1) {

// walk to the end of the display range for this page
for (var i=MM_offset; !MM_rs.EOF && (MM_size < 0 || i < MM_offset + MM_size); i++) {
MM_rs.MoveNext();
}

// if we walked off the end of the recordset, set MM_rsCount and MM_size
if (MM_rs.EOF) {
MM_rsCount = i;
if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount;
}

// if we walked off the end, set the offset based on page size
if (MM_rs.EOF && !MM_paramIsDefined) {
if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount % MM_size);
} else {
MM_offset = MM_rsCount - MM_size;
}
}

// reset the cursor to the beginning
if (MM_rs.CursorType > 0) {
if (!MM_rs.BOF) MM_rs.MoveFirst();
} else {
MM_rs.Requery();
}

// move the cursor to the selected record
for (var i=0; !MM_rs.EOF && i < MM_offset; i++) {
MM_rs.MoveNext();
}
}
%>
<%
// *** Move To Record: update recordset stats

// set the first and last displayed record
Journal_Display_All_first = MM_offset + 1;
Journal_Display_All_last = MM_offset + MM_size;
if (MM_rsCount != -1) {
Journal_Display_All_first = Math.min(Journal_Display_All_first, MM_rsCount);
Journal_Display_All_last = Math.min(Journal_Display_All_last, MM_rsCount);
}

// set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount);
%>
<%
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

// create the list of parameters which should not be maintained
var MM_removeList = "&index=";
if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone="";

// add the URL parameters to the MM_keepURL string
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}

// add the Form variables to the MM_keepForm string
for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
}
}

// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL + MM_keepForm;
if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1);
if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
%>
<%
// *** Move To Record: set the strings for the first, last, next, and previous links

var MM_moveFirst="",MM_moveLast="",MM_moveNext="",MM_movePrev="";
var MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves
var MM_moveParam = "index";

// if the page has a repeated region, remove 'offset' from the maintained parameters
if (MM_size > 1) {
MM_moveParam = "offset";
if (MM_keepMove.length > 0) {
params = MM_keepMove.split("&");
MM_keepMove = "";
for (var i=0; i < params.length; i++) {
var nextItem = params.substring(0,params.indexOf("="));
if (nextItem.toLowerCase() != MM_moveParam) {
MM_keepMove += "&" + params;
}
}
if (MM_keepMove.length > 0) MM_keepMove = MM_keepMove.substring(1);
}
}

// set the strings for the move to links
if (MM_keepMove.length > 0) MM_keepMove += "&";
var urlStr = Request.ServerVariables("URL") + "?" + MM_keepMove + MM_moveParam + "=";
MM_moveFirst = urlStr + "0";
MM_moveLast = urlStr + "-1";
MM_moveNext = urlStr + (MM_offset + MM_size);
MM_movePrev = urlStr + Math.max(MM_offset - MM_size,0);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<p align="left"><strong><font color="#000066" size="4">Journal (All Records)</font></strong></p>
<font color="#FF0000">Records <%=(Journal_Display_All_first)%> to <%=(Journal_Display_All_last)%> of <%=(Journal_Display_All_total)%> </font>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center"> <div align="center">
<% if (MM_offset != 0) { %>
<a href="<%=MM_moveFirst%>"><img src="First.gif" border=0></a>
<% } // end MM_offset != 0 %>
</div></td>
<td width="31%" align="center">
<% if (MM_offset != 0) { %>
<a href="<%=MM_movePrev%>"><img src="Previous.gif" border=0></a>
<% } // end MM_offset != 0 %>
</td>
<td width="23%" align="center">
<% if (!MM_atTotal) { %>
<a href="<%=MM_moveNext%>"><img src="Next.gif" border=0></a>
<% } // end !MM_atTotal %>
</td>
<td width="23%" align="center">
<% if (!MM_atTotal) { %>
<a href="<%=MM_moveLast%>"><img src="Last.gif" border=0></a>
<% } // end !MM_atTotal %>
</td>
</tr>
</table>
<table width="97%" border="1" bordercolor="#FFFFFF">
<% while ((Repeat1__numRows-- != 0) && (!Journal_Display_All.EOF)) { %>
<tr bordercolor="#FFFFFF" bgcolor="#00CCCC">
<td><strong>Title</strong></td>
<td><%=(Journal_Display_All.Fields.Item("vcrJournalTitle").Value)%>&nbsp;</td>
</tr>
<tr bordercolor="#FFFFFF">
<td><strong>Location</strong></td>
<td><%=(Journal_Display_All.Fields.Item("vcrLocation").Value)%>&nbsp;</td>
</tr>
<tr bordercolor="#FFFFFF">
<td><strong>Vol:</strong></td>
<td><%=(Journal_Display_All.Fields.Item("txtCollection").Value)%>&nbsp;</td>
</tr>
<%
Repeat1__index++;
Journal_Display_All.MoveNext();
}
%>
</table>
<div align="left"></div>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center"> <div align="center">
<% if (MM_offset != 0) { %>
<a href="<%=MM_moveFirst%>"><img src="First.gif" border=0></a>
<% } // end MM_offset != 0 %>
</div></td>
<td width="31%" align="center"> <% if (MM_offset != 0) { %>
<a href="<%=MM_movePrev%>"><img src="Previous.gif" border=0></a>
<% } // end MM_offset != 0 %> </td>
<td width="23%" align="center"> <% if (!MM_atTotal) { %>
<a href="<%=MM_moveNext%>"><img src="Next.gif" border=0></a>
<% } // end !MM_atTotal %> </td>
<td width="23%" align="center"> <% if (!MM_atTotal) { %>
<a href="<%=MM_moveLast%>"><img src="Last.gif" border=0></a>
<% } // end !MM_atTotal %> </td>
</tr>
</table>
<font color="#FF0000">Records <%=(Journal_Display_All_first)%> to <%=(Journal_Display_All_last)%> of <%=(Journal_Display_All_total)%> </font>
<p>&nbsp; </p>
</body>
</html>
<%
Journal_Display_All.Close();
%>

 

[Chopstik]

Could you point out the line where the error is specifically happening? Nothing stands out immediately as a problem just from a glance...

------------------------------------------------------------------------------------------------------------------------
"The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair."
--Dou

 

[DreXor]

i would say you're trying to do too much with a simple recordset .. try changing all this code :

var Journal_Display_All = Server.CreateObject("ADODB.Recordset");
Journal_Display_All.ActiveConnection = MM_Journal_Thesis_STRING;
var Journal_Display_All = Server.CreateObject("ADODB.Recordset");
Journal_Display_All.ActiveConnection = MM_Journal_Thesis_STRING;
Journal_Display_All.Source = "SELECT vcrJournalTitle, vcrLocation, txtCollection FROM JournalTable ORDER BY vcrJournalTitle ASC";
Journal_Display_All.CursorType = 0;
Journal_Display_All.CursorLocation = 2;
Journal_Display_All.LockType = 1;
Journal_Display_All.Open();

......................<clip>

Journal_Display_All.Close();
......................<clip>

to :

var Connection = Server.CreateObject("Adodb.connection");
Connection.open MM_Journal_Thesis_STRING;
var Journal_Display_All_SQL =  "SELECT vcrJournalTitle, vcrLocation, txtCollection FROM JournalTable ORDER BY vcrJournalTitle ASC";
var Journal_Display_All = Connection.Execute(Journal_Display_All_SQL);

hopefully i didn't forget any ";"s i typically avoid JS

DreX
aKa - Robert