[freetds] Re: Cannot Connect

Daniel Fazekas 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'
> '--with-sybase=/usr/local/freetds'
>
> php.ini (well the part i think i need)
> ; Dynamic Extensions ;
>    extension=msql.so
>    extension=mssql.so
>

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 
dynamic extension.

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 
example:

--with-mssql=shared,/usr/local

This would build you the mssql.so you wanted.

[...]
> [myServer]
>         host = NQLSQL01
>         port = 1433
>         tds version = 7.0
[...]
> <?php
>
> $myServer = "servername";
> $mssql_Username = "user";
> $mssql_Password = "secret";
> $mssql_DBName = "AMATS";
>
> // create mysql connection
> $new_Connect = @mssql_connect($myServer, $mssql_Username, 
> $mssql_Password)

1. Make sure that NQLSQL01 is not [only] a NetBIOS name but a valid DNS 
host name.

Check that you can:

host NQLSQL01

or

ping NQLSQL01

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";


--
fds




More information about the FreeTDS mailing list