You are viewing a plain text version of this content. The canonical link for it is here.
Posted to stonehenge-dev@incubator.apache.org by Ben Dewey <Be...@26ny.com> on 2009/04/20 20:18:53 UTC
SQL Express db config for PHP
I was able to get the PHP version of ST up and running using the WAMP Server.
I had some trouble getting the server connection working with my version of MS SQL Express 2008 which uses a named instance of \SQLExpress.
<server>127.0.0.1,1433</server> # default
<server>127.0.0.1\SQLExpress,1433</server> # timeout
<server>127.0.0.1:1433\SQLExpress</server> # timeout
<server>localhost\SQLExpress,1433</server> # timeout
<server>localhost:1433\SQLExpress</server> # timeout
<server>localhost\SQLExpress</server> # success
It might be helpful to add a note to the PHP Install Document, under the Installing PHP -> Options Headings (1-5, 2-4, 3-2) for setting the database server if you have an instance of SQL Express installed.
Ben Dewey
RE: SQL Express db config for PHP
Posted by Ben Dewey <Be...@26ny.com>.
Shankar,
Thanks for your response. I did some testing an determined that TCP/IP was enabled, I guess I just assumed that the instance name was required, and never tested that.
This is working now. It seems that the port number is assigned to each individual instance name, and in my setup 1433 port pointed to the SQLExpress instance.
I'll close the other JIRA Ticket for WSAS.
-----Original Message-----
From: Selvaratnam Uthaiyashankar [mailto:uthaiyashankar@gmail.com]
Sent: Monday, April 20, 2009 11:50 PM
To: stonehenge-dev@incubator.apache.org
Subject: Re: SQL Express db config for PHP
hi,
<server>127.0.0.1,1433</server>
this should work for express version as well. can you check whether mssql
express is listening on that port?
regards,
shankar
On Tue, Apr 21, 2009 at 1:48 AM, Ben Dewey <Be...@26ny.com> wrote:
> I was able to get the PHP version of ST up and running using the WAMP
> Server.
>
> I had some trouble getting the server connection working with my version of
> MS SQL Express 2008 which uses a named instance of \SQLExpress.
>
> <server>127.0.0.1,1433</server> # default
>
> <server>127.0.0.1\SQLExpress,1433</server> # timeout
> <server>127.0.0.1:1433\SQLExpress</server> # timeout
> <server>localhost\SQLExpress,1433</server> # timeout
> <server>localhost:1433\SQLExpress</server> # timeout
>
> <server>localhost\SQLExpress</server> # success
>
> It might be helpful to add a note to the PHP Install Document, under the
> Installing PHP -> Options Headings (1-5, 2-4, 3-2) for setting the database
> server if you have an instance of SQL Express installed.
>
> Ben Dewey
>
>
>
--
S.Uthaiyashankar
Software Architect
WSO2 Inc.
http://wso2.com/ - "The Open Source SOA Company"
Re: SQL Express db config for PHP
Posted by Selvaratnam Uthaiyashankar <ut...@gmail.com>.
hi,
<server>127.0.0.1,1433</server>
this should work for express version as well. can you check whether mssql
express is listening on that port?
regards,
shankar
On Tue, Apr 21, 2009 at 1:48 AM, Ben Dewey <Be...@26ny.com> wrote:
> I was able to get the PHP version of ST up and running using the WAMP
> Server.
>
> I had some trouble getting the server connection working with my version of
> MS SQL Express 2008 which uses a named instance of \SQLExpress.
>
> <server>127.0.0.1,1433</server> # default
>
> <server>127.0.0.1\SQLExpress,1433</server> # timeout
> <server>127.0.0.1:1433\SQLExpress</server> # timeout
> <server>localhost\SQLExpress,1433</server> # timeout
> <server>localhost:1433\SQLExpress</server> # timeout
>
> <server>localhost\SQLExpress</server> # success
>
> It might be helpful to add a note to the PHP Install Document, under the
> Installing PHP -> Options Headings (1-5, 2-4, 3-2) for setting the database
> server if you have an instance of SQL Express installed.
>
> Ben Dewey
>
>
>
--
S.Uthaiyashankar
Software Architect
WSO2 Inc.
http://wso2.com/ - "The Open Source SOA Company"