[opensuse] Adding php-mssql shared object to opensuse 10.3 to use freetds
Hi, My name is Jim Taitt, I am running openSUSE 10.3 x86 where I am trying to build a Website which has to connect to a remote Windows 2003 server over the internet and connect to MSSQL Server 2000 to process orders. I have been able to do this using freetds and the php-mssql library which comes packaged in Fadora and RHEL, but my whole system of choice is SUSE. I am a programmer with a little knowledge of linux administration, so please forgive me if my questions are not expertly written. As far as I can see, OpenSuse does not have the php-mssql module as part of their distributions. I have compiled from source freetds and am able to make a test connection to the remote server from SUSE 10.3. The part I need help with is how to compile and add php-mssql to openSuse 10.3 ? If I were to compile php from scratch, I would add the configure flag with-mssql=/usr/local/freetds. It would be easy if I could just compile the module by itself and just add it to my existing setup of SUSE, but dont know what flags to choose for configure. Or better yet, could I get a file with the list of flags to set as they are in the current compilation of php 5.2.5 as they are in the current compilation of SUSE 10.3 , so I can compile my own complete version of PHP and have the confidence it is configured correctly to use in a production environment by using the same flags as used to setup openSuse 10.3. Oh yes, I have never worked with RPMs outside of Yast so I hope what I am asking makes sense in the above context. Thanks to all for any input. I have been working on this for a couple of weeks and am a really concerned that I get it configured correctly . Jim Taitt Tater.tots@verizon.net Huntington Beach, CA. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Jim & Tina Taitt wrote:
Hi,
My name is Jim Taitt, I am running openSUSE 10.3 x86 where I am trying to build a Website which has to connect to a remote Windows 2003 server over the internet and connect to MSSQL Server 2000 to process orders. I have been able to do this using freetds and the php-mssql library which comes packaged in Fadora and RHEL, but my whole system of choice is SUSE. I am a programmer with a “little” knowledge of linux administration, so please forgive me if my questions are not expertly written.
As far as I can see, OpenSuse does not have the php-mssql module as part of their distributions. I have compiled from source freetds and am able to make a test connection to the remote server from SUSE 10.3. The part I need help with is how to compile and add php-mssql to openSuse 10.3 ? If I were to compile php from scratch, I would add the configure flag –with-mssql=/usr/local/freetds.
It would be easy if I could just compile the module by itself and just add it to my existing setup of SUSE, but don’t know what flags to choose for configure.
Or better yet, could I get a file with the list of flags to set as they are in the current compilation of php 5.2.5 as they are in the current compilation of SUSE 10.3 , so I can compile my own complete version of PHP and have the confidence it is configured correctly to use in a production environment by using the same flags as used to setup openSuse 10.3.
Oh yes, I have never worked with RPM’s outside of Yast so I hope what I am asking makes sense in the above context.
Thanks to all for any input. I have been working on this for a couple of weeks and am a really concerned that I get it configured correctly….
Jim Taitt Tater.tots@verizon.net Huntington Beach, CA.
While this is not exactly what you asked for, we use php to connect to MS SQL Servers on OpenSuse 10.3 via unixODBC. PHP uses ODBC through unixODBC, unixODBC then uses the FreeTDS ODBC drivers to connect to SQL. Works like a charm. -- --Moby They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. -- Benjamin Franklin -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Moby wrote:
While this is not exactly what you asked for, we use php to connect to MS SQL Servers on OpenSuse 10.3 via unixODBC.
PHP uses ODBC through unixODBC, unixODBC then uses the FreeTDS ODBC drivers to connect to SQL. Works like a charm.
That's interesting - we didn't have any luck with that, couldn't ever get the freetds drivers to connect successfully to the pc sql server and ended up going with the easysoft odbc drivers, which worked like a charm out of the box. Does the pc sql server have to be operated in some sort of compatibility mode or something, to allow interoperability with the freetds drivers? I'm curious if we might have missed something. Joe -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Sloan wrote:
Moby wrote:
While this is not exactly what you asked for, we use php to connect to MS SQL Servers on OpenSuse 10.3 via unixODBC.
PHP uses ODBC through unixODBC, unixODBC then uses the FreeTDS ODBC drivers to connect to SQL. Works like a charm.
That's interesting - we didn't have any luck with that, couldn't ever get the freetds drivers to connect successfully to the pc sql server and ended up going with the easysoft odbc drivers, which worked like a charm out of the box.
Does the pc sql server have to be operated in some sort of compatibility mode or something, to allow interoperability with the freetds drivers? I'm curious if we might have missed something.
Joe
No - we are using freetds-unixodbc version 0.63-1 - works like a charm out of the box. It's odbc driver is libtdsodbc.so and we are connecting to SQL Server 2000 and 2005 without any issues. -- --Moby They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. -- Benjamin Franklin -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (3)
-
Jim & Tina Taitt -
Moby -
Sloan