Thread: odbc and mac os x

odbc and mac os x

From
Theodore Petrosky
Date:
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/

Re: odbc and mac os x

From
Jose' Cruanyes
Date:
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


Re: odbc and mac os x

From
Ray Aspeitia
Date:
>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
------------------------------------------------------


Re: odbc and mac os x

From
"Dave Page"
Date:

> -----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

Re: odbc and mac os x

From
Theodore Petrosky
Date:
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/

Re: odbc and mac os x

From
Theodore Petrosky
Date:

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/

Re: odbc and mac os x

From
Theodore Petrosky
Date:
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/

Re: odbc and mac os x

From
Ray Aspeitia
Date:
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