Hi, I've installed and configured freetds with odbc and added -with-mssql, linked the lib64 dir and confirmed the config with
[email protected] [/usr/local/cpanel/scripts]# php -i | grep mssql
mssql
mssql.allow_persistent => On => On
mssql.batchsize => 0 => 0
mssql.charset => no value => no value
mssql.compatability_mode => Off => Off
mssql.connect_timeout => 5 => 5
mssql.datetimeconvert => On => On
mssql.max_links => Unlimited => Unlimited
mssql.max_persistent => Unlimited => Unlimited
mssql.max_procs => Unlimited => Unlimited
mssql.min_error_severity => 10 => 10
mssql.min_message_severity => 10 => 10
mssql.secure_connection => Off => Off
mssql.textlimit => Server default => Server default
mssql.textsize => Server default => Server default
mssql.timeout => 60 => 60
it also shows correct in a info.php file.
I've checked the db connections with the php connection file and they are all correct but when trying to load the page that's calling info from the SQL db I get connection errors:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: x.x.x.x in /home/keyzotes/public_html/Connections/adodb5/drivers/adodb-mssql.inc.php on line 614
it shows this error for all the data fed content, just the line numbers vary.
I can telnet to the db on 1433 no problem, I can also connect successfully using tdserver=7.0 tsql -H x.x.x.x -p 1433 -U sa
I'm out of ideas, can anyone help suggest anything to check?
Thanks - Simon
[email protected] [/usr/local/cpanel/scripts]# php -i | grep mssql
mssql
mssql.allow_persistent => On => On
mssql.batchsize => 0 => 0
mssql.charset => no value => no value
mssql.compatability_mode => Off => Off
mssql.connect_timeout => 5 => 5
mssql.datetimeconvert => On => On
mssql.max_links => Unlimited => Unlimited
mssql.max_persistent => Unlimited => Unlimited
mssql.max_procs => Unlimited => Unlimited
mssql.min_error_severity => 10 => 10
mssql.min_message_severity => 10 => 10
mssql.secure_connection => Off => Off
mssql.textlimit => Server default => Server default
mssql.textsize => Server default => Server default
mssql.timeout => 60 => 60
it also shows correct in a info.php file.
I've checked the db connections with the php connection file and they are all correct but when trying to load the page that's calling info from the SQL db I get connection errors:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: x.x.x.x in /home/keyzotes/public_html/Connections/adodb5/drivers/adodb-mssql.inc.php on line 614
it shows this error for all the data fed content, just the line numbers vary.
I can telnet to the db on 1433 no problem, I can also connect successfully using tdserver=7.0 tsql -H x.x.x.x -p 1433 -U sa
I'm out of ideas, can anyone help suggest anything to check?
Thanks - Simon