Re: Re: PEAR DB and MSSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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" <frank@xxxxxxxxxxxx> 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux