Re: psqlodbc-08.00.0005 + libiodbc-3.52.2 + mac os x

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(at)digicert(dot)com(dot)my>
To: "Tomas Skäre" <tomas(at)nocrew(dot)org>
Cc: <pgsql-odbc(at)postgresql(dot)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(at)nocrew(dot)org>
To: "Valia V.Vaneeva" <fattie(at)tpu(dot)ru>
Cc: <pgsql-odbc(at)postgresql(dot)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(at)tpu(dot)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