ASP and MS Access

sireen1980 · #1 (**permalink**) 04-23-04, 09:18 PM

Hi,
I am trying to build a FeedBack Page on my website, but i keep running an error requesting an Object, this is the error message
****************
ADODB.Connection error '800a0bb9'

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

/FeedBack.asp, line 30
***********************

and i thought the object was objConn but still running an Error, Can you help me fix the problem, i have included the code below,
Thank you
Sireen

<%@LANGUAGE="VBSCRIPT" %>

<%

dim objConn
set objConn = server.createobject("ADODB.connection")
objConn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("/access_db/FeedBackdata.mdb") & ";"

%>

<html>
<head>
<title>FeedBack</title>

</head>

<body>
<table width="97%" border="1">
<tr>
<td><div align="center">Guest_ID</div></td>
<td><div align="center">Name</div></td>
<td><div align="center">Title</div></td>
<td><div align="center">Email</div></td>
<td><div align="center">Comments</div></td>
</tr>
<tr>
<td><div
align="center"><% objConn.Guest_ID.Value %></div></td>
<td><div
align="center"><% objConn.Name.Value %></div></td>
<td><div
align="center"><% objConn.Title.Value%></div></td>
<td><div
align="center"><% objConn.Email.Value%></div></td>
<td><div
align="center"><% objConn.Comments.Value%></div></td>
</tr>
</table>
</body>
</html>

techknow · #2 (**permalink**) 04-25-04, 06:12 PM

Try Using the below code as your connection string...

<%@ Import Namespace="System.Data.OleDb" %>

<Script Runat="Server">

Sub Page_Load( s As Object, e As EventArgs )
Dim conlistings As OleDbConnection

conlistings = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\websites\data\whatever.mdb" )
conlistings.Open()
End Sub