Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP BATABASE, DSNless Connection, help me 1

Status
Not open for further replies.
duellsy

duellsy

Programmer
Dec 28, 2000
4
AU
i am tryin to view info on 'accommodation.asp' file using the 'mbdata.mdb' database, and in the 'accommodation' part.
if u get me.....
anyway, i am having the error:

ADODB.Connection.1 error '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

/duellsy/a/accommodation.asp, line 23


can u please tell me how to fix this?
here is my asp script:
<head>

<SCRIPT LANGUAGE=&quot;JavaScript&quot;>
function dropdownmenu(item){
window.location.href=item.options[item.selectedIndex].value;}
</SCRIPT>


<font size=&quot;4&quot;><b>
Other related searches </b><form name=&quot;menu1&quot; align=&quot;left&quot;>
<select name=&quot;otherpages&quot; size=1
onchange=&quot;dropdownmenu(document.menu1.otherpages)&quot;>
<OPTION VALUE=&quot;*&quot;>Select
<OPTION VALUE=&quot;../m/motels.html&quot;>Motels

</select>
<blockquote><font size=&quot;4&quot;>


<%
Set MyConn = Server.CreateObject(&quot;ADODB.Connection&quot;)
MdbFilePath = Server.MapPath(&quot;mbdata.mdb&quot;)
MyConn.Open &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; MdbFilePath &amp; &quot;;&quot;
SQL_query = &quot;SELECT * FROM accommodation&quot;
Set RS = MyConn.Execute(SQL_query)
DO WHILE NOT RS.EOF
%>
Response.Write=(RS(&quot;Name&quot;))<br>
Response.Write=(RS(&quot;Address&quot;))<br>
Response.Write=(RS(&quot;Town&quot;))<br>
Response.Write=(RS(&quot;Ph&quot;))<br>
Response.Write=(RS(&quot;Mob&quot;))<br><br>
<%
RS.MoveNext
LOOP
%>
</BODY>
</HTML>
 
Sort by date Sort by votes
Make sure you have the correct verison of MDAC on the Server and also make sure you have the latest Service Pack. This is imperative.

ALSO
Take the = sign away from Response.Write &amp; place it within ASP

<%
Dim MyConn, RS, SQL_Query, MdbFilePath

Set MyConn = Server.CreateObject(&quot;ADODB.Connection&quot;)
MdbFilePath = Server.MapPath(&quot;db1.mdb&quot;)
MyConn.Open &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; MdbFilePath &amp; &quot;;&quot;
SQL_query = &quot;SELECT * FROM Table1&quot;
Set RS = MyConn.Execute(SQL_query)
DO WHILE NOT RS.EOF
Response.Write (RS(0)) %><br>
<% Response.Write (RS(1)) %><br>
<% Response.Write (RS(2)) %><br>
<% Response.Write (RS(3)) %><br>
<% Response.Write (RS(4)) %><br><br>
<% RS.MoveNext
LOOP
%>
 
Upvote 0 Downvote
that didn't make a difference:
it now has this:
Microsoft VBScript compilation error '800a0400'

Expected statement

/duellsy/a/accommodation.asp, line 26

WHILE NOT RS.EOF THEN
-----------------^
 
Upvote 0 Downvote
sorry, wrong file, but it stil did not work it had the same error as the original
 
Upvote 0 Downvote
i have found out that the server my site is hosted at is only on MDAC version 1.0, so i have 'TOLD' him to update to the latest version, being 2.60.
that should make a difference
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
write HTML code within ASP line
Replies
1
Views
451
xwb
xwb
leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
433
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
366
penguinspeaks
penguinspeaks
how2trainyourdragon
  • Locked
  • Question
Request.Server variables blank for classic ASP
Replies
12
Views
800
GriffMG
GriffMG
Swi
  • Locked
  • Question
JQUERY AJAX POST and how to receive data via Classic ASP
Replies
0
Views
457
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top