Hello,

using mysql odbc connector 3.51.10 with mysql 4.1.6, I have this strange
behaviour of SQLColumns, it only returns results when the column name is
not specified.
It happens only with mysql, the same piece of code works fine with other
database odbc drivers (db2, oracle, access,...).

I've found other related user posts in the archive but until now no
final answer has been published.

http://lists.mysql.com/bugs/13819
http://lists.mysql.com/bugs/14439

Any help appreciated

-------------------------------------------------
Thomas Paré
Société KSL
Tél : 33 (0) 4 37 59 81 44
http://www.ksl.fr


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Yes; it is something we need to look into. It simply has not made it to =
the
top of the list yet.

Peter Harvey,
Software Developer MySQL AB,
www.mysql.com
Are you MySQL certified?
www.mysql.com/certification


> -----Original Message-----
> From: Thomas Par=E9 [mailto:thomas.pare [at] ksl.fr]
> Sent: December 7, 2004 5:45 AM
> To: myodbc [at] lists.mysql.com
> Subject: ODBC, SQLColumns returns nothing when the column
> name is specified
>
> Hello,
>
> using mysql odbc connector 3.51.10 with mysql 4.1.6, I have
> this strange behaviour of SQLColumns, it only returns results
> when the column name is not specified.
> It happens only with mysql, the same piece of code works fine
> with other database odbc drivers (db2, oracle, access,...).
>
> I've found other related user posts in the archive but until
> now no final answer has been published.
>
> http://lists.mysql.com/bugs/13819
> http://lists.mysql.com/bugs/14439
>
> Any help appreciated
>
> -------------------------------------------------
> Thomas Par=E9
> Soci=E9t=E9 KSL
> T=E9l : 33 (0) 4 37 59 81 44
> http://www.ksl.fr
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=3Dpeterh [at] mysql.com
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

Hi,

I have an simlar problem with SQLColumns. When query for a the columns
for a table which has the column "order" I get no result when I also set
the catalog. When the catalog is empty all works quite well.
Here is the link for the OpenOffice.org issue
http://www.openoffice.org/issues/show_bug.cgi?id=41939

Best regards,

Ocke

Peter Harvey wrote:

>Yes; it is something we need to look into. It simply has not made it to the
>top of the list yet.
>
>Peter Harvey,
>Software Developer MySQL AB,
>www.mysql.com
>Are you MySQL certified?
>www.mysql.com/certification
>
>
>
>
>>-----Original Message-----
>>From: Thomas Paré [mailto:thomas.pare [at] ksl.fr]
>>Sent: December 7, 2004 5:45 AM
>>To: myodbc [at] lists.mysql.com
>>Subject: ODBC, SQLColumns returns nothing when the column
>>name is specified
>>
>>Hello,
>>
>>using mysql odbc connector 3.51.10 with mysql 4.1.6, I have
>>this strange behaviour of SQLColumns, it only returns results
>>when the column name is not specified.
>>It happens only with mysql, the same piece of code works fine
>>with other database odbc drivers (db2, oracle, access,...).
>>
>> I've found other related user posts in the archive but until
>>now no final answer has been published.
>>
>>http://lists.mysql.com/bugs/13819
>>http://lists.mysql.com/bugs/14439
>>
>>Any help appreciated
>>
>>-------------------------------------------------
>>Thomas Paré
>>Société KSL
>>Tél : 33 (0) 4 37 59 81 44
>>http://www.ksl.fr
>>
>>
>>--
>>MySQL ODBC Mailing List
>>For list archives: http://lists.mysql.com/myodbc
>>To unsubscribe:
>>http://lists.mysql.com/myodbc?unsub=peterh [at] mysql.com
>>
>>
>>
>
>
>--
>MySQL ODBC Mailing List
>For list archives: http://lists.mysql.com/myodbc
>To unsubscribe: http://lists.mysql.com/myodbc?unsub=Ocke.Janssen [at] sun.com
>
>
>


--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:Ocke.Janssen [at] sun.com
D-20097 Hamburg http://www.sun.com/staroffice

Example isn't another way to teach,
it is the only way to teach.
Albert Einstein


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

Hi Again,

I have an additional problem when using SQLColumns for the table
create table `i32932_1` (`id`integer not null, `N°` integer, primary
key(`id`))

When I ask SQLColumns for the column '%' and set also the catalog name
and table I get no result. When I drop the catalog, or change the column
of `N°` all works well.

Best regards,

Ocke

PS: You can see the bug report on OpenOffice.org
http://www.openoffice.org/issues/show_bug.cgi?id=32932


Ocke Janssen wrote:

> Hi,
>
> I have an simlar problem with SQLColumns. When query for a the columns
> for a table which has the column "order" I get no result when I also
> set the catalog. When the catalog is empty all works quite well.
> Here is the link for the OpenOffice.org issue
> http://www.openoffice.org/issues/show_bug.cgi?id=41939
>
> Best regards,
>
> Ocke
>
> Peter Harvey wrote:
>
>> Yes; it is something we need to look into. It simply has not made it
>> to the
>> top of the list yet.
>> Peter Harvey, Software Developer MySQL AB, www.mysql.com Are you
>> MySQL certified? www.mysql.com/certification
>>
>>
>>
>>> -----Original Message-----
>>> From: Thomas Paré [mailto:thomas.pare [at] ksl.fr] Sent: December 7, 2004
>>> 5:45 AM
>>> To: myodbc [at] lists.mysql.com
>>> Subject: ODBC, SQLColumns returns nothing when the column name is
>>> specified
>>>
>>> Hello,
>>>
>>> using mysql odbc connector 3.51.10 with mysql 4.1.6, I have this
>>> strange behaviour of SQLColumns, it only returns results when the
>>> column name is not specified.
>>> It happens only with mysql, the same piece of code works fine with
>>> other database odbc drivers (db2, oracle, access,...).
>>>
>>> I've found other related user posts in the archive but until now no
>>> final answer has been published.
>>>
>>> http://lists.mysql.com/bugs/13819
>>> http://lists.mysql.com/bugs/14439
>>>
>>> Any help appreciated
>>>
>>> -------------------------------------------------
>>> Thomas Paré
>>> Société KSL
>>> Tél : 33 (0) 4 37 59 81 44
>>> http://www.ksl.fr
>>>
>>>
>>> --
>>> MySQL ODBC Mailing List
>>> For list archives: http://lists.mysql.com/myodbc
>>> To unsubscribe: http://lists.mysql.com/myodbc?unsub=peterh [at] mysql.com
>>>
>>>
>>
>>
>>
>> --
>> MySQL ODBC Mailing List
>> For list archives: http://lists.mysql.com/myodbc
>> To unsubscribe:
>> http://lists.mysql.com/myodbc?unsub=Ocke.Janssen [at] sun.com
>>
>>
>>
>
>


--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:Ocke.Janssen [at] sun.com
D-20097 Hamburg http://www.sun.com/staroffice

Example isn't another way to teach,
it is the only way to teach.
Albert Einstein


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org