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
