Re: odbc and mac os x

Thanks... here is what I get..

I downloaded the 7.2.5 via ftp. uncompressed and did
your ./configure --enable-pthreads --with-iodbc

cutting and pasting to be sure I got it correct. the
make fails with this error:

gcc -r -keep_private_externs -nostdlib -o
.libs/psqlodbc.so-master.o info.lo bind.lo
columninfo.lo connection.lo convert.lo drvconn.lo
environ.lo execute.lo lobj.lo win_md5.lo misc.lo
options.lo pgtypes.lo psqlodbc.lo qresult.lo
results.lo socket.lo parse.lo statement.lo tuple.lo
tuplelist.lo dlg_specific.lo odbcapi.lo multibyte.lo
gpps.lo && gcc -bundle -o .libs/psqlodbc.so
.libs/psqlodbc.so-master.o -L/usr/local/lib
-liodbcinst -lpthread -lc
ld: Undefined symbols:
_CFBundleCopyExecutableURL
_CFBundleCopyResourceURL
_CFBundleGetBundleWithIdentifier
_CFRelease
_CFStringGetCString
_CFURLCopyFileSystemPath
___CFStringMakeConstantString
make[1]: *** [psqlodbc.la] Error 1
make: *** [all] Error 2

This looks like CoreFoundation stuff. I get this error
from any of the 4 OS X boxes that I work with. What I
don't know is whether there is a difference in your
environment settings that is linking to the CF
foundation.

Thanks for the info on creating the odbc.ini files...

Ted

--- Ray Aspeitia <aspeitia(at)sells(dot)com> wrote:
> >I all the discussions of working with the odbc
> >release, if anyone can help with creating
> >documentation on how to compile for OS X, it would
> >really help.
> >
> >I don't have the skill set to figure out what the
> >problem is and am at a loss. I did recieve a binary
> >from someone so I know it works, but for the life
> of
> >me I have not been able to compile it.
> >
> >I have posted about the problem before but never
> got
> >anywhere.
> >
> >Ted
> >
>
> Not sure what your problem is exactly but the
> following compile
> options work for me for psqlodbc-7.2.5 on OSX Server
> 10.3.x. There
> are two files that don't normally exist, that you
> must create,
> /Library/ODBC/odbc.ini, /Library/ODBC/odbcinst.ini
>
>
> ./configure --enable-pthreads --with-iodbc
> make
> sudo make install
>
>
>
>
> note create the following files in the locations
> shown after
> installing the psqlodbc driver
> if they already exist, just add the contents as
> necessary
>
>
> /Library/ODBC/odbc.ini
>
------------------------------------------------------
> [ODBC]
> Trace = 0
> TraceAutoStop = 0
> TraceFile =
> TraceLibrary =
>
> [ODBC Data Sources]
> PostgreSQL_DSN_name = PostgreSQL
>
> [PostgreSQL_DSN_name]
> Driver = /usr/local/lib/psqlodbc.so
> Description = Some DB description
> Database = my_db_name
> Servername = localhost
>
------------------------------------------------------
>
>
>
> /Library/ODBC/odbcinst.ini
>
------------------------------------------------------
> [ODBC Drivers]
> PostgreSQL = Installed
>
> [ODBC Connection Pooling]
> PerfMon = 0
>
> [PostgreSQL]
> Driver = /usr/local/lib/psqlodbc.so
> Debug = 0
> CommLog = 1
>
------------------------------------------------------
>

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/