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
