Problem accessing a MySQL database from VB6 program
in [Visual Basic]
|
Prev: How to Detect Locale Change in VB6 / VBA?
Next: I'm New to VB, I wish to Pass 2 strs to a VB Function
From: Martin on 22 Mar 2010 13:49 Is anyone here accessing a MySQL database from a VB6 program? I'm doing this and all is working well with one exception. When I try to retreive a recordset via an SQL statement that includes either a DECODE() or an AES_DECRYPT() function, the value being returned is trashed. If I use the same SQL statement in the MySQL Query Browser, the value is returned correctly. By some stroke of luck, has anyone here encountered and resolved this issue who would be able to give me some clue as to how to get past it? FWIW, I have requested help in a MySQL newsgroup but have not received any advice that's led to a resolution of the problem. Thanks.
From: Norm on 22 Mar 2010 17:56 "Martin" <ironwoodcanyon(a)gmail.com> wrote in message news:b8bfq55shu449u7a6mijn6l7p56e73g87c(a)4ax.com... > Is anyone here accessing a MySQL database from a VB6 program? > > I'm doing this and all is working well with one exception. When I try > to retreive a recordset via an SQL statement that includes either a > DECODE() or an AES_DECRYPT() function, the value being returned is > trashed. If I use the same SQL statement in the MySQL Query Browser, > the value is returned correctly. > > By some stroke of luck, has anyone here encountered and resolved this > issue who would be able to give me some clue as to how to get past it? > > FWIW, I have requested help in a MySQL newsgroup but have not received > any advice that's led to a resolution of the problem. > > Thanks. Martin, Have a look here. http://www.thecommon.net/3.html This should help you. Norm
From: MikeD on 22 Mar 2010 21:50
"Martin" <ironwoodcanyon(a)gmail.com> wrote in message news:b8bfq55shu449u7a6mijn6l7p56e73g87c(a)4ax.com... > Is anyone here accessing a MySQL database from a VB6 program? > > I'm doing this and all is working well with one exception. When I try > to retreive a recordset via an SQL statement that includes either a > DECODE() or an AES_DECRYPT() function, the value being returned is > trashed. If I use the same SQL statement in the MySQL Query Browser, > the value is returned correctly. > > By some stroke of luck, has anyone here encountered and resolved this > issue who would be able to give me some clue as to how to get past it? > > FWIW, I have requested help in a MySQL newsgroup but have not received > any advice that's led to a resolution of the problem. > Probably help if you post relevant code. |