SQL Sever

[NZ_Kiwis]

can someone tell me if it's possible to connect PHP to a SQL server????

If so how?

[dagon]

which SQL server?

[NZ_Kiwis]

dagon;10985622 wrote:

which SQL server?

Microsoft SQL Server 2008

[Derokorian]

Yes php can work with MS-SQL see http://php.net/manual/en/book.mssql.php for all related info.

[NZ_Kiwis]

Does that work in 5.3.1?
I thought someone i read it does not work in anything higher the 5.0?

What would be the typical port number for MS Server?

[NZ_Kiwis]

at the end of my connection i have a

echo "Hello";

I can't see this and I know errors are turned off, how can I see what the error might be?

[NZ_Kiwis]

Is my issue because my username and password only works for one database on the server yet i'm not saying which database until later in the code?

[bradgrafelman]

NZ_Kiwis;10985629 wrote:

Does that work in 5.3.1?

Nope; from the requirements page ([man]mssql.requirements[/man]):

PHP Manual wrote:

This extension is not available anymore on Windows with PHP 5.3 or later.

NZ_Kiwis;10985629 wrote:

I thought someone i read it does not work in anything higher the 5.0?

Not quite - see above.

NZ_Kiwis;10985629 wrote:

What would be the typical port number for MS Server?

http://www.google.com/search?q=mssql+default+port+number

NZ_Kiwis;10985630 wrote:

at the end of my connection i have a

echo "Hello";

I can't see this and I know errors are turned off, how can I see what the error might be?

Turn errors on.

NZ_Kiwis;10985631 wrote:

Is my issue because my username and password only works for one database on the server yet i'm not saying which database until later in the code?

Who knows? It's possible. Rather than guess as to what the error is, it'd be much easier to just enable error reporting and let PHP tell you what the error is.

EDIT: For example, if a simple echo statement isn't being displayed, PHP might be trying to tell you that you've got a parse error and that in fact none of your code was ever executed at all. Or it could be some 'Fatal Error' (such as the use of an undefined function).

[Derokorian]

Also for PHP 5.3+ its possible to use the SQLSRV extension if installed, available on windows. This is linked to directly from the Manual pages I linked before.

[NZ_Kiwis]

I can't edit the server or ini settings in any way

I guess it can't be done this way either... is there any other way?

$serverName = "XXX\XXX"; //serverName\instanceName
$connectionInfo = array( "Database"=>"XXX", "UID"=>"XXX", "PWD"=>"XXX");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     echo print_r(sqlsrv_errors());
}

Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49

 => -49 [2] => The SQL Server Driver for PHP requires the SQL Server 2008 Native Client ODBC Driver (SP1 or later) to communicate with SQL Server. That ODBC Driver is not currently installed. Access the following URL to download the SQL Server 2008 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => The SQL Server Driver for PHP requires the SQL Server 2008 Native Client ODBC Driver (SP1 or later) to communicate with SQL Server. That ODBC Driver is not currently installed. Access the following URL to download the SQL Server 2008 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) ) 1 [/QUOTE]

[bradgrafelman]

Is [man]PDO[/man] and the [man]PDO-SQLSRV[/man] driver installed?

NZ_Kiwis;10985635 wrote:

is there any other way?

Yup; ditch whatever host you're currently using and find one that actually suits your needs instead.

[NZ_Kiwis]

bradgrafelman;10985636 wrote:

Is [man]PDO[/man] and the [man]PDO-SQLSRV[/man] driver installed?

Can I tell this via phpinfo(); ???

bradgrafelman;10985636 wrote:

Yup; ditch whatever host you're currently using and find one that actually suits your needs instead.

I can't it's an internal corperate server.

[johanafm]

NZ_Kiwis;10985643 wrote:

Can I tell this via phpinfo(); ???

Yes. Everything regarding your php install is reported by phpinfo, even the compile options, such as --enable-pdo.

NZ_Kiwis;10985643 wrote:

I can't it's an internal corperate server.

Well, then they can enable ms sql drivers for your php install if they want you to be able to communicate with the database through php.

[bradgrafelman]

johanafm;10985658 wrote:

Well, then they can enable ms sql drivers for your php install if they want you to be able to communicate with the database through php.

I agree; have you tried contacting the IT department and/or whoever manages the webserver, explained the lack of software needed, pointed them to the relevant PHP manual page, and requested that the necessary software be installed?

[NZ_Kiwis]

Thanks guys, I've not yet tried no. Sorry I'm a little new to this side of PHP

What am I looking for in the phpinfo?

What if it's not there what needs to be installed?