Re: MSsql madness

please remove me from this list On Fri, Jun 24, 2011 at 3:02 PM, Troy Oltmanns <toltmanns@gmail.com> wrote: > Hey php-dbers, > > I have a helper script that connects to an MSsql database to select > retailer > location information, which is then processed into mysql statements to be > inserted into another remote database (this one MYsql). > > Currently it is ran manually from a windows system that was preconfigured > (prior to my arrival). It's my task to get it integrated into a linux > installation so that it can be set up under crontab to execute daily. > > My issue is that in testing (I am running MAMP on mac 10.6.7) the mssql > functions are not available out of the box. Since I am not a formal > programmer, this is compounded by the fact that the process to configure > build and install is completely foreign to me. I followed some instruction > ( > http://www.tumblr.com/tagged/mssql+mamp+php+mac+osx) to > download freetds > and > I tried to run the first command (./configure > --prefix=/Applications/MAMP/Library --with-tdsver=8.0 > --sysconfdir=/Applications/MAMP/conf/freetds) with my appropriate > information, and I am given this error: "configure: error: no acceptable C > compiler found in $PATH See `config.log' for more details." > > In doing more research, many say that gcc should be already installed on my > mac, but it's not. Other posts say you can get it in xcode, but Apple now > forces you to pay $100 to get apple dev tools... yeah right! I found GCC at > *gcc*.gnu.org, but when trying to run (../gcc-4.6.0/configure) it runs > into > another issue "checking for cl.exe... no > configure: error: in `/Users/toltmanns/Downloads/gcc': > configure: error: no acceptable C compiler found in $PATH > See `config.log' for more details. > " > > Tell me, how in the world are you suppose to compile a c compiler when you > dont have one yet? > > Any direction would be helpful. > > Are there alternative ways to interact with MSsql? > > Thanks, > Troy Oltmanns >