MSsql madness

--20cf307c9c42bb197904a67aad10
Content-Type: text/plain; charset=ISO-8859-1

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

--20cf307c9c42bb197904a67aad10--

Re: MSsql madness

--000325554c7e9faa1a04a67ac023
Content-Type: text/plain; charset=ISO-8859-1

please remove me from this list

On Fri, Jun 24, 2011 at 3:02 PM, Troy Oltmanns 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
>

--000325554c7e9faa1a04a67ac023--

Re: MSsql madness

On Fri, Jun 24, 2011 at 16:07, Paul Wilson wrote:
> please remove me from this list

Email php-db-unsubscribe@lists.php.net.

--

Network Infrastructure Manager
http://www.php.net/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php