Re: Difficult Problem: SQLDescribeCol call on MySQL Error

2006-01-26 Thread Gleb Paharenko
Hello.

I'm not a MyODBC expert and not completely sure if it is your case, but
it seems that there're several bugs similar to your. See:
  http://bugs.mysql.com/bug.php?id=10148

You can find more by searching on the 'SQLDescribeCol' keyword in the
bugs database. Check that you're using the latest version of MyODBC.



Daxin Zuo wrote:
 This call works fine on Oracle, Access, MS SQL. But Not works on MySQL.
 MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in
 VC++
 
 In my SQLDescribeCol call on MySQL
 I get correct value on: 
  ColumnName, BufferLength, NameLengthPtr, NullablePtr 
 I get corect value on DataTypePtr if the type is not Text. For Text, it
 return -1. 
 I get correct value on ColumnSizePtr only if the column type is varchar, and
 datetime , 
 I get all 0 on DecimalDigitsPtr. 
 The SQLRETURN always 0.
 
 Any Instruction is welcome. 
 Thanks.
 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Difficult Problem: SQLDescribeCol call on MySQL Error

2006-01-25 Thread Daxin Zuo
This call works fine on Oracle, Access, MS SQL. But Not works on MySQL.
MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in
VC++

In my SQLDescribeCol call on MySQL
I get correct value on: 
 ColumnName, BufferLength, NameLengthPtr, NullablePtr 
I get corect value on DataTypePtr if the type is not Text. For Text, it
return -1. 
I get correct value on ColumnSizePtr only if the column type is varchar, and
datetime , 
I get all 0 on DecimalDigitsPtr. 
The SQLRETURN always 0.

Any Instruction is welcome. 
Thanks.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]