Hi Manuel,
I had a similar problem a few months ago and I found 'somewhere' in the
documentation
a post by Matthew van Os on May 27 2005, saying:
The CursorLocation should be of the type "adUseClient" instead of
"adUseServer".
The adUseServer returns a -1 as recordcount.
The adUseClient returns the actual recordcount.
Please also take a look at:
http://dev.mysql.com/doc/refman/5.1/en/programs-known-to-work-with-myodbc.html
HTH, Cor
----- Original Message -----
From: "Manuel Betanzos" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, May 04, 2006 4:01 PM
Subject: Help on VB and ODBC
Hi everybody, Please I need help on this.
I am beginning a new application. I am doing it with VB 6.0 - MySQL
5.0 - MyODBC 3.51 on Windows
Is there any parameter i need to establish in order to be able to work
with RecordSets in the Client side ????, actually i can't because if i
do, when i change any value i receive the following message:
Error '-2147217900 (80040e14) en tiempo de ejecucion:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.15]You have an error in your SQL
syntax; check the manual that corresponds to your MySQL Server version for
the right syntax to use near'. ´catpartes´ SET ´condicion´ =2 WHERE
´CveCia´ =1 and ´Almacen´ ='01' and ´NoParte´ at line 1
If i change the CursorLocation to 3 - adUseClient i don't receive the
above message and the information is updated correctly . But with the
CursorLocation 2 - adUseServer the DataList, DataCombo and DataGrid dont
work.
Thanks in advance.
---------------------------------
Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo por
$100 al mes. http://net.yahoo.com.mx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]