[freetds] Re: Cannot Connect
fdsubs at axelero.hu
Thu May 13 17:33:21 EDT 2004
On May 13, 2004, at 23:03, rconner at commspeed.net wrote:
> able to connect to a mssql server.
[... php configure line ...]
> './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql'
> php.ini (well the part i think i need)
> ; Dynamic Extensions ;
MSQL has absolutely nothing to do with FreeTDS or MSSQL. You probably
never even heard of that database.
Second, you have to make up your mind on which PHP extension you wish
to use, the native choices being sybase, sybase_ct and mssql; plus
whether you want them built-in to your PHP binary or loaded as a
According to your email, you've chosen to compile in the sybase
extension statically. In this case, it doesn't have to be loaded via
php.ini or by any other means -- it's built-in and active all the time.
So the lines you uncommented in your php.ini are only causing error
messages referencing non-existent files. You can build the shared
module by specifying the shared option to PHP's configure script, for
This would build you the mssql.so you wanted.
> host = NQLSQL01
> port = 1433
> tds version = 7.0
> $myServer = "servername";
> $mssql_Username = "user";
> $mssql_Password = "secret";
> $mssql_DBName = "AMATS";
> // create mysql connection
> $new_Connect = @mssql_connect($myServer, $mssql_Username,
1. Make sure that NQLSQL01 is not [only] a NetBIOS name but a valid DNS
Check that you can:
on the Linux machine's console.
If not, you'll have to edit your name server's configuration or simply
enter the numerical IP address.
2. change the $myServer line so it is set to the same name you put
between the square brackets in freetds.conf:
$myServer = "myServer";
More information about the FreeTDS