[freetds] Re: Cannot Connect thanks "fds"

rconner at commspeed.net rconner at commspeed.net
Fri May 14 13:27:05 EDT 2004


Thanks for clearing a few things up makes alot more sense now.  As for the
resolution your right the settings in
/ect/sysconfig/network-scripts/ifc-eth0 work alot better with
GATEWAY="ipaddress"  then with GATEWAY-"ipaddress".

Thanks for your time,

Conner

>
> 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
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




More information about the FreeTDS mailing list