RE: help!

I notice that there is no semicolon at the end of your SQL statement.
Perhaps there is a difference between different versions that makes this
significant.

Regards,



Lawson Cronlund
[email protected]
+1(480)308-0641

-----Original Message-----
From: Seyoum, Teshome [mailto:[email protected]] 
Sent: Thursday, July 15, 2010 6:37 AM
To: '[email protected]'
Subject: help!

I am seeing the following error running a VB application that processes
MySql database.

"run-time error '-2147217887 (80040e21)';
 multiple step operation generated errors vb6. check each status value"

What's interesting is that this only happens on 2 out of 3 client pcs !!
(The one pc has MySql 5.1.44 client/server installed and the others 4.0.21)


The error attempting to execute the last statement below.

    Set ADOConn = New ADODB.Connection
    Set MEFlds = New ADODB.Recordset
    ADOConn.CursorLocation = adUseClient
    ADOConn.ConnectionString = "Driver={MySQL ODBC 3.51
Driver};Server=woc2floexpa0017;Option=131072;Database=acwts;Uid=testfloe2;PW
D=jerusa1;"
    ADOConn.Open
    sql = "select * from doc_table " & _
    " where ea_key = '" & EOTxt & "' And Type_id = '" & zzz & "'" & _
    " order by me, earev asc, floedate"
    MEFlds.Open sql, ADOConn, adOpenDynamic, adLockOptimistic


Appreciate your help!

Tesh Seyoum
Developer
Delta Airlines
Performance Engineering
404-715-2052


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]