Thread: odbc and mac os x
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 __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/
seems that the autoconf stuff is not up to date with MacOSX. the sequence ./configure make creates a .la file instead of a .dylib On Apr 5, 2004, at 2:15 PM, Theodore Petrosky 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. Pax et Bonum # dott. Jose' Cruanyes Aguilar - C.E. Soft srl # Pzza. Firenze,4 MILANO - XX Settembre 10, CREMONA # 02,33603122 0372,460602
>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 ------------------------------------------------------
> -----Original Message----- > From: Jose' Cruanyes [mailto:cruanyes@cegroup.it] > Sent: 05 April 2004 14:05 > To: Theodore Petrosky > Cc: pgsql-odbc@postgresql.org > Subject: Re: [ODBC] odbc and mac os x > > seems that the autoconf stuff is not up to date with MacOSX. > > the sequence > > ./configure > make > > creates a .la file instead of a .dylib Is that all that's required - a name change on that platform? What does the uname -a output look like? Regards, Dave
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@sells.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/
here is my uname -a Darwin Ted.local 7.3.0 Darwin Kernel Version 7.3.0: Fri Mar 5 14:22:55 PST 2004; root:xnu/xnu-517.3.15.obj~4/RELEASE_PPC Power Macintosh powerpc Ted --- Dave Page <dpage@vale-housing.co.uk> wrote: > > > > -----Original Message----- > > From: Jose' Cruanyes [mailto:cruanyes@cegroup.it] > > Sent: 05 April 2004 14:05 > > To: Theodore Petrosky > > Cc: pgsql-odbc@postgresql.org > > Subject: Re: [ODBC] odbc and mac os x > > > > seems that the autoconf stuff is not up to date > with MacOSX. > > > > the sequence > > > > ./configure > > make > > > > creates a .la file instead of a .dylib > > Is that all that's required - a name change on that > platform? What does > the uname -a output look like? > > Regards, Dave > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/
BTW, Ray.. I see you are working on OS X server. I am using OS X client. there must be a difference in the env. here is my ouput from the env command: TERM_PROGRAM=Apple_Terminal TERM=xterm-color SHELL=/bin/bash TERM_PROGRAM_VERSION=100 USER=sacksadmin __CF_USER_TEXT_ENCODING=0x1F5:0:0 PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/pgsql/bin PWD=/Users/sacksadmin/Documents/psqlodbc-7.2.5 SHLVL=1 HOME=/Users/sacksadmin LOGNAME=sacksadmin SECURITYSESSIONID=2119e0 _=/usr/bin/env OLDPWD=/Users/sacksadmin/Documents/psqlodbc-7.2.5 Do you see any difference with yours that would matter? Ted --- Ray Aspeitia <aspeitia@sells.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 > ------------------------------------------------------ > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > > http://www.postgresql.org/docs/faqs/FAQ.html---------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.htmlgresql.org/docs/faqs/FAQ.html __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/
Not sure what to tell you there. My env settings look exactly like yours except for /usr/local/bin in my path. Not sure but, do you know what the -nostdlib flag in your gcc string means/came from? Ray A. At 7:22 AM -0700 4/5/04, Theodore Petrosky wrote: >BTW, Ray.. I see you are working on OS X server. I am >using OS X client. there must be a difference in the >env. > >here is my ouput from the env command: > >TERM_PROGRAM=Apple_Terminal >TERM=xterm-color >SHELL=/bin/bash >TERM_PROGRAM_VERSION=100 >USER=sacksadmin >__CF_USER_TEXT_ENCODING=0x1F5:0:0 >PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/pgsql/bin >PWD=/Users/sacksadmin/Documents/psqlodbc-7.2.5 >SHLVL=1 >HOME=/Users/sacksadmin >LOGNAME=sacksadmin >SECURITYSESSIONID=2119e0 >_=/usr/bin/env >OLDPWD=/Users/sacksadmin/Documents/psqlodbc-7.2.5 > >Do you see any difference with yours that would >matter? > >Ted