| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 06 May 2002 : 12:28:24
|
Now, this probably is my lack of knowledge of the Snitz code inner workings, but I was talking about the connection itself, not the recordset.
Where do you keep your connection info (the ADODB.Connection type object)?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
Chiz
Junior Member
245 Posts |
Posted - 06 May 2002 : 12:36:11
|
From what I understand in the code, the config.asp file sets the stage for the connection. Hence,
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_functions.asp" -->
Any other file such as inc_functions.asp will be able to use the open connection. But I maybe wrong you know. The Dev team maybe able to confirm this.
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
Edited by - Chiz on 06 May 2002 12:38:10 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 May 2002 : 12:59:59
|
I see. Maybe you should determine the variable used and close it at the end of your page. Wanna try it?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Kent
Junior Member
United States
193 Posts |
Posted - 06 May 2002 : 15:52:33
|
I was having intermittent DB errors and my host finally had me upgrade the Access97 database to Access2000 -- and the errors went away... Seems that there's a basic problem with Access97 DBs on Windows XP servers...
Don't know if that's your problem, but it's an easy thing to try...
|
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 06 May 2002 : 16:08:05
|
Microsoft JET Database Engine error '80040e10'
'No value given for one or more required parameters.'
strSQL = "SELECT Col1, Col2 FROM " & strTablePrefix & "TestTable"
set rsTest = Server.CreateObject("ADODB.Recordset")
rsTest.open strSql, my_Conn (<-- this causes the error)
________________________________________________________
This error typically occurs when you have a field within your database that you've specified to be a required value, but that field is blank. Check your 'testtable' field properties within the database to make sure the 'required' option is 'no' for the col1 and col2 fields or make sure you provide a value for that field.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 May 2002 : 18:26:18
|
Chiz, would you please post a link to a text version of your test code?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 06 May 2002 : 22:24:49
|
quote:
I was having intermittent DB errors and my host finally had me upgrade the Access97 database to Access2000 -- and the errors went away... Seems that there's a basic problem with Access97 DBs on Windows XP servers...
Don't know if that's your problem, but it's an easy thing to try...
Thanks for the info but I'm already using an Access 2000 database.
quote:
This error typically occurs when you have a field within your database that you've specified to be a required value, but that field is blank. Check your 'testtable' field properties within the database to make sure the 'required' option is 'no' for the col1 and col2 fields or make sure you provide a value for that field.
Thanks, but there are no required fields in my table.
quote:
Chiz, would you please post a link to a text version of your test code?
Here are the links:
testload
inc_functions
Thanks again for all the help.
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 07:04:38
|
Chiz,
I managed to run the test script with the normal inc_functions.asp many times, in many browser windows without any probs. When I decided to use your version I got an error informing that the input table 'FORUM_MoreSmilies' cannot be found. Maybe send me a copy of a DB with only this table (and others that maybe needed for this test)?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 07 May 2002 : 07:45:05
|
Here's the link, ruirib. It's a fresh Snitz db with the MoreSmilies tables added.
database
A bit of note though... I got 100% success rate when I run the test code on localhost (IIS 5 running Win XP), no errors whatsoever. I only encounter the errors when the test code is run in the web server.
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 07:56:24
|
Well that happened to me also. No errors at all. This means that this is server related. Either driver version of lack of resources to handle all the load at the web server.
I'd say you need to talk to your host about it.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 07 May 2002 : 08:09:08
|
quote:
I got 100% success rate when I run the test code on localhost
No matter what I do so that I could see the error in my localhost, it didn't happen. But there could be an error or bug somewhere.
quote:
Well that happened to me also. No errors at all. This means that this is server related. Either driver version of lack of resources to handle all the load at the web server.
I'd say you need to talk to your host about it.
I hope it is but it's not only I that encounters the error. Two more users of the CategorizedIcons MOD reported this same kind of error—and we're not located on the same web server.
I'll try uploading and testing the same code onto another server and see if it will also generate the same error. Once again, thanks, ruirib.
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
Edited by - Chiz on 07 May 2002 08:13:18 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 08:24:01
|
Chiz,
Two suggestions to try out:
1. Try the SELECT * instead of naming the columns to be retrieved. At least the error should change...
2. Open a new DB connection in your functions and close it when you no longer need it. If the error still appears, at least that will let you know the connection isn't the culprit...
I was going to suggest using getRows also, but the problem seems to be with obtaining the recordset not manipulating it...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 07 May 2002 : 10:11:02
|
I'll try your suggestions, ruirib. Thanks.
You're right. It's not the retrieving of records that errs but during the opening of the table.
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
. Let me know how it goes.