| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 22 August 2002 : 13:52:01
|
It looks like Chili!ASP doesn't handle the new way of opening recordsets too well.
http://forum.snitz.com/forum/topic.asp?whichpage=4&TOPIC_ID=32014#164523
It seems it is need to change this:
rsChk.open strSql, my_Conn, adOpenForwardOnly, adLockOptimistic, adCmdText
to this
rsChk.open strSql, my_Conn
I don't know whether this is an issue with that specific configuration (Chili/Access) but I've been getting some similar problems with some Access users. Maybe it's an drivers/MDAC issue (MDAC in the case of Windows machines with Access).
I posted this only for reference. It may be too soon to do something. This is very annoying since I think the performance gains justify the decision taken to specify the parameters, but it sure has brought some problems.
Maybe wait a little more to see how this goes and if we can have a better explanation for this behavior. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 August 2002 : 14:24:12
|
This might be remedied with using the inc_adovbs.asp file instead of the METADATA typelib.
But, Davio did some testing on a Chili!ASP/Linux configuration using:
rsChk.open strSql, my_Conn, 0, 1, &H0001
and had no problems at all. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 August 2002 : 14:33:29
|
here is a link to the file:
http://kinser.121hosts.net/files/inc_adovbs.zip
in config.asp on line #1
replace this:
<!--METADATA TYPE="typelib" UUID="00000205-0000-0010-8000-00AA006D2EA4" NAME="ADODB Type Library" -->
with this:
<!--#INCLUDE FILE="inc_adovbs.asp"-->
|
|
|
|
Daudi
Starting Member
Virgin Islands (United Kingdom)
22 Posts |
Posted - 22 August 2002 : 15:37:21
|
ok, now that I've done this, I kinda can start really trying to debug the code, the vb compiler has a problem with this line in the new include file
14 Const adOpenForwardOnly = 0
I'm going to comment it out and see what happens since this is what you made me do earlier. Will get back to you. |
|
|
|
Daudi
Starting Member
Virgin Islands (United Kingdom)
22 Posts |
Posted - 22 August 2002 : 15:56:58
|
| What exactly are these constants they are all giving problems on my server. Are there any special components that should be installed to allow access to them |
|
|
|
Daudi
Starting Member
Virgin Islands (United Kingdom)
22 Posts |
Posted - 22 August 2002 : 16:00:54
|
oh my new error says name redefined
I commented out the calls for the adforward and adLockReadOnly AdOpenForwardOnly in the rs.Open statement and then it gave the same error for adPessi...
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 August 2002 : 16:33:49
|
| if you are getting the "Name Redefined" error then you don't need to include the file. Just remove the include for it from line #1 of config.asp, though the "on error resume next" should ignore those errors. |
|
|
|
Daudi
Starting Member
Virgin Islands (United Kingdom)
22 Posts |
Posted - 22 August 2002 : 17:10:39
|
now I have a new problem it says It is already opened exclusively by another user, or you need permission to view its data.
/Forum/inc_header.asp, line 106
I commented out the statement, which seemed to get rid of that problem, but then I got another problem saying
Operation is not allowed when the object is closed.
/Forum/inc_func_common.asp, line 862
|
|
|
|
Daudi
Starting Member
Virgin Islands (United Kingdom)
22 Posts |
Posted - 22 August 2002 : 17:13:58
|
| The object to open here should be myconn. so I put the open statement here. And I went straight back to the problem I had initially. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 August 2002 : 17:23:36
|
| you are obviously having a problem unrelated to the bug report here, please start a new topic in the Help: General / Current Version (v3.4) forum. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 August 2002 : 04:12:17
|
ruirib,
I have setup slackware linux and installed Apache/MySQL/Chili!Soft ASP on it.
Server software shows as:
Apache/1.3.19 (Unix) Chili!Soft-ASP/3.6.2
If I don't use the inc_adovbs.asp include, I get an error about an unsupported lock type. But, if I use the inc_adovbs.asp include, then everything works like it should, I don't get any errors. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
trazman
New Member
Sweden
79 Posts |
Posted - 23 August 2002 : 06:35:58
|
| Do you have a DSN or MySQL connection RickardKinser? |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 23 August 2002 : 08:39:14
|
quote:
If I don't use the inc_adovbs.asp include, I get an error about an unsupported lock type. But, if I use the inc_adovbs.asp include, then everything works like it should, I don't get any errors.
Does this mean you'll be changing the code to include inc_adovbs.asp or adovbs.inc? I have other scripts that seem to use the library also, but it doesn't look like the asp version has the entire library.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 August 2002 : 11:29:05
|
quote:
Originally posted by trazman
Do you have a DSN or MySQL connection RickardKinser?
MySQL connection. I'll see if I can figure out how to setup a DSN and test with that too. I know how to setup a DSN on a Windows Machine, but Linux is still fairly new to me. |
|
|
|
Topic |
|
Forum Locked
Topic Locked
.