1: Download latest version from http://www.us.postgresql.org/software.html
2: install it, MAKING SURE I do a ./configure --enable-odbc 3: Add a CFUSER, by dropping to /usr/local/pgsql/bin/ then doing a /createuser -a -d -P cfadmin 4: test that new user against the TEST database (create a new datasource and simply verify it). 5: download the unixodbc current version from http://www.unixodbc.com/ 6: untar, do a ./configure... then try a make: /bin/sh ../libtool --mode=link gcc -g -O2 -pthread -o libodbcextras.la -rpath /usr/local/lib -version-info 1:0:0 -export-dynamic -export-symbols extras.exp strcasecmp.lo -lm -lpthread mkdir .libs rm -fr .libs/libodbcextras.la .libs/libodbcextras.* .libs/libodbcextras.* (cd . && ln strcasecmp.lo strcasecmp.o) ln: creating hard link `strcasecmp.o' to `strcasecmp.lo': Input/output error make[1]: *** [libodbcextras.la] Error 1 make[1]: Leaving directory `/mnt/linux/postgres/unixODBC-2.0.11/extras' make: *** [all-recursive] Error 1 [root@spidermonkey unixODBC-2.0.11]# .. D'oh. Some unix guy I am. I was doing this on an special NFS mount... I can't make hard links there. So, I moved the entire kit and kaboodle to /tmp temporarily and sho'nuff, it compiles. 7. Copy the new odbc driver from /usr/local/lib/libodbcpsql.so to /opt/coldfusion/lib/ (backing up the old one before hand) 8: Went to the admin, verified the datasource, worked fine. Some things for ya'll: 1: Loaded cfstudio 5 (I generally don't use cfstudio) and tried view the pgsql datasource before I changed the driver. Worked fine. Dunno what up with other configurations. 2: In cfstudio 5, Tried it again with the new driver, worked fine. ======================== Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] "Information may want to be free, but fiber ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
