Re: Re: Re: Re: [PHP-DB] PEAR DB and MSSQL
Frank, thanks so much for your help. Your advice did the trick. Now lets see if I can get this to work on my production server without taking it all down :-) "Frank M. Kromann" <[EMAIL PROTECTED]> wrote on 06/13/2005, 07:43:01 PM: > Hi Robert, > > if you use --with-mssql=/path/to/freetds,shared it will build mssql.so. > This can then be copied to the extension folder and loaded from php.ini. > > Is that help enough? > > - Frank > > > > > Thanks for your help. I'll try building the mssql.so object. Can you > > point me to any documenation on doing this? > > > > Robbert > > > > "Frank M. Kromann" wrote on 06/13/2005, 07:29:59 > > PM: > > > Hi Robbert, > > > > > > I don't think any of the PHP RPM's includes the MSSQL extension, but > you > > > might be able to install the source from the same version and build > the > > > mssql.so shared object and load that from your php.ini file. > > > > > > - Frank > > > > > > > > > > > I am using an RPM version of PHP, would updating the install do the > > > same > > > > thing, or do I have to manually install PHP from source? > > > > > > > > Robbert > > > > > > > > "Frank M. Kromann" wrote on 06/13/2005, 07:08:38 > > > > PM: > > > > > Hi Robbert, > > > > > > > > > > Not sure whey your system stops working after a reboot, but when > you > > > are > > > > > on Linux and using FreeTDS you do not need unixODBC. Just > recompile > > > php > > > > > using the option --with-mssql=/path/to/freetds. You can then use > the > > > > > native mssql functions to connect to the server, and this is also > > > > > supported through PEAR DB. > > > > > > > > > > Just my 2 cents. > > > > > > > > > > - Frank > > > > > > > > > > > > > > > > > My company runs a Linux based PHP website with a MySQL database > > > > > backend. > > > > > > We also have several MSSQL databases deployed throughout the > > > > > > organization. One of our MSSQL databases has a process running > on > > > it > > > > > > that transfers it's data to our MySQL database. However this > > > process > > > > > > has become unstable and the data does not always make it over. > This > > > is > > > > > > mission critical data and must be present on the website to > meet > > > > > > federal and state regulations. > > > > > > > > > > > > Our director has mandated that we get rid of the data transfer > and > > > > > query > > > > > > the MSSQL database directly. I have found several very useful > sites > > > on > > > > > > the net to give me instructiosn on setting this up. I > installed > > > > > > unixODBC and FreeTDS and set up a test server using fedora core > 1. > > > > > > When I first got unixODBC and FreeTDS installed, I was able to > > > connect > > > > > > to the database just fine. However, when I rebooted the server > and > > > > > > tried to connect again PEAR returns a db_error object with a > message > > > of > > > > > > [nativecode=IM002 [unixODBC][Driver Manager]Data source name > not > > > found, > > > > > > and no default driver specified] ** odbc://#:#/@#" > > > {hash > > > > > > marks added to hide username and password and ODBC name}. I > got > > > the > > > > > > message from the output of print_r($db). > > > > > > > > > > > > After the reboot, I was still able to connect to the MSSQL > database > > > > > from > > > > > > the console using isql so this does not appear to be an issue > with > > > > > > unixODBC and FreeTDS. > > > > > > > > > > > > Does anyone have a clue as to why this happened and what I can > do > > > to > > > > > get > > > > > > this working? > > > > > > > > > > > > Thank you, > > > > > > Robbert van Andel > > > > > > > > > > > > -- > > > > > > PHP Database Mailing List (http://www.php.net/) > > > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re: [PHP-DB] PEAR DB and MSSQL
I am using an RPM version of PHP, would updating the install do the same thing, or do I have to manually install PHP from source? Robbert "Frank M. Kromann" <[EMAIL PROTECTED]> wrote on 06/13/2005, 07:08:38 PM: > Hi Robbert, > > Not sure whey your system stops working after a reboot, but when you are > on Linux and using FreeTDS you do not need unixODBC. Just recompile php > using the option --with-mssql=/path/to/freetds. You can then use the > native mssql functions to connect to the server, and this is also > supported through PEAR DB. > > Just my 2 cents. > > - Frank > > > > > My company runs a Linux based PHP website with a MySQL database > backend. > > We also have several MSSQL databases deployed throughout the > > organization. One of our MSSQL databases has a process running on it > > that transfers it's data to our MySQL database. However this process > > has become unstable and the data does not always make it over. This is > > mission critical data and must be present on the website to meet > > federal and state regulations. > > > > Our director has mandated that we get rid of the data transfer and > query > > the MSSQL database directly. I have found several very useful sites on > > the net to give me instructiosn on setting this up. I installed > > unixODBC and FreeTDS and set up a test server using fedora core 1. > > When I first got unixODBC and FreeTDS installed, I was able to connect > > to the database just fine. However, when I rebooted the server and > > tried to connect again PEAR returns a db_error object with a message of > > [nativecode=IM002 [unixODBC][Driver Manager]Data source name not found, > > and no default driver specified] ** odbc://#:#/@#" {hash > > marks added to hide username and password and ODBC name}. I got the > > message from the output of print_r($db). > > > > After the reboot, I was still able to connect to the MSSQL database > from > > the console using isql so this does not appear to be an issue with > > unixODBC and FreeTDS. > > > > Does anyone have a clue as to why this happened and what I can do to > get > > this working? > > > > Thank you, > > Robbert van Andel > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PEAR DB and MSSQL
My company runs a Linux based PHP website with a MySQL database backend. We also have several MSSQL databases deployed throughout the organization. One of our MSSQL databases has a process running on it that transfers it's data to our MySQL database. However this process has become unstable and the data does not always make it over. This is mission critical data and must be present on the website to meet federal and state regulations. Our director has mandated that we get rid of the data transfer and query the MSSQL database directly. I have found several very useful sites on the net to give me instructiosn on setting this up. I installed unixODBC and FreeTDS and set up a test server using fedora core 1. When I first got unixODBC and FreeTDS installed, I was able to connect to the database just fine. However, when I rebooted the server and tried to connect again PEAR returns a db_error object with a message of [nativecode=IM002 [unixODBC][Driver Manager]Data source name not found, and no default driver specified] ** odbc://#:#/@#" {hash marks added to hide username and password and ODBC name}. I got the message from the output of print_r($db). After the reboot, I was still able to connect to the MSSQL database from the console using isql so this does not appear to be an issue with unixODBC and FreeTDS. Does anyone have a clue as to why this happened and what I can do to get this working? Thank you, Robbert van Andel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php