Skip to Content.
Sympa Menu

freetds - [freetds] Re: Cannot Connect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Daniel Fazekas <fdsubs AT axelero.hu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Re: Cannot Connect
  • Date: Thu, 13 May 2004 23:33:21 +0200


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





Archive powered by MHonArc 2.6.24.

Top of Page