Skip to Content.
Sympa Menu

freetds - Re: [freetds] Re: Cannot Connect thanks "fds"

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: rconner AT commspeed.net
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Re: Cannot Connect thanks "fds"
  • Date: Fri, 14 May 2004 10:27:05 -0700 (MST)

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
>





Archive powered by MHonArc 2.6.24.

Top of Page