[Résolu] SqliteODBC

LudoRA · Le 21/11/2005, à 18:16

Bonjour,
Ayant récemment installé la breezy sur le pc d'un collègue, je cherche à lui rétablir petit à petit sa configuration utilisateur précédente.
Je me confronte au pb de l'accès aux bases de données SQLite via OpenOffice, donc ODBC.
OpenOffice est une suite bureautique qui set d'argument à touts les distributions Linux pour vanter leur méritent.
Seulement, et ce n'est pas spécifique à Ubuntu, entendons nous bien, je n'ai jamais vu (mandrake, debian, aurox, redhat, ...) une distribution proposant le trio gagnant SQLite, unixODBC et sqliteodbc .
Hors, c'est souvent là dessus que renvoie la liste users d'OOo fr.
Soit qque chose prête à débat sur l'utilisation du trio gagnant, et je n'en sais rien, soit je suis le seul à l'utiliser (à en regarder la liste users OOo fr, ça m'étonnerait), soit ...

En tout cas, pour le moment, j'ai trouvé unixODBC et SQLite sur les miroirs.
J'ai pris SQLiteODBC sur le site http://www.ch-werner.de/sqliteodbc/.
Lorsque je compile ça donne:

 sudo ./configure && make
loading cache ./config.cache
checking for Cygwin environment... no
checking for mingw32 environment... no
checking how to run the C preprocessor... /lib/cpp
checking host system type... i686-pc-linux-gnu
checking build system type... i686-pc-linux-gnu
checking for gcc... no
checking for cc... no
configure: error: no acceptable cc found in $PATH

J'imagine que c'est un souci de compileur, mais je ne vois pas lequel me manque.
J'imagine aussi que c'est tout bête, alors je fais appel aux bonnes âmes qui s'y connaissent bien.

Merci d'avance,

Ludo

Dernière modification par LudoRA (Le 02/03/2006, à 21:07)

yeffries · Le 22/11/2005, à 11:40

checking for gcc... no

J'ai l'impression qu'il te manque certains paquets afin de compiler sqliteodbc.
As-tu le paquet build-essential installé ?

LudoRA · Le 23/11/2005, à 17:56

Bonjour.

Tout d'abord, merci pour la réponse. Ca m'a fait aller plus loin d'installer le paquet build-essential.
Mais ça n'a pas tout résolu non plus. Voici ce qui m'arrive:

sudo ./configure && make
loading cache ./config.cache
checking for Cygwin environment... (cached) no
checking for mingw32 environment... (cached) no
checking how to run the C preprocessor... (cached) cc -E
checking host system type... i686-pc-linux-gnu
checking build system type... i686-pc-linux-gnu
checking for gcc... (cached) gcc
checking whether the C compiler (gcc  ) works... yes
checking whether the C compiler (gcc  ) is a cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for ld used by GCC... (cached) /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes
checking for /usr/bin/ld option to reload object files... (cached) -r
checking for BSD-compatible nm... (cached) /usr/bin/nm -B
checking whether ln -s works... (cached) yes
checking how to recognise dependant libraries... (cached) pass_all
checking for object suffix... (cached) o
checking for executable suffix... (cached) no
checking command to parse /usr/bin/nm -B output... (cached) ok
checking for dlfcn.h... (cached) yes
checking for ranlib... (cached) ranlib
checking for strip... (cached) strip
checking for objdir... .libs
checking for gcc option to produce PIC... (cached)    -fPIC
checking if gcc PIC flag    -fPIC works... (cached) yes
checking if gcc static flag -static works... (cached) yes
checking if gcc supports -c -o file.o... (cached) yes
checking if gcc supports -c -o file.lo... (cached) yes
checking if gcc supports -fno-rtti -fno-exceptions... yes
checking whether the linker (/usr/bin/ld) supports shared libraries... yes
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking if libtool supports shared libraries... yes
checking whether -lc should be explicitly linked in... (cached) no
creating libtool
checking for a BSD compatible install... (cached) /usr/bin/install -c
checking for SQLite header and library... yes
checking for sqlite_libversion in -lsqlite... (cached) yes
checking for sqlite_compile in -lsqlite... (cached) yes
checking for sqlite_encode_binary in -lsqlite... (cached) yes
checking for sqliteAtoF in -lsqlite... (cached) yes
checking for sqlite_mprintf in -lsqlite... (cached) yes
checking for sqlite_trace in -lsqlite... (cached) yes
checking for SQLite3 header and library... no
configure: warning: SQLite3 header files and/or library not found
checking for sqlite3AtoF in -lsqlite3... (cached) no
checking for ODBC headers and libraries... yes
checking for usleep... (cached) yes
checking for localeconv... (cached) yes
checking for localtime_r... (cached) yes
checking for gmtime_r... (cached) yes
updating cache ./config.cache
creating ./config.status
creating Makefile
creating sqliteodbc.spec
./libtool gcc -g -O2 -c -I/usr/include -DHAVE_UNIXODBC=1 -I/usr/include -DHAVE_ODBCINSTEXT_H=1 -Imissing -DHAVE_USLEEP=1 -DHAVE_LOCALECONV=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 \
            -DHAVE_LIBVERSION=1 -DHAVE_ENCDEC=1 -DHAVE_SQLITEATOF=1 -DHAVE_SQLITEMPRINTF=1 -DHAVE_SQLITETRACE=1 sqliteodbc.c
mkdir .libs
gcc -g -O2 -c -I/usr/include -DHAVE_UNIXODBC=1 -I/usr/include -DHAVE_ODBCINSTEXT_H=1 -Imissing -DHAVE_USLEEP=1 -DHAVE_LOCALECONV=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_LIBVERSION=1 -DHAVE_ENCDEC=1 -DHAVE_SQLITEATOF=1 -DHAVE_SQLITEMPRINTF=1 -DHAVE_SQLITETRACE=1 sqliteodbc.c     -fPIC -DPIC -o .libs/sqliteodbc.lo
sqliteodbc.c: In function 'uc_from_utf':
sqliteodbc.c:467: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c: In function 'setstatd':
sqliteodbc.c:655: warning: pointer targets in passing argument 1 of 'vsnprintf' differ in signedness
sqliteodbc.c: In function 'setstat':
sqliteodbc.c:695: warning: pointer targets in passing argument 1 of 'vsnprintf' differ in signedness
sqliteodbc.c: In function 'setsqliteopts':
sqliteodbc.c:969: error: invalid storage class for function 'hextobin_func'
sqliteodbc.c:971: error: invalid storage class for function 'bintohex_func'
sqliteodbc.c:974: error: 'hextobin_func' undeclared (first use in this function)
sqliteodbc.c:974: error: (Each undeclared identifier is reported only once
sqliteodbc.c:974: error: for each function it appears in.)
sqliteodbc.c:977: error: 'bintohex_func' undeclared (first use in this function)
sqliteodbc.c:984: error: invalid storage class for function 'time_func'
sqliteodbc.c:987: error: 'time_func' undeclared (first use in this function)
sqliteodbc.c: In function 'vm_start':
sqliteodbc.c:2417: warning: pointer targets in passing argument 1 of 'sqlite_vmprintf' differ in signedness
sqliteodbc.c: In function 'hextobin_func':
sqliteodbc.c:2661: warning: pointer targets in passing argument 1 of 'sqlite_encode_binary' differ in signedness
sqliteodbc.c:2667: warning: pointer targets in passing argument 1 of 'sqlite_encode_binary' differ in signedness
sqliteodbc.c:2667: warning: pointer targets in passing argument 3 of 'sqlite_encode_binary' differ in signedness
sqliteodbc.c: In function 'bintohex_func':
sqliteodbc.c:2700: warning: pointer targets in passing argument 1 of 'sqlite_decode_binary' differ in signedness
sqliteodbc.c:2700: warning: pointer targets in passing argument 2 of 'sqlite_decode_binary' differ in signedness
sqliteodbc.c: In function 'hextobin':
sqliteodbc.c:2768: warning: pointer targets in passing argument 1 of 'sqlite_encode_binary' differ in signedness
sqliteodbc.c:2774: warning: pointer targets in passing argument 1 of 'sqlite_encode_binary' differ in signedness
sqliteodbc.c:2774: warning: pointer targets in passing argument 3 of 'sqlite_encode_binary' differ in signedness
sqliteodbc.c: In function 'SQLPutData':
sqliteodbc.c:2978: warning: pointer targets in passing argument 3 of 'sqlite_encode_binary' differ in signedness
sqliteodbc.c: In function 'drvprimarykeys':
sqliteodbc.c:3865: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'SQLPrimaryKeysW':
sqliteodbc.c:4083: warning: pointer targets in passing argument 2 of 'drvprimarykeys' differ in signedness
sqliteodbc.c:4083: warning: pointer targets in passing argument 4 of 'drvprimarykeys' differ in signedness
sqliteodbc.c:4083: warning: pointer targets in passing argument 6 of 'drvprimarykeys' differ in signedness
sqliteodbc.c: In function 'drvspecialcolumns':
sqliteodbc.c:4154: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'SQLSpecialColumnsW':
sqliteodbc.c:4432: warning: pointer targets in passing argument 3 of 'drvspecialcolumns' differ in signedness
sqliteodbc.c:4432: warning: pointer targets in passing argument 5 of 'drvspecialcolumns' differ in signedness
sqliteodbc.c:4432: warning: pointer targets in passing argument 7 of 'drvspecialcolumns' differ in signedness
sqliteodbc.c: In function 'drvforeignkeys':
sqliteodbc.c:4513: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:4523: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'SQLForeignKeysW':
sqliteodbc.c:4870: warning: pointer targets in passing argument 2 of 'drvforeignkeys' differ in signedness
sqliteodbc.c:4870: warning: pointer targets in passing argument 4 of 'drvforeignkeys' differ in signedness
sqliteodbc.c:4870: warning: pointer targets in passing argument 6 of 'drvforeignkeys' differ in signedness
sqliteodbc.c:4870: warning: pointer targets in passing argument 8 of 'drvforeignkeys' differ in signedness
sqliteodbc.c:4870: warning: pointer targets in passing argument 10 of 'drvforeignkeys' differ in signedness
sqliteodbc.c:4870: warning: pointer targets in passing argument 12 of 'drvforeignkeys' differ in signedness
sqliteodbc.c: In function 'drvgetdiagrec':
sqliteodbc.c:5385: warning: pointer targets in assignment differ in signedness
sqliteodbc.c:5391: warning: pointer targets in assignment differ in signedness
sqliteodbc.c:5412: warning: pointer targets in passing argument 1 of 'strcpy' differ in signedness
sqliteodbc.c:5419: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:5424: warning: pointer targets in passing argument 1 of 'strcpy' differ in signedness
sqliteodbc.c: In function 'SQLGetInfoW':
sqliteodbc.c:6556: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
sqliteodbc.c: In function 'drvconnect':
sqliteodbc.c:7460: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:7503: warning: pointer targets in passing argument 3 of 'dbopen' differ in signedness
sqliteodbc.c: In function 'SQLConnectW':
sqliteodbc.c:7558: warning: pointer targets in passing argument 2 of 'drvconnect' differ in signedness
sqliteodbc.c: In function 'drvdriverconnect':
sqliteodbc.c:7649: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:7724: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'drvallocstmt':
sqliteodbc.c:7821: warning: pointer targets in passing argument 1 of 'sprintf' differ in signedness
sqliteodbc.c: In function 'drvgetcursorname':
sqliteodbc.c:7931: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c:7936: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:7936: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:7940: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c:7940: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c: In function 'SQLGetCursorNameW':
sqliteodbc.c:7986: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
sqliteodbc.c: In function 'drvsetcursorname':
sqliteodbc.c:8033: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:8033: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'SQLSetCursorNameW':
sqliteodbc.c:8075: warning: pointer targets in passing argument 2 of 'drvsetcursorname' differ in signedness
sqliteodbc.c: In function 'getrowdata':
sqliteodbc.c:8452: warning: pointer targets in passing argument 1 of 'sqlite_decode_binary' differ in signedness
sqliteodbc.c:8452: warning: pointer targets in passing argument 2 of 'sqlite_decode_binary' differ in signedness
sqliteodbc.c:8563: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
sqliteodbc.c: In function 'drvtables':
sqliteodbc.c:8888: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:8893: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:8936: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'SQLTablesW':
sqliteodbc.c:9050: warning: pointer targets in passing argument 2 of 'drvtables' differ in signedness
sqliteodbc.c:9050: warning: pointer targets in passing argument 4 of 'drvtables' differ in signedness
sqliteodbc.c:9050: warning: pointer targets in passing argument 6 of 'drvtables' differ in signedness
sqliteodbc.c:9050: warning: pointer targets in passing argument 8 of 'drvtables' differ in signedness
sqliteodbc.c: In function 'drvcolumns':
sqliteodbc.c:9127: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'SQLColumnsW':
sqliteodbc.c:9321: warning: pointer targets in passing argument 2 of 'drvcolumns' differ in signedness
sqliteodbc.c:9321: warning: pointer targets in passing argument 4 of 'drvcolumns' differ in signedness
sqliteodbc.c:9321: warning: pointer targets in passing argument 6 of 'drvcolumns' differ in signedness
sqliteodbc.c:9321: warning: pointer targets in passing argument 8 of 'drvcolumns' differ in signedness
sqliteodbc.c: In function 'drvstatistics':
sqliteodbc.c:9778: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c: In function 'SQLStatisticsW':
sqliteodbc.c:10023: warning: pointer targets in passing argument 2 of 'drvstatistics' differ in signedness
sqliteodbc.c:10023: warning: pointer targets in passing argument 4 of 'drvstatistics' differ in signedness
sqliteodbc.c:10023: warning: pointer targets in passing argument 6 of 'drvstatistics' differ in signedness
sqliteodbc.c: In function 'drvdescribecol':
sqliteodbc.c:10545: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:10551: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c: In function 'SQLDescribeColW':
sqliteodbc.c:10639: warning: pointer targets in passing argument 3 of 'drvdescribecol' differ in signedness
sqliteodbc.c:10645: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
sqliteodbc.c: In function 'SQLColAttributesW':
sqliteodbc.c:10957: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
sqliteodbc.c: In function 'SQLColAttributeW':
sqliteodbc.c:11250: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
sqliteodbc.c: In function 'drverror':
sqliteodbc.c:11328: warning: pointer targets in passing argument 1 of 'strcpy' differ in signedness
sqliteodbc.c:11330: warning: pointer targets in passing argument 1 of 'strcpy' differ in signedness
sqliteodbc.c:11331: warning: pointer targets in passing argument 1 of 'strcat' differ in signedness
sqliteodbc.c:11331: warning: pointer targets in passing argument 2 of 'strcat' differ in signedness
sqliteodbc.c:11332: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c:11334: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:11336: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:11336: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:11338: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c:11338: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c:11350: warning: pointer targets in passing argument 1 of 'strcpy' differ in signedness
sqliteodbc.c:11352: warning: pointer targets in passing argument 1 of 'strcpy' differ in signedness
sqliteodbc.c:11353: warning: pointer targets in passing argument 1 of 'strcat' differ in signedness
sqliteodbc.c:11353: warning: pointer targets in passing argument 2 of 'strcat' differ in signedness
sqliteodbc.c:11354: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c:11356: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:11358: warning: pointer targets in passing argument 1 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:11358: warning: pointer targets in passing argument 2 of '__builtin_strncpy' differ in signedness
sqliteodbc.c:11360: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c:11360: warning: pointer targets in passing argument 1 of 'strlen' differ in signedness
sqliteodbc.c: In function 'SQLErrorW':
sqliteodbc.c:11421: warning: pointer targets in passing argument 4 of 'drverror' differ in signedness
sqliteodbc.c:11421: warning: pointer targets in passing argument 6 of 'drverror' differ in signedness
sqliteodbc.c:11424: warning: pointer targets in passing argument 1 of 'uc_from_utf_buf' differ in signedness
sqliteodbc.c:11430: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
sqliteodbc.c: In function 'drvprepare':
sqliteodbc.c:11592: warning: pointer targets in passing argument 1 of 'fixupsql' differ in signedness
sqliteodbc.c:11592: warning: pointer targets in assignment differ in signedness
sqliteodbc.c:11618: warning: pointer targets in passing argument 2 of 'sqlite_exec_vprintf' differ in signedness
sqliteodbc.c: In function 'drvexecute':
sqliteodbc.c:11739: warning: pointer targets in passing argument 2 of 'sqlite_get_table_vprintf' differ in signedness
sqliteodbc.c: In function 'SQLPrepareW':
sqliteodbc.c:11896: warning: pointer targets in passing argument 2 of 'drvprepare' differ in signedness
sqliteodbc.c: In function 'SQLExecDirectW':
sqliteodbc.c:11951: warning: pointer targets in passing argument 2 of 'drvprepare' differ in signedness
sqliteodbc.c: In function 'SQLDriverConnectW':
sqliteodbc.c:12588: warning: pointer targets in passing argument 3 of 'drvdriverconnect' differ in signedness
sqliteodbc.c:12588: warning: pointer targets in passing argument 5 of 'drvdriverconnect' differ in signedness
sqliteodbc.c:12595: warning: pointer targets in passing argument 1 of 'uc_from_utf' differ in signedness
make: *** [sqliteodbc.lo] Erreur 1

Là, je ne comprend pas bien ce qu'on me raconte.

Une idée???

A bientôt

LudoRA · Le 26/11/2005, à 12:32

Personne n'a d'idées sur le problème???

alain_72 · Le 26/11/2005, à 12:46

LudoRA a écrit :

Personne n'a d'idées sur le problème???

As-tu installé les paquets libiodbc2 et libiodbc-dev, qui sont, me semble-t-il, requis pour permettre à sqliteodbc de fonctionner ?

LudoRA · Le 30/11/2005, à 11:34

Bonjour,

A priori, si iodbc est une possibilité de connexion à Sqlite, ce n'est pas la seule dans le registre ODBC, puisqu'il existe aussi unixODBC, avec lequel, j'ai plus l'habitude. Mais peut-être je me trompe.
Cependant, une fois iodbc installé, le ./configure && make sur sqliteodbc renvoie la même erreur qu'avant installation.
???

LudoRA · Le 05/12/2005, à 13:40

Toujours pas d'idées????

Dernière modification par LudoRA (Le 05/12/2005, à 13:41)

LudoRA · Le 14/12/2005, à 11:06

Perso, je n'avance pas tout seul sur ce point là.
Sur d'autres oui, mais là, je ne sais quoi faire.

Alors, si le problème vous paraît simple, n'hésitez pas à,m'aider.

LudoRA · Le 19/12/2005, à 12:23

J'aime pas faire ça, mais bon, je reposte un message pour réapparaître dans les premiers messages.

LudoRA · Le 19/12/2005, à 16:04

J'ai tenté une conversion de source rpm en paquet debian avec Alien. Résultat, l'installation du paquet ne créé que la documentation (dans share), le paquet tar.gz et un .spec à la racine (/).
Depuis, je l'ai désinstallé, puisqu'inutile. Désespérément, j'ai donc retenté avec mon paquet tar.gz. cette fois, je ne sais pas pourquoi, j'obtiens ça:

sudo ./configure && make
loading cache ./config.cache
checking for Cygwin environment... (cached) no
checking for mingw32 environment... (cached) no
checking how to run the C preprocessor... (cached) cc -E
checking host system type... i686-pc-linux-gnu
checking build system type... i686-pc-linux-gnu
checking for gcc... (cached) gcc
checking whether the C compiler (gcc ) works... yes
checking whether the C compiler (gcc ) is a cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for ld used by GCC... (cached) /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes
checking for /usr/bin/ld option to reload object files... (cached) -r
checking for BSD-compatible nm... (cached) /usr/bin/nm -B
checking whether ln -s works... (cached) yes
checking how to recognise dependant libraries... (cached) pass_all
checking for object suffix... (cached) o
checking for executable suffix... (cached) no
checking command to parse /usr/bin/nm -B output... (cached) ok
checking for dlfcn.h... (cached) yes
checking for ranlib... (cached) ranlib
checking for strip... (cached) strip
checking for objdir... .libs
checking for gcc option to produce PIC... (cached) -fPIC
checking if gcc PIC flag -fPIC works... (cached) yes
checking if gcc static flag -static works... (cached) yes
checking if gcc supports -c -o file.o... (cached) yes
checking if gcc supports -c -o file.lo... (cached) yes
checking if gcc supports -fno-rtti -fno-exceptions... yes
checking whether the linker (/usr/bin/ld) supports shared libraries... yes
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking if libtool supports shared libraries... yes
checking whether -lc should be explicitly linked in... (cached) no
creating libtool
checking for a BSD compatible install... (cached) /usr/bin/install -c
checking for SQLite header and library... yes
checking for sqlite_libversion in -lsqlite... (cached) yes
checking for sqlite_compile in -lsqlite... (cached) yes
checking for sqlite_encode_binary in -lsqlite... (cached) yes
checking for sqliteAtoF in -lsqlite... (cached) yes
checking for sqlite_mprintf in -lsqlite... (cached) yes
checking for sqlite_trace in -lsqlite... (cached) yes
checking for SQLite3 header and library... no
configure: warning: SQLite3 header files and/or library not found
checking for sqlite3AtoF in -lsqlite3... (cached) no
checking for ODBC headers and libraries... yes
checking for usleep... (cached) yes
checking for localeconv... (cached) yes
checking for localtime_r... (cached) yes
checking for gmtime_r... (cached) yes
updating cache ./config.cache
creating ./config.status
creating Makefile
creating sqliteodbc.spec
./libtool gcc -g -O2 -c -I/usr/include -DHAVE_IODBC=1 -I/usr/include -DHAVE_USLEEP=1 -DHAVE_LOCALECONV=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 \
-DHAVE_LIBVERSION=1 -DHAVE_ENCDEC=1 -DHAVE_SQLITEATOF=1 -DHAVE_SQLITEMPRINTF=1 -DHAVE_SQLITETRACE=1 sqliteodbc.c
mkdir .libs
mkdir: cannot create directory `.libs': Permission denied
make: *** [sqliteodbc.lo] Erreur 1

Ce qui est une avancée en soit. Sauf que je ne vois pas pourquoi je n'ai pas la permission de créer un répertoire '.libs' .

En attendant, pas moyen d'utiliser ma bdd OpenOffice avec Ubuntu.

A bientôt,

Ludo

yeffries · Le 19/12/2005, à 18:00

Depuis le temps que tu cherches une solution, je me suis dit qu'il fallait quand même que j'essaie quelque chose !

Alors désolé si tu veux installer la version 0.64, j'arrive exactement au même résultat que toi. (avec la 0.63 aussi d'ailleurs...)

Mais si ça ne t'embête pas d'installer la version 0.62, ça roule tout seul !
J'arrive à me connecter à ma base d'un seul coup, grâce à ce driver.

J'espère que ça marchera sur ton ordi aussi !

Voilà tout ce qui a été corrigé ou ajouté depuis la version 0.62, à toi de voir si ça vaut le coup:

Thu Oct 07 2004 version 0.65 released
* first (alpha) version of SQLite3 driver for Win32
* fixes in Win32 resources
* minor tweaks in SQLGetInfo()
* fixes in length return of SQLGetInfoW() concerning UNICODE data
* fixed errors in orientation/offset handling of SQLExtendedFetch/
SQLFetchScroll, thanks Lucky Prianata for testing
* added handling of SQL_ATTR_ROW_BIND_OFFSET_PTR for statements
* added handling of SQL_ATTR_RETRIEVE_DATA for statements
(seems to be needed by ADO)
Sun Sep 05 2004 version 0.64 released
* added row-wise binding for rowsets
* fixed off-by-one error for SQL_FETCH_PRIOR
* another bug fix in fixupsql() concerning quotes thanks to
Justin Foutts
* always fallback to _ROWID_ in SQLSpecialColumns(SQL_BEST_ROWID)
even for tables w/o index
* update to SQLite 2.8.15
* fixes concerning SQL_COLUMN_LABEL in SQLColumnAttribute(s)
Thu Jul 08 2004 version 0.63 released
* added tracefile DSN option using sqlite_trace() if available
* in drvprepare() make SQL check with all parameters set to NULL
* only use *step() for select statements w/o parameters
(makes option usable on OpenOffice.org on Linux)
* added pre-alpha version for SQLite 3.x
* added limited support for paramsets/rowset for OTLv4
* added limited support for named parameters (Oracle-style)
* fixed problem in SQLBindParameter argument checking
* when using gcc do printf-style format checks on setstat/setstatd
* added SQLite functions current_(date|time|datetime)_(local|utc)
* include SQLite error codes or -1 in native error field in
SQLError() and SQLGetDiagRec()
* bug fixes in SQLNativeSql() concerning buffer/length
semantics, thanks to N Rajesh
* corrected problems in fixupdyncols (select on views) and
UN*X version of drvdriverconnect
* added SQLite functions hextobin/bintohex when
sqlite_(encode|decode)_binary API available
* introduced blob handling when sqlite_(encode|decode)_binary
available (SQLite 2.8.14 made these APIs public)
* update to SQLite 2.8.14
* made SQL_COLUMN_LABEL different from SQL_COLUMN_NAME
* fix in configure.in concerning SQLITE_INC/LIBDIR macros,
thanks to Stefan Radman

Dernière modification par yeffries (Le 19/12/2005, à 18:07)

LudoRA · Le 20/12/2005, à 16:39

Bonjour,

Merci d'avoir répondu.
Bon, ça fonctionne avec une vesion 0.62 .
J'avoue ne pas savoir si le fait d'utiliser cette version va me poser pb ou pas.
En tous ca, merci de m'avoir enlevé cette épine du doigts.

Je vais affiché ce problème comme résolu, mais je pense qu'il serait nécessaire de se pencher sur la question de :
- permettre l'installation du 0.64
- de permettre une installation via un paquet .deb de sqliteodbc

A bientôt,

Ludo

LudoRA · Le 02/03/2006, à 17:59

Bonjour.

Je reviens à la charge. En fait, il y'a quand même des inconvénients à utiliser la version 0.62 plutôt que 0.64. En effet, les noms de champs sont raccourcis à 1,2 voire 3 lettres selon la chance que l'on a.
Quelqu'un a t-il trouvé une solution pour installer SQLiteODBC V 0.64 ???

Merci de votre aide.

Ciao!

Ludo

LudoRA · Le 02/03/2006, à 21:06

Après discussion avec Christian Werner, le développeur du pilote sqliteodbc, il semblerai que le le problème d'installation d'une version supérieure à 0.62 soit résolu à partir de la 0.66.
Je copie-colle sa réponse:

please try the latest 0.66 release from http://www.ch-werner.de/sqliteodbc
It has fixed numerous problems in combination with gcc >= 4.0. I think,
from the forum postings that this is the main reason it did not compile.
Please verify that you have installed unixODBC libraries and header files
(do not use iODBC, it caused trouble with Ruby/ODBC on newer Ubuntus).

Je n'ai pas repéré d'anomalies à l'installation. Tout c'est très bien passé.
A noté, le conseil de ne pas utiliser iODBC sur Ubuntu.
Ensuite, mon problème de nom de colonne persiste, même avec la 0.66.
Je vais donc affiché le problème comme résolu et ouvrir un nouveau fil de discussion.

Merci pour les coups de main.

Ludo

LudoRA · Le 21/03/2006, à 12:31

Bonjour,

Toujours après discussion avec Christian WERNER, il me signale qu'il a créer une seconde prerelease.

In the meantime I uploaded a new prerelease
http:/www.ch-werner.de/sqliteodbc/sqliteodbc-0.67pre2.tar.gz
which has an additional configure option to deal with this
compile problem.
Please try ./configure --disable-winterface ... on Ubuntu. This turns
off the UNICODE SQL functions in the driver.

Je l'ai testée, ça fonctionne sans soucis.
Un contact a été pris avec le projet unixODBC. Le problème des unicodes devrait être résolu dans la prochaine version stable.

Ciao!

Ludo

Ubuntu-fr

Navigation

Liens de recherche

Annonce

#1 Le 21/11/2005, à 18:16

[Résolu] SqliteODBC

#2 Le 22/11/2005, à 11:40

Re : [Résolu] SqliteODBC

#3 Le 23/11/2005, à 17:56

Re : [Résolu] SqliteODBC

#4 Le 26/11/2005, à 12:32

Re : [Résolu] SqliteODBC

#5 Le 26/11/2005, à 12:46

Re : [Résolu] SqliteODBC

#6 Le 30/11/2005, à 11:34

Re : [Résolu] SqliteODBC

#7 Le 05/12/2005, à 13:40

Re : [Résolu] SqliteODBC

#8 Le 14/12/2005, à 11:06

Re : [Résolu] SqliteODBC

#9 Le 19/12/2005, à 12:23

Re : [Résolu] SqliteODBC

#10 Le 19/12/2005, à 16:04

Re : [Résolu] SqliteODBC

#11 Le 19/12/2005, à 18:00

Re : [Résolu] SqliteODBC

#12 Le 20/12/2005, à 16:39

Re : [Résolu] SqliteODBC

#13 Le 02/03/2006, à 17:59

Re : [Résolu] SqliteODBC

#14 Le 02/03/2006, à 21:06

Re : [Résolu] SqliteODBC

#15 Le 21/03/2006, à 12:31

Re : [Résolu] SqliteODBC

Pied de page des forums