Right,
Thanks to all of you for your research efforts, they give me confidence -
more importantly your quick responses have given the management some
confidence in running with an opensource product.
Regardless, and this is slightly embarrassing but I feel I should be honest
- the issue was due to the supplying of a port number on the server string.
Odd that IIS and PHP on windows had no problem with it but regardless I am
now connected to the MSSQL server - without the use of an odbc connection.
So for future reference, in order to connect to an MSSQL 2008 Express server
via PHP from an Ubuntu-Server 9.10 machine you only require the
'php5-sybase' package combined with the following connection string.
"mssql_connect("192.168.1.15",
"username","passw0rd") or die ("Could not connect to database:
".mssql_get_last_message());"
Do not specify the port number within the mssl_connect server string i.e.
"mssql_connect("192.168.1.15,
1433","username","passw0rd") or die ("Could not connect to database:
".mssql_get_last_message());".
It's also worth noting that I did not have to specify the database instance
i.e. SQLEXPRESS despite what various sources on tha interweb have stated.
Thanks again for your help
Kind Regards,
Jamie.
On Tue, Apr 27, 2010 at 10:25 AM, Jamie McDonald <jm...@iclebyte.com> wrote:
> Right,
>
> Thanks to all of you for your research efforts, they give me confidence -
> more importantly your quick responses have given the management some
> confidence in running with an opensource product.
>
> Regardless, and this is slightly embarrassing but I feel I should be honest
> - the issue was due to the supplying of a port number on the server string.
> Odd that IIS and PHP on windows had no problem with it but regardless I am
> now connected to the MSSQL server - without the use of an odbc connection.
>
> So for future reference, in order to connect to an MSSQL 2008 Express
> server via PHP from an Ubuntu-Server 9.10 machine you only require the
> 'php5-sybase' package combined with the following connection string.
>
> "mssql_connect("192.168.1.15","username","passw0rd") or die ("Could not
> connect to database: ".mssql_get_last_message());"
>
> Do not specify the port number within the mssl_connect server string i.e.
> "mssql_connect("192.168.1.15,
> 1433","username","passw0rd") or die ("Could not connect to database:
> ".mssql_get_last_message());".
>
> It's also worth noting that I did not have to specify the database instance
> i.e. SQLEXPRESS despite what various sources on tha interweb have stated.
>
> Thanks again for your help
> Kind Regards,
> Jamie.
>
>
> On Mon, Apr 26, 2010 at 7:54 PM, Mark Foster <m...@foster.cc> wrote:
>
>> I'm almost positive you ALSO need the sybase client package(s) installed.
>> The php5-sybase is not a pure driver but a hook.
>>
>>
>> On 04/26/2010 08:51 AM, Jamie McDonald wrote:
>>
>> Hello all,
>>
>> I've just managed to convince the management to let us run Linux boxes as
>> our new frontend webservers - they are ubuntu-server 9.10 boxes configured
>> for fail over using heartbeat and DRBD.
>>
>> Our database servers however have remained as Microsoft SQL 2008 servers.
>>
>> The issue I am having is that with the testing of our webserver's I cannot
>> seem to connect to an MS SQL 2008 Express db server, every time I get the
>> error
>>
>> *"Warning*: mssql_connect()
>> [function.mssql-connect<http://192.168.1.61/digyourhome/function.mssql-connect>]:
>> Unable to connect to server: 192.168.1.15,1433 in *
>> /shared/var/www/oursite/inc/oursite_dbcon.php* on line *2*
>> Could not connect to database: "
>>
>> The PHP code used to connect is a standard connection string i.e.
>>
>> "mssql_connect("192.168.1.15,1433","username","passw0rd") or die ("Could
>> not connect to database: ".mssql_get_last_message());"
>>
>> The web server has has 'apt-get install php5-sybase' run on it and apache
>> restarted so the mssql.so object has been loaded - this is also confirmed by
>> its presence on the output from phpinfo();.
>>
>> I have disabled the firewall on the SQL2008 server - and can see the port
>> 1433 listening on the test sql server (my workstation) from the webserver. I
>> am also able to telnet to port 1433 on the SQL server from the webserver.
>> The username and password are also correct - I have quadruple checked this.
>>
>> I've been googling all afternoon and seem to be finding conflicting
>> information regarding the ability of PHP to connect directly to an MSSQL
>> database. Some sites seem to suggest you must use a DSN via an odbc
>> connection but other sites suggest the old school connection string method
>> should work fine just as you would if using mysql. I really don't want to
>> start modfying the developers code, as far as I'm concerned this codebase
>> worked fine under windows/iis so it should run in our new Linux environment.
>>
>> If anyone can give me any clarification on this issue I would be very
>> thankful as these servers are going to be racked this week and I do not want
>> to have the powers that be decide we should revert to Windows Server / IIS.
>>
>> Kind Regards,
>> Jamie.
>>
>>
>>
>> --
>> I hate racists. Mark D. Foster <m...@foster.cc> <m...@foster.cc>
>> http://mark.foster.cc/ | http://www.freegeekseattle.org/
>>
>>
>> --
>> ubuntu-server mailing list
>>
>> ubuntu-server@lists.ubuntu.com
>> https://lists.ubuntu.com/mailman/listinfo/ubuntu-server
>> More info: https://wiki.ubuntu.com/ServerTeam
>>
>
>
--
ubuntu-server mailing list
ubuntu-server@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server
More info: https://wiki.ubuntu.com/ServerTeam
