[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