[unixODBC-support] MySQL Driver Help

Isabella Trevisan isabella.trevisan at infocamere.it
Tue Dec 9 11:27:46 GMT 2008


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
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> help ag_anag_soggetto
+----------+------------+-----------------------------------------------------------------+-----------------------------------------------------------------+----------+---------------------+------------+--------------+---------------+---------------+---------+-----------------------------------------------------------------+-----------------------------------------------------------------+--------------+-----------------+------------------+-----------------+------------+
| TABLE_CAT| TABLE_SCHEM| 
TABLE_NAME                                                      | 
COLUMN_NAME                                                     | 
DATA_TYPE| TYPE_NAME           | COLUMN_SIZE| BUFFER_LENGTH| 
DECIMAL_DIGITS| NUM_PREC_RADIX| NULLABLE| 
REMARKS                                                         | 
COLUMN_DEF                                                      | 
SQL_DATA_TYPE| SQL_DATETIME_SUB| CHAR_OCTET_LENGTH| ORDINAL_POSITION| 
IS_NULLABLE|
+----------+------------+-----------------------------------------------------------------+-----------------------------------------------------------------+----------+---------------------+------------+--------------+---------------+---------------+---------+-----------------------------------------------------------------+-----------------------------------------------------------------+--------------+-----------------+------------------+-----------------+------------+
| deis     |            | 
ag_anag_soggetto                                                | 
n_soggetto                                                      | 
4        | integer             | 11         | 4            | 
0             | 10            | 0       
|                                                                 | 
0                                                               | 
4            |                 |                  |                 | 
NO         |
| deis     |            | 
ag_anag_soggetto                                                | 
tipo_soggetto                                                   | 
1        | char                | 1          | 1            
|               |               | 0       
|                                                                 | 
''                                                              | 
1            |                 | 1                |                 | 
NO         |
| deis     |            | 
ag_anag_soggetto                                                | 
c_fiscale                                                       | 
1        | char                | 16         | 16           
|               |               | 0       
|                                                                 | 
''                                                              | 
1            |                 | 16               |                 | 
NO         |
| deis     |            | 
ag_anag_soggetto                                                | 
p_iva                                                           | 
1        | char                | 11         | 11           
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 11               |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
denominazione                                                   | 
12       | varchar             | 254        | 254          
|               |               | 1       
|                                                                 
|                                                                 | 
12           |                 | 254              |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
denominazione_bz                                                | 
12       | varchar             | 254        | 254          
|               |               | 1       
|                                                                 
|                                                                 | 
12           |                 | 254              |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
cognome                                                         | 
12       | varchar             | 30         | 30           
|               |               | 1       
|                                                                 
|                                                                 | 
12           |                 | 30               |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
nome                                                            | 
12       | varchar             | 30         | 30           
|               |               | 1       
|                                                                 
|                                                                 | 
12           |                 | 30               |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
fk_para_categoria_sogg                                          | 
1        | char                | 3          | 3            
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 3                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
sesso                                                           | 
1        | char                | 1          | 1            
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 1                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
dt_nascita                                                      | 
9        | date                | 10         | 6            
|               |               | 1       
|                                                                 
|                                                                 | 
9            |                 | 6                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
c_stato_nascita                                                 | 
1        | char                | 3          | 3            
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 3                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
fk_comu_sgl_prv_nascita                                         | 
1        | char                | 2          | 2            
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 2                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
fk_comu_c_comune_nascita                                        | 
1        | char                | 3          | 3            
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 3                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
comune_nascita                                                  | 
12       | varchar             | 60         | 60           
|               |               | 1       
|                                                                 
|                                                                 | 
12           |                 | 60               |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
comune_nascita_est                                              | 
12       | varchar             | 30         | 30           
|               |               | 1       
|                                                                 
|                                                                 | 
12           |                 | 30               |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
dt_inizio_vldt                                                  | 
9        | date                | 10         | 6            
|               |               | 0       
|                                                                 | 
'0000-00-00'                                                    | 
9            |                 | 6                |                 | 
NO         |
| deis     |            | 
ag_anag_soggetto                                                | 
status_anag                                                     | 
1        | char                | 1          | 1            
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 1                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
dt_fine_vldt                                                    | 
9        | date                | 10         | 6            
|               |               | 1       
|                                                                 
|                                                                 | 
9            |                 | 6                |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
note                                                            | 
12       | varchar             | 254        | 254          
|               |               | 1       
|                                                                 
|                                                                 | 
12           |                 | 254              |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
dt_ora_inserimento                                              | 
11       | datetime            | 19         | 16           
|               |               | 0       
|                                                                 | 
'0000-00-00 00:00:00'                                           | 
11           |                 | 16               |                 | 
NO         |
| deis     |            | 
ag_anag_soggetto                                                | 
user_inserimento                                                | 
1        | char                | 8          | 8            
|               |               | 0       
|                                                                 | 
''                                                              | 
1            |                 | 8                |                 | 
NO         |
| deis     |            | 
ag_anag_soggetto                                                | 
n_variazione                                                    | 
5        | smallint            | 2          | 2            | 
0             | 10            | 1       
|                                                                 
|                                                                 | 
5            |                 |                  |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
dt_ora_ultima_var                                               | 
11       | datetime            | 19         | 16           
|               |               | 1       
|                                                                 
|                                                                 | 
11           |                 | 16               |                 | 
YES        |
| deis     |            | 
ag_anag_soggetto                                                | 
user_ultima_var                                                 | 
1        | char                | 8          | 8            
|               |               | 1       
|                                                                 
|                                                                 | 
1            |                 | 8                |                 | 
YES        |
+----------+------------+-----------------------------------------------------------------+-----------------------------------------------------------------+----------+---------------------+------------+--------------+---------------+---------------+---------+-----------------------------------------------------------------+-----------------------------------------------------------------+--------------+-----------------+------------------+-----------------+------------+
SQLRowCount returns -1
25 rows fetched
SQL> select count(*) from ag_anag_soggetto
Segmentation Fault(coredump)



Nick Gorham ha scritto:

> Isabella Trevisan wrote:
>
>> Thank you Nick !!
>>
>> Downloaded from http://www.blastwave.org/packages.php
>>
>> This is the version of UnixODBC :
>
>
> Ok, its not going to be any of the problems I mentioned then. Does 
> that driver work with 5.1? or have they released newer versions.
>
> I do remember in the past that there were problems with the driver 
> reading ini files, but that would cause the driver to fail when 
> connecting.
>


More information about the unixODBC-support mailing list