Hi
With PHP 4.3.0 you can use --with-mssql (it looks for freetds in
/usr/local/freetds by default). Then you can use the mssql.* settings in
php.ini. When you compile using --with-sybase you would have to use the
sybase.* settings in php.ini, as that is the extension you would be
using.
You should not use ip:port as your host name. Port 1433 is the default for
both MSSQL and FreeTds. If you use any other port number you should
specify this in freetds.conf.
- Frank
> Hi there,
>
> Hope someone can help me with this.
> I need to connect to a MS SQL database but my attemps fail once and
again.
> This is the error message I get when try to connect:
>
> Fatal error: Call to undefined function: mssql_connect() in
> /var/www/htdocs/DB_conn.php on line 8
>
> The script is very simple:
>
> <?php
>
> $hostname = "10.0.0.206:1433";
> $username = "sa";
> $password = "";
> $dbName = "dbname_here";
>
> $idLink = mssql_connect($hostname,$username,$password) or die("DATABASE
> FAILED TO RESPOND.");
> mssql_select_db($dbName) or die("Table unavailable");
>
> ?>
>
> Now, this is the info I can provide:
>
> 1) PHP version 4.3.0-dev
>
> 2) phpinfo shows:
> './configure'
> '--prefix=/usr/local'
> '--enable-module=so'
> '--with-mod_charset'
> '--enable-sockets'
> '--enable-memory-limit'
> '--with-sybase=/usr/local/freetds'
>
> 3) Of course, freetds is located at /usr/local/freetds and works
properly.
> It was tested using tsql -H -p -U and it's ok.
>
> 4) I also tried adding #!/usr/local/bin/php to try it as a shell
scripting
> thing and it WORKS! Which is very confusing.
>
> 5) php.ini shows:
>
> [MSSQL]
> ; Allow or prevent persistent links.
> mssql.allow_persistent = On
>
> ; Maximum number of persistent links. -1 means no limit.
> mssql.max_persistent = -1
>
> ; Maximum number of links (persistent+non persistent). -1 means no
limit.
> mssql.max_links = -1
>
> ; Minimum error severity to display.
> mssql.min_error_severity = 10
>
> ; Minimum message severity to display.
> mssql.min_message_severity = 10
>
> ; Compatability mode with old versions of PHP 3.0.
> mssql.compatability_mode = Off
>
> ; Valid range 0 - 2147483647. Default = 4096.
> ;mssql.textlimit = 4096
>
> ; Valid range 0 - 2147483647. Default = 4096.
> ;mssql.textsize = 4096
>
> ; Limits the number of records in each batch. 0 = all records in one
batch.
> ;mssql.batchsize = 0
>
> ; Use NT authentication when connecting to the server
> mssql.secure_connection = Off
>
> ; Specify max number of processes. Default = 25
> ;mssql.max_procs = 25
>
> I have no idea what the problem is; any help will be much appreciated.
>
> -Paula
>
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
