| Author |
 Topic  |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 06 November 2004 : 10:15:36
|
| I have compared both default.asp and forum.asp with 3.4.04 and found no differences that could explain this. Of course, I' don't know whether 3.4.04 would cause the same problems or not. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 November 2004 : 14:11:22
|
| what version of MySQL? Could be something to do with using a newer version of MySQL... |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 November 2004 : 18:40:17
|
quote:
Originally posted by RichardKinser
what version of MySQL? Could be something to do with using a newer version of MySQL...
Good question. I'm going to ask the users. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 06 November 2004 : 21:14:59
|
http://bugs.mysql.com/bug.php?id=4341
Acknowledges an ADO Cursorlocation bug (4.1.2), and says that MySQL wont support all ADO Constants until version 5 |
-Stim |
Edited by - Da_Stimulator on 06 November 2004 21:17:34 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 November 2004 : 22:40:27
|
The problem here seems to be that when counting the value returned does not seem to be interpreted as a number. If you see the fixes I proposed and that seem to be working, just converts the values returned to numbers. What's weird is that if you take a look at the first thread where this issue was reported, a number was shown when the count returned value was printed...
Anyway, it seems like the fix has been found, even if the bug has not... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 November 2004 : 00:28:59
|
I suspect something in the MyODBC drivers, which are iffy anyway. You might want to try to get the driver version and the connection string. There are a number of OPTIONS that can be set in the connection string that can have an impact on the way the drivers work with ADO. I believe 3.52 is the current releas version.
In XP anyway you open the ODBC applet from Administrative Tools and click the Drivers tab to find out the version of the driver.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 November 2004 : 19:49:36
|
I use MyODBC from some vb code, and I use OPTIONS=18465, which got rid of most of the problems I had with VB6, but I still have one problem I haven't solved from a ADODataGrid, if I use a query that returns a single row, or if the row I want to edit has text that's longer than any other row in the grid, I get a "MultiStep OLEDB error". No clue so far. I keep hoping the MyODBC connector gets better, there is supposed to be a 3.53 version that will be compliant with the odbc specs.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 09 November 2004 : 18:57:53
|
quote:
Thanks for your bug report. Version 3.51 of MyODBC was not written with
server-side cursor support fully in mind, and it won't be updated to fully support server-side cursors or other MySQL 4.1 features.
Instead, work is progressing on version 3.53 of Connector/ODBC, which will comply fully with the ODBC spec and will support all features of MySQL 4.1 and above. It is in development now, and will be available "Real Soon Now".
By the way, full support for server-side cursors is not available until version 5.0 of MySQL. Server-side prepared statements is available in MySQL 4.1. Version 5.0 of MySQL is not even in alpha yet (a pre-release is available on www.mysql.com). We are hoping to have a beta release of MySQL 5.0 in the first half of 2005.
Quote from the bug report I listed above..... |
-Stim |
|
|
| |
Topic |
|
Topic Locked
