I originally posted this to the general discussion but wanted to see if anyone on this list had an idea. The issue is trying to connect to the MSSQL with PHP from a linux box (Fedora Core 4 in this instance) > An interesting development. I found some reference to running my PHP > script from the command line to take Apache out of the picture. Lo and > behold, the script worked. I was able to connect to the server. So the > issue seems to be related with Apache. Any idea what I would need to do > there to make the script work via the web? > > Robbert > > php@xxxxxxxxxxxx wrote on 11/02/2005, 05:50:01 PM: > > > > Thanks for your help. I'd love to hear if you have any success with the > > RPMs. Something I've seen over and over again in the documentation is > > the compilation of php adding "--with-mssql". My PHP info output does > > not include that marker. > > > > The output is as follows > > './configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux' > > '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' > > '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' > > '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' > > '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' > > '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' > > '--infodir=/usr/share/info' '--cache-file=../config.cache' > > '--with-libdir=lib' '--with-config-file-path=/etc' > > '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' > > '--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' > > '--with-freetype-dir=/usr' '--with-png-dir=/usr' > > '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' > > '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' > > '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' > > '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' > > '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' > > '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' > > '--enable-trans-sid' '--enable-yp' '--enable-wddx' > > '--with-pear=/usr/share/pear' '--with-kerberos' > > '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' > > '--enable-memory-limit' '--enable-shmop' '--enable-calendar' > > '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic' > > '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' > > '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' > > '--without-odbc' '--disable-dom' '--disable-dba' > > > > Howver, under additional .ini files parsed, I see the mssql file: > > /etc/php.d/ldap.ini, /etc/php.d/mssql.ini, /etc/php.d/mysql.ini, > > /etc/php.d/mysqli.ini, /etc/php.d/odbc.ini > > > > And further on down are the mssql configuration settings. > > Rick Emery wrote on 11/02/2005, 05:19:06 PM: > > > Quoting php@xxxxxxxxxxxx: > > > > > > > > > > > Yup, I thought that was the problem too but when I added my server to > > > > the conf file, there was no change. When you set up your MSSQL > > > > connection in fedora, did you install anything else other than MSSQL > > > > and PHP-MSSQL? Or did you have to set anything in your php.ini file to > > > > use the new extension? > > > > > > Well, I didn't have the rpms; I compiled from source. I don't have that > > > box available anymore, but I've checked my notes. First, I compiled > > > freetds (nothing special in the configure line), then I compiled php > > > using "--with-mssql=/usr" (to point to the freetds libraries). All of > > > this should have been handled within the rpms, though, and if phpinfo > > > is showing the mssql extension loaded, I'm not sure why it wouldn't be > > > working. I don't remember modifying php.ini at all for the mssql stuff. > > > > > > Hopefully over the next couple of days I'll have some time to set up a > > > test box and try the rpms to which you pointed me, to see if I run into > > > the same trouble. > > > > > > Rick > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General 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
