|
 |
asp_database_setup thread: ASP help
Message #1 by "Isaac Sogunro" <isogunro@h...> on Wed, 02 May 2001 11:18:45 -0400
|
|
Can anyone please tell me what is wrong with this connection below. The
error I get is shown below.
<%
Dim testConn
Dim testRec
Set testConn = Server.CreateObject("ADODB.Connection")
Set testRec = Server.CreateObject("ADODB.Recordset")
testConn.Provider = "Microsoft.Jet.OLEDB.4.0"
testConn.ConnectionString = "Data Source=" & Server.MapPath ("\isaac\CGI-BIN\Coneference.mdb")
testConn.Open
MySql = "SELECT FirstName, LastName FROM tblGeneral;"
testRec.Open MySql, testConn <-- This is line 21
%>
This is the error I get.
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/Isaac/Testing/TestConn.asp, line 21
Thank you in advance for your help. -
Isaac-
Message #2 by ssteward@a... on Wed, 2 May 2001 10:35:26 -0500
|
|
try:
testRec.Open MySql, testConn, 1, 3, 1
-----Original Message-----
From: Isaac Sogunro [mailto:isogunro@h...]
Sent: Wednesday, May 02, 2001 10:19 AM
To: ASP Database Setup
Subject: [asp_database_setup] ASP help
Can anyone please tell me what is wrong with this connection below. The
error I get is shown below.
<%
Dim testConn
Dim testRec
Set testConn = Server.CreateObject("ADODB.Connection")
Set testRec = Server.CreateObject("ADODB.Recordset")
testConn.Provider = "Microsoft.Jet.OLEDB.4.0"
testConn.ConnectionString = "Data Source=" & Server.MapPath
("\isaac\CGI-BIN\Coneference.mdb")
testConn.Open
MySql = "SELECT FirstName, LastName FROM tblGeneral;"
testRec.Open MySql, testConn <-- This is line 21
%>
This is the error I get.
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/Isaac/Testing/TestConn.asp, line 21
Thank you in advance for your help. -
Isaac-
---
STAY UP TO DATE ON ASP.NET, C#, VB.NET, SQL and XML
Developersdex indexes over 100 of the top ASP, SQL, VB
and XML sites bringing in more than 5,000 new resources
every day. They even integrate all the top .NET
newsgroups so you can search/post/reply across
multiple newsgroups within their site. The next time
you want to find an answer on ASP, C#, SQL, VB or XML
think of Devdex! http://www.developersdex.com/
ssteward@a...
$subst('Email.Unsub')
Message #3 by "Isaac Sogunro" <isogunro@h...> on Wed, 02 May 2001 13:16:27 -0400
|
|
Hello again. I tried that, but it still did not work.
Any other suggestions.
-Isaac-
>From: ssteward@a...
>Reply-To: "ASP Database Setup"
>To: "ASP Database Setup"
>Subject: [asp_database_setup] RE: ASP help
>Date: Wed, 2 May 2001 10:35:26 -0500
>
>try:
>testRec.Open MySql, testConn, 1, 3, 1
>
>
>-----Original Message-----
>From: Isaac Sogunro [mailto:isogunro@h...]
>Sent: Wednesday, May 02, 2001 10:19 AM
>To: ASP Database Setup
>Subject: [asp_database_setup] ASP help
>
>
>Can anyone please tell me what is wrong with this connection below. The
>error I get is shown below.
>
>
>
> This is the error I get.
>
>Microsoft JET Database Engine error '80040e10'
>No value given for one or more required parameters.
>/Isaac/Testing/TestConn.asp, line 21
>
>Thank you in advance for your help. -
>
>Isaac-
Message #4 by "Ken Schaefer" <ken@a...> on Wed, 9 May 2001 10:55:12 +1000
|
|
Are you sure that your fields are called FirstName and LastName, and that
your table is called tblGeneral?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Isaac Sogunro" <isogunro@h...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Thursday, May 03, 2001 1:18 AM
Subject: [asp_database_setup] ASP help
: Can anyone please tell me what is wrong with this connection below. The
: error I get is shown below.
:
: <%
: Dim testConn
: Dim testRec
: Set testConn = Server.CreateObject("ADODB.Connection")
: Set testRec = Server.CreateObject("ADODB.Recordset")
: testConn.Provider = "Microsoft.Jet.OLEDB.4.0"
: testConn.ConnectionString = "Data Source=" & Server.MapPath
("\isaac\CGI-BIN\Coneference.mdb")
: testConn.Open
: MySql = "SELECT FirstName, LastName FROM tblGeneral;"
: testRec.Open MySql, testConn <-- This is line 21
: %>
:
: This is the error I get.
:
: Microsoft JET Database Engine error '80040e10'
: No value given for one or more required parameters.
: /Isaac/Testing/TestConn.asp, line 21
:
: Thank you in advance for your help. -
Message #5 by "Ken Schaefer" <ken@a...> on Wed, 9 May 2001 10:55:54 +1000
|
|
Never use "magic numbers" - this has been a guiding principle of programming
since...<insert a time many years ago>
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:
: try:
: testRec.Open MySql, testConn, 1, 3, 1
:
:
: -----Original Message-----
: From: Isaac Sogunro [mailto:isogunro@h...]
: Sent: Wednesday, May 02, 2001 10:19 AM
: To: ASP Database Setup
: Subject: [asp_database_setup] ASP help
:
:
: Can anyone please tell me what is wrong with this connection below. The
: error I get is shown below.
:
: <%
: Dim testConn
: Dim testRec
: Set testConn = Server.CreateObject("ADODB.Connection")
: Set testRec = Server.CreateObject("ADODB.Recordset")
: testConn.Provider = "Microsoft.Jet.OLEDB.4.0"
: testConn.ConnectionString = "Data Source=" & Server.MapPath
: ("\isaac\CGI-BIN\Coneference.mdb")
: testConn.Open
: MySql = "SELECT FirstName, LastName FROM tblGeneral;"
: testRec.Open MySql, testConn <-- This is line 21
: %>
:
: This is the error I get.
:
: Microsoft JET Database Engine error '80040e10'
: No value given for one or more required parameters.
: /Isaac/Testing/TestConn.asp, line 21
:
: Thank you in advance for your help. -
|
|
|
View Cart
