VB6,MySQL5 and MyODBC3.51 Help

[SethPia10]

Hi guys!
Could anyone help me with this problem. I have an application created in Visual Basic 6 and MySQL4 with MyODBC3.51 the application run it well. Until my client change their SERVER into Redhat Enterprise 5 Edition and the server is now MYSQL 5, MyODBC 3.51 now it happened that the function date_format get conflict or not valid date format result.

Example:

objRs.open "select date_format('2008-01-01' ,'%m/%d/%Y') as 'TRANDATE'" ,cnn,1,3

supposed to be the output is '2008/01/01' but i've got '??????' result.

Now, what is the problem? If i run it in SQLYog result is correct but if thru recordset i've got '??????' result.

Thank you so much in advance.

 

[DonQuichote]

When you enclose your field name in string quotes, this is a syntax error. Put it in identifier quotes instead (double quotes if the server is set to ANSI mode, or backtics).

Or just remove them. This identifier does not need quotes at all.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)