|
 |
asp_databases thread: Missing parameter?
Message #1 by Jeremy.Farr@b... on Wed, 20 Jun 2001 13:36:18 +0000
|
|
Hi guys,
I''m writing a simple ASP to hook into an Access address book. But I keep
getting error. Any ideas?
Environment: win2k sp2, iis5
<%@Language = VBScript %>
<% Dim conn, rst, strSql, Tmp %>
<% if session("bSet")=false then %>
<% set session("sconn")=Server.CreateObject("ADODB.Connection")
%>
<% session("sconn").Provider = "Microsoft.Jet.OLEDB.4.0;" %>
<% session("sconn").Open "Data Source=e:\Address
Book\Contacts.mdb" %>
<% set session("srst")=Server.CreateObject("ADODB.Recordset") %>
<% strSql = "Select * from Details order by LastName" %>
<% session("srst").Open strSql, session("sconn"), adOpenKeyset,
adLockPessimistic %>
<% session("bSet")=true %>
<% End if %>
gives this error
Error Type:
Microsoft JET
Database Engine
(0x80040E10)
No value given
for one or more
required
parameters.
/myweb/addresses.
asp, line 9
TIA
Jerry
Message #2 by "Tomm Matthis" <matthis@b...> on Wed, 20 Jun 2001 08:56:26 -0400
|
|
Two things that might help.
1. Don't create a connection object as a session var... Baaaaaaaad
thing. Baaaaaaaaaaaaaaad thing. No donut. <grin>
Put your connection string et al in an Application variable and pull it
out to create the connection object.
set oConn =3D Application("strConnectionString")
2. Same caveats for the recordset object.
Hope that helps.
-- Tomm
> -----Original Message-----
> From: Jeremy.Farr@b...
> [mailto:Jeremy.Farr@b...]
> Sent: Wednesday, June 20, 2001 9:36 AM
> To: ASP Databases
> Subject: [asp_databases] Missing parameter?
>
>
> Hi guys,
> I''m writing a simple ASP to hook into an Access address book. But I
keep
> getting error. Any ideas?
>
> Environment: win2k sp2, iis5
>
> <%@Language =3D VBScript %>
> <% Dim conn, rst, strSql, Tmp %>
> <% if session("bSet")=3Dfalse then %>
> <% set
session("sconn")=3DServer.CreateObject("ADODB.Connection")
> %>
> <% session("sconn").Provider =3D "Microsoft.Jet.OLEDB.4.0;"
%>
> <% session("sconn").Open "Data Source=3De:\Address
> Book\Contacts.mdb" %>
> <% set
session("srst")=3DServer.CreateObject("ADODB.Recordset") %>
> <% strSql =3D "Select * from Details order by LastName" %>
> <% session("srst").Open strSql, session("sconn"),
adOpenKeyset,
> adLockPessimistic %>
> <% session("bSet")=3Dtrue %>
> <% End if %>
>
>
>
> gives this error
>
>
> Error Type:
> Microsoft JET
> Database Engine
> (0x80040E10)
> No value given
> for one or more
> required
> parameters.
> /myweb/addresses.
> asp, line 9
>
>
>
> TIA
> Jerry
>
|
|
|
View Cart
