[freetds] connecting MSSQL Server from linux+php
Lowden, James K
LowdenJK at bernstein.com
Wed Jul 2 14:35:15 EDT 2003
> From: Venkatraman M Srinivasan [mailto:mlmsrini at lycos.com]
> Sent: July 2, 2003 11:12 AM
>
> ./configure --with-tdsver=7.0 --enable-msdblib
This will install /usr/local/etc/freetds.conf.
> then compiled PHP with
> ./configure --with-apache=../apache_1.3.12
> --with-mysql=/usr/local/mysql --with-mssql=/usr/local/freetds
...
> I edited the freetds.conf file from usr/local/freetds and did this
Do you mean /usr/local/etc/freetds.conf or /usr/local/freetds/freetds.conf?
> [MyServer70]
> host = 192.168.4.45 // MSSQL Server IP address
^^^^^^^^^^^^
Normally we recommend you use the server's DNS name, but this will work.
> After that i 've tested for the MSSQL server connectivity
> with a sample php code.
> <?
> // connectivity testing
> putenv("TDSVER=70");
^^^^^^^^^
Not needed, because you configured "--with-tdsver=7.0", but OK.
> Fatal error: Call to undefined function: mssql_connect() in
> /home/httpd/test/test.php on line 4
I don't have any advice for you here. Based on the text of the message, it
looks like the PHP mssql extension isn't really compiled in.
--jkl
-----------------------------------------
The information contained in this transmission may contain privileged and confidential information and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions.
More information about the FreeTDS
mailing list