MySQL ODBC Connector - Difficult Problem: SQLDescribeCol call on MySQL Error

Author

Difficult Problem: SQLDescribeCol call on MySQL Error

Daxin Zuo

2006-01-26, 4:56 pm

------ =_NextPart_000_00A2_
01C62195.AC54A530
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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.

------ =_NextPart_000_00A2_
01C62195.AC54A530
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
------ =_NextPart_000_00A2_
01C62195.AC54A530--

Gleb Paharenko

2006-01-26, 4:56 pm

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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ 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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links