Обсуждение: psqlodbc-08.00.0005 + libiodbc-3.52.2 + mac os x
Hi, I've tried to compile psqlodbc-08.00.0005 with iODBC (libiodbc-3.52.2) support under Panther. The problem is as follows: gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT odbcapi30w.lo -MD -MP -MF .deps/odbcapi30w.Tpo -c odbcapi30w.c -fno-common -DPIC -o .libs/odbcapi30w.o odbcapi30w.c:238: error: conflicting types for `SQLColAttributeW' /usr/include/sqlucode.h:122: error: previous declaration of `SQLColAttributeW' make[1]: *** [odbcapi30w.lo] Error 1 make: *** [all] Error 2 How can it be fixed? Thanks! -- валя
Valia V.Vaneeva <fattie@tpu.ru> writes: > Hi, > > I've tried to compile psqlodbc-08.00.0005 with iODBC (libiodbc-3.52.2) > support under Panther. > > The problem is as follows: > > gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT odbcapi30w.lo -MD -MP -MF > .deps/odbcapi30w.Tpo -c odbcapi30w.c -fno-common -DPIC -o > .libs/odbcapi30w.o > odbcapi30w.c:238: error: conflicting types for `SQLColAttributeW' > /usr/include/sqlucode.h:122: error: previous declaration of > `SQLColAttributeW' > make[1]: *** [odbcapi30w.lo] Error 1 > make: *** [all] Error 2 > > How can it be fixed? This patch will make it compile: Index: odbcapi30.c =================================================================== RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30.c,v retrieving revision 1.31 diff -u -u -r1.31 odbcapi30.c --- odbcapi30.c 21 Jul 2004 12:29:58 -0000 1.31 +++ odbcapi30.c 16 Mar 2005 18:46:19 -0000 @@ -104,7 +104,7 @@ SQLColAttribute(HSTMT StatementHandle, SQLUSMALLINT ColumnNumber, SQLUSMALLINT FieldIdentifier, PTR CharacterAttribute, SQLSMALLINT BufferLength, - SQLSMALLINT *StringLength, PTR NumericAttribute) + SQLSMALLINT *StringLength, SQLLEN *NumericAttribute) { RETCODE ret; Index: odbcapi30w.c =================================================================== RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30w.c,v retrieving revision 1.15 diff -u -u -r1.15 odbcapi30w.c --- odbcapi30w.c 21 Jul 2004 12:29:58 -0000 1.15 +++ odbcapi30w.c 16 Mar 2005 18:46:19 -0000 @@ -234,7 +234,7 @@ SQLPOINTER pCharAttr, SQLSMALLINT cbCharAttrMax, SQLSMALLINT *pcbCharAttr, - SQLPOINTER pNumAttr) + SQLLEN *pNumAttr) { RETCODE ret; BOOL alloced = FALSE; Greetings, Tomas
This of course assumes that you have updated to a newer iODBC than what is installed by default with Panther, as the driver now wants the unicode headers. There is still some concern that this may be true of Tiger as well. Andy On 3/16/05 1:49 PM, "Tomas Skäre" <tomas@nocrew.org> pounded the keyboard to produce: > Valia V.Vaneeva <fattie@tpu.ru> writes: > >> Hi, >> >> I've tried to compile psqlodbc-08.00.0005 with iODBC (libiodbc-3.52.2) >> support under Panther. >> >> The problem is as follows: >> >> gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT odbcapi30w.lo -MD -MP -MF >> .deps/odbcapi30w.Tpo -c odbcapi30w.c -fno-common -DPIC -o >> .libs/odbcapi30w.o >> odbcapi30w.c:238: error: conflicting types for `SQLColAttributeW' >> /usr/include/sqlucode.h:122: error: previous declaration of >> `SQLColAttributeW' >> make[1]: *** [odbcapi30w.lo] Error 1 >> make: *** [all] Error 2 >> >> How can it be fixed? > > This patch will make it compile: > > Index: odbcapi30.c > =================================================================== > RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30.c,v > retrieving revision 1.31 > diff -u -u -r1.31 odbcapi30.c > --- odbcapi30.c 21 Jul 2004 12:29:58 -0000 1.31 > +++ odbcapi30.c 16 Mar 2005 18:46:19 -0000 > @@ -104,7 +104,7 @@ > SQLColAttribute(HSTMT StatementHandle, > SQLUSMALLINT ColumnNumber, SQLUSMALLINT > FieldIdentifier, > PTR CharacterAttribute, SQLSMALLINT > BufferLength, > - SQLSMALLINT *StringLength, PTR > NumericAttribute) > + SQLSMALLINT *StringLength, SQLLEN > *NumericAttribute) > { > RETCODE ret; > > Index: odbcapi30w.c > =================================================================== > RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30w.c,v > retrieving revision 1.15 > diff -u -u -r1.15 odbcapi30w.c > --- odbcapi30w.c 21 Jul 2004 12:29:58 -0000 1.15 > +++ odbcapi30w.c 16 Mar 2005 18:46:19 -0000 > @@ -234,7 +234,7 @@ > SQLPOINTER pCharAttr, > SQLSMALLINT cbCharAttrMax, > SQLSMALLINT *pcbCharAttr, > - SQLPOINTER pNumAttr) > + SQLLEN *pNumAttr) > { > RETCODE ret; > BOOL alloced = FALSE; > > > > Greetings, > > Tomas > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq
Followed yr suggestion as i faced similar problem. Compiled successfully. However during testing had this problem.... could u advise me what I shld do ? [OS=RedHat] >>iodbctestw DSN=PgSQL iODBC Unicode Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0205.0204 1: SQLDriverConnectW = [iODBC][Driver Manager]/usr/local/lib/psqlodbc.so: undefined symbol: ucs2_to_utf8 (0) SQLSTATE=00000 2: SQLDriverConnectW = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003 .sakthi ----- Original Message ----- From: "Tomas Skäre" <tomas@nocrew.org> To: "Valia V.Vaneeva" <fattie@tpu.ru> Cc: <pgsql-odbc@postgresql.org> Sent: Thursday, March 17, 2005 2:49 AM Subject: Re: [ODBC] psqlodbc-08.00.0005 + libiodbc-3.52.2 + mac os x Valia V.Vaneeva <fattie@tpu.ru> writes: > Hi, > > I've tried to compile psqlodbc-08.00.0005 with iODBC (libiodbc-3.52.2) > support under Panther. > > The problem is as follows: > > gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT odbcapi30w.lo -MD -MP -MF > .deps/odbcapi30w.Tpo -c odbcapi30w.c -fno-common -DPIC -o > .libs/odbcapi30w.o > odbcapi30w.c:238: error: conflicting types for `SQLColAttributeW' > /usr/include/sqlucode.h:122: error: previous declaration of > `SQLColAttributeW' > make[1]: *** [odbcapi30w.lo] Error 1 > make: *** [all] Error 2 > > How can it be fixed? This patch will make it compile: Index: odbcapi30.c =================================================================== RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30.c,v retrieving revision 1.31 diff -u -u -r1.31 odbcapi30.c --- odbcapi30.c 21 Jul 2004 12:29:58 -0000 1.31 +++ odbcapi30.c 16 Mar 2005 18:46:19 -0000 @@ -104,7 +104,7 @@ SQLColAttribute(HSTMT StatementHandle, SQLUSMALLINT ColumnNumber, SQLUSMALLINT FieldIdentifier, PTR CharacterAttribute, SQLSMALLINT BufferLength, - SQLSMALLINT *StringLength, PTR NumericAttribute) + SQLSMALLINT *StringLength, SQLLEN *NumericAttribute) { RETCODE ret; Index: odbcapi30w.c =================================================================== RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30w.c,v retrieving revision 1.15 diff -u -u -r1.15 odbcapi30w.c --- odbcapi30w.c 21 Jul 2004 12:29:58 -0000 1.15 +++ odbcapi30w.c 16 Mar 2005 18:46:19 -0000 @@ -234,7 +234,7 @@ SQLPOINTER pCharAttr, SQLSMALLINT cbCharAttrMax, SQLSMALLINT *pcbCharAttr, - SQLPOINTER pNumAttr) + SQLLEN *pNumAttr) { RETCODE ret; BOOL alloced = FALSE; Greetings, Tomas ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Its ok...problem resolved. http://www.webservertalk.com/archive155-2004-3-154252.html Based on the comment made in the link above....i changed my odbc.ini Driver to point to the following:- [PgSQL] ;Driver=/usr/local/lib/psqlodbc.so Driver=/usr/local/lib/libodbcpsql.so ODBC Connection works now. Thanks. ----- Original Message ----- From: "Sivasakthi d/o Sivagnanam" <sakthi@digicert.com.my> To: "Tomas Skäre" <tomas@nocrew.org> Cc: <pgsql-odbc@postgresql.org> Sent: Friday, March 18, 2005 1:10 PM Subject: Re: [ODBC] psqlodbc-08.00.0005 + libiodbc-3.52.2 + mac os x Followed yr suggestion as i faced similar problem. Compiled successfully. However during testing had this problem.... could u advise me what I shld do ? [OS=RedHat] >>iodbctestw DSN=PgSQL iODBC Unicode Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0205.0204 1: SQLDriverConnectW = [iODBC][Driver Manager]/usr/local/lib/psqlodbc.so: undefined symbol: ucs2_to_utf8 (0) SQLSTATE=00000 2: SQLDriverConnectW = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003 .sakthi ----- Original Message ----- From: "Tomas Skäre" <tomas@nocrew.org> To: "Valia V.Vaneeva" <fattie@tpu.ru> Cc: <pgsql-odbc@postgresql.org> Sent: Thursday, March 17, 2005 2:49 AM Subject: Re: [ODBC] psqlodbc-08.00.0005 + libiodbc-3.52.2 + mac os x Valia V.Vaneeva <fattie@tpu.ru> writes: > Hi, > > I've tried to compile psqlodbc-08.00.0005 with iODBC (libiodbc-3.52.2) > support under Panther. > > The problem is as follows: > > gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT odbcapi30w.lo -MD -MP -MF > .deps/odbcapi30w.Tpo -c odbcapi30w.c -fno-common -DPIC -o > .libs/odbcapi30w.o > odbcapi30w.c:238: error: conflicting types for `SQLColAttributeW' > /usr/include/sqlucode.h:122: error: previous declaration of > `SQLColAttributeW' > make[1]: *** [odbcapi30w.lo] Error 1 > make: *** [all] Error 2 > > How can it be fixed? This patch will make it compile: Index: odbcapi30.c =================================================================== RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30.c,v retrieving revision 1.31 diff -u -u -r1.31 odbcapi30.c --- odbcapi30.c 21 Jul 2004 12:29:58 -0000 1.31 +++ odbcapi30.c 16 Mar 2005 18:46:19 -0000 @@ -104,7 +104,7 @@ SQLColAttribute(HSTMT StatementHandle, SQLUSMALLINT ColumnNumber, SQLUSMALLINT FieldIdentifier, PTR CharacterAttribute, SQLSMALLINT BufferLength, - SQLSMALLINT *StringLength, PTR NumericAttribute) + SQLSMALLINT *StringLength, SQLLEN *NumericAttribute) { RETCODE ret; Index: odbcapi30w.c =================================================================== RCS file: /usr/local/cvsroot/psqlodbc/psqlodbc/odbcapi30w.c,v retrieving revision 1.15 diff -u -u -r1.15 odbcapi30w.c --- odbcapi30w.c 21 Jul 2004 12:29:58 -0000 1.15 +++ odbcapi30w.c 16 Mar 2005 18:46:19 -0000 @@ -234,7 +234,7 @@ SQLPOINTER pCharAttr, SQLSMALLINT cbCharAttrMax, SQLSMALLINT *pcbCharAttr, - SQLPOINTER pNumAttr) + SQLLEN *pNumAttr) { RETCODE ret; BOOL alloced = FALSE; Greetings, Tomas ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Has anyone solved the "undefined symbol: ucs2_to_utf8" problem yet? I have a feeling it's somehow related to shared libraries but I can't be sure. It's really biting us in the ass trying to upgrade to the version 8 odbc driver. Sivasakthi d/o Sivagnanam wrote: > Its ok...problem resolved. > http://www.webservertalk.com/archive155-2004-3-154252.html > Based on the comment made in the link above....i changed my odbc.ini Driver > to point to the following:- > [PgSQL] > ;Driver=/usr/local/lib/psqlodbc.so > Driver=/usr/local/lib/libodbcpsql.so > > ODBC Connection works now. > > Thanks. > ----- Original Message ----- > From: "Sivasakthi d/o Sivagnanam" <sakthi@digicert.com.my> > To: "Tomas Skäre" <tomas@nocrew.org> > Cc: <pgsql-odbc@postgresql.org> > Sent: Friday, March 18, 2005 1:10 PM > Subject: Re: [ODBC] psqlodbc-08.00.0005 + libiodbc-3.52.2 + mac os x > > > Followed yr suggestion as i faced similar problem. Compiled successfully. > However during testing had this problem.... could u advise me what I shld do > ? [OS=RedHat] > > >>>iodbctestw DSN=PgSQL > > iODBC Unicode Demonstration program > This program shows an interactive SQL processor > Driver Manager: 03.52.0205.0204 > 1: SQLDriverConnectW = [iODBC][Driver Manager]/usr/local/lib/psqlodbc.so: > undefined symbol: ucs2_to_utf8 (0) SQLSTATE=00000 > 2: SQLDriverConnectW = [iODBC][Driver Manager]Specified driver could not be > loaded (0) SQLSTATE=IM003 > > .sakthi -- John E. Vincent
"John E. Vincent" <jvincent@clacorp.com> writes: > Has anyone solved the "undefined symbol: ucs2_to_utf8" problem yet? I > have a feeling it's somehow related to shared libraries but I can't be > sure. It's really biting us in the ass trying to upgrade to the > version 8 odbc driver. Add win_unicode.c to the list of source files in Makefile.am, rerun automake and configure, and it should work. Despite the name, win_unicode.c seems to be not only for windows. I'm not sure this is the best solution, but it made the driver work for me. Tomas
Tomas, That did the trick. Thanks so very much! My question is why was it working in 07 and not in the 08 releases? Does it break something elsewhere? Can any of the devs provide some feedback? Tomas Skäre wrote: > "John E. Vincent" <jvincent@clacorp.com> writes: > > >>Has anyone solved the "undefined symbol: ucs2_to_utf8" problem yet? I >>have a feeling it's somehow related to shared libraries but I can't be >>sure. It's really biting us in the ass trying to upgrade to the >>version 8 odbc driver. > > > Add win_unicode.c to the list of source files in Makefile.am, rerun > automake and configure, and it should work. Despite the name, > win_unicode.c seems to be not only for windows. I'm not sure this is > the best solution, but it made the driver work for me. > > > Tomas -- John E. Vincent