help!

--_000_AB3E6B5188566C488E011B9C54CF2A1805F7D40805satlrccdlmb 60_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I am seeing the following error running a VB application that processes MyS=
ql 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 !! (T=
he 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 =3D New ADODB.Connection
Set MEFlds =3D New ADODB.Recordset
ADOConn.CursorLocation =3D adUseClient
ADOConn.ConnectionString =3D "Driver=3D{MySQL ODBC 3.51 Driver};Server=
=3Dwoc2floexpa0017;Option=3D131072;Database=3Dacwts;Uid=3Dte stfloe2;PWD=3Dj=
erusa1;"
ADOConn.Open
sql =3D "select * from doc_table " & _
" where ea_key =3D '" & EOTxt & "' And Type_id =3D '" & 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

--_000_AB3E6B5188566C488E011B9C54CF2A1805F7D40805satlrccdlmb 60_--

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
lawson@vrtinc.com
+1(480)308-0641

-----Original Message-----
From: Seyoum, Teshome [mailto:817148@delta.com]
Sent: Thursday, July 15, 2010 6:37 AM
To: 'myodbc@lists.mysql.com'
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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

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 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
> lawson@vrtinc.com
> +1(480)308-0641
>
> -----Original Message-----
> From: Seyoum, Teshome [mailto:817148@delta.com]
> Sent: Thursday, July 15, 2010 6:37 AM
> To: 'myodbc@lists.mysql.com'
> 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/myodbc?unsub=erc@pobox.com
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org