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