i am running apapche 1.3.20 on a UNiX box with php compiled with freetds support fro mssql server. I have a MSSQL 7 server I need it to connect to using the php commands. When I run an sql script with the mssql_connect function I get the following error: Warning: 0 is not a Sybase link index in / blah/file.php line 13 I looked at the error_log and it said Connection refused, login incorrect. Even though the user/pass is correct. Any help would be apreciated. -jamesR this is the configuration I used: (I was unable to complete step 2, cause running this on an OS X box and i dont know where that is here) Installation Procedure ! ======================== (1) > tar -xzvf freetds-xxx.tgz > cd freetds-xxx/ > ./configure --prefix=/usr/local/ftds --with-tdsver=4.2 --enable-dbmfix > make && make install (2) > Edit your /etc/ld.so.conf (or equivalant) add /usr/local/ftds/lib to it > run ldconfig (located in /sbin/ldconfig in linux) (3) GET READY TO HACK!!! > tar -xzvf php-xxx.tar.gz > cd php-xxx/ > edit 'ext/sybase/config.m4', replace 'dbopen' with 'tdsdbopen' (in version 4.0.6 of PHP this in on line 27 of config.m4) > (I am not sure if this step is 100% necessary, but do it anyway!) edit the 'configure' file and look for PHP_SYBASE_DBOPEN, you should see two different versions of this. As follows: #define PHP_SYBASE_DBOPEN tdsdbopen <-- leave this alone #define PHP_SYBASE_DBOPEN dbopen <-- change this to #define PHP_SYBASE_DBOPEN tdsdbopen (4) > ./configure [put other php options here] --with-mssql=/usr/local/ftds --with-sybase=/usr/local/ftds > make && make install > cp php.ini-dist /usr/local/lib/php.ini (the location of this file may differ for your installation) (5) > Now, edit /usr/local/lib/php.ini file, look for 'sybase.interface_file' directive > uncomment it and change the value to /usr/local/ftds/interfaces (location where you installed freeTDS) (6) > Edit /usr/local/ftds/interfaces file, for MSSQL, you have to add an entry like the following*: mssqlconnection query tcp tds4.2 IPADDRESS_OF_SQL_SERVER 1433 * when writing PHP code, use the name "mssqlconnection" for hostname, so you would use something like: $conn = "mssqlconnection"; $username = "myuser"; $password = "mypass"; $dbc = mssql_connect ("$conn", "$username", "$password"); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]