Unresolved syms loading psqlodbc-08.00.0002's psqlodbc.so

Hello,

I am using FreeBSD 4.8

I have built and installed libiodbc-3.52.2
I have built and installed the sqlite3 odbc driver.
I have built psqlodbc-08.00.0002 (with the attached patch from the
libiobc folks which was needed because M$ has apparently changed
the api for their 64-bit architectures).

When I run libiodbc's iodbctest program, I can connect to a sqlite3
db successfully.

When I try to connect to a PostgreSql db, it fails. The error is
because the symbol 'ucs2_to_utf8' is unresolved when psqlodbc.so
is loaded.

I see that win_unicode.c contains this function, so I compiled and
included it into psqlodbc.so

I then get unresolved references to either wbtoc or iswascii depending
on whether I #define HAVE_ISWASCII

I have searched FreeBSD's libc source and /usr/include for both
those names, and they are not found.

Any suggestions?

Thank you.

Dave Bodenstab

Here is the patch supplied by the libiodbc folks:

diff -wubB psqlodbc-08.00.0002/odbcapi30.c psqlodbc-08.00.0002.new/odbcapi30.c
--- psqlodbc-08.00.0002/odbcapi30.c 2004-07-21 14:29:58.000000000 +0200
+++ psqlodbc-08.00.0002.new/odbcapi30.c 2005-02-08 10:59:23.000000000 +0100
@@ -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;

diff -wubB psqlodbc-08.00.0002/odbcapi30w.c psqlodbc-08.00.0002.new/odbcapi30w.c
--- psqlodbc-08.00.0002/odbcapi30w.c 2004-07-21 14:29:58.000000000 +0200
+++ psqlodbc-08.00.0002.new/odbcapi30w.c 2005-02-08 10:58:51.000000000 +0100
@@ -234,7 +234,7 @@
SQLPOINTER pCharAttr,
SQLSMALLINT cbCharAttrMax,
SQLSMALLINT *pcbCharAttr,
- SQLPOINTER pNumAttr)
+ SQLLEN *pNumAttr)
{
RETCODE ret;
BOOL alloced = FALSE;

--------------060801090202080304000204--