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
