Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#1: help!

Posted on 2010-07-15 15:36:46 by 817148

--_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_--

Report this message

#2: RE: help!

Posted on 2010-07-15 19:31:03 by Lawson Cronlund

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

Report this message

#3: Re: help!

Posted on 2010-07-15 19:45:10 by Ed Carp

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 <lawson@vrtinc.com> 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

Report this message