Re: help!

I'd upgrade the drivers on the other two machines - it looks like it's
a difference between driver versions treating the data differently.
We see this in Oracle drivers all the time.

On 7/15/10, Lawson K. Cronlund <[email protected]> wrote:
> 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]
>
>

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