[unixODBC-support] MySQL Driver Help

[Isabella Trevisan]

This is what I get with the trace :

fpx10:[root]>/tmp # more odbc-sql.log
[ODBC][15624][__handles.c][447]
                Exit:[SQL_SUCCESS]
                        Environment = 26998
[ODBC][15624][SQLAllocHandle.c][358]
                Entry:
                        Handle Type = 2
                        Input Handle = 26998
[ODBC][15624][SQLAllocHandle.c][476]
                Exit:[SQL_SUCCESS]
                        Output Handle = 277c8
[ODBC][15624][SQLConnect.c][3586]
                Entry:
                        Connection = 277c8
                        Server Name = [myodbc3][length = 7 (SQL_NTS)]
                        User Name = [NULL]
                        Authentication = [NULL]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 
'UCS-2BE'

[ODBC][15624][SQLConnect.c][4160]
                Exit:[SQL_SUCCESS]
[ODBC][15624][SQLAllocHandle.c][523]
                Entry:
                        Handle Type = 3
                        Input Handle = 277c8
[ODBC][15624][SQLAllocHandle.c][1058]
                Exit:[SQL_SUCCESS]
                        Output Handle = 447b8
[ODBC][15624][SQLPrepare.c][192]
                Entry:
                        Statement = 447b8
                        SQL = [select count(*) from ag_anag_soggetto 
][length = 38 (SQL_NTS)]


Nick Gorham ha scritto:

> Isabella Trevisan wrote:
>
>> I tryed with mysql ODBC connectors 5.1 which is the newest release 
>> but I have the same problem which is not on the connection which is 
>> successful but on teh subsequent query :
>> fpx10:[root]>/opt/csw/bin # isql -v myodbc5
>
>
>
> Maybe turn on tracing, in odbcinst.ini
>
> [ODBC]
> Trace = Yes
> TraceFile = /tmp/sql.log
>
> run the query and see what you get.
>
> Other than that, the next step would be building you own unixODBC from 
> source.
>