Page 1 of 1

Load sqlsrv

PostPosted: December 2nd, 2014, 8:49 pm
by o.strubl
Hello,
i migrate php web application to win server with phalanger and mssql DB.
I need load sqlsrv driver (http://www.microsoft.com/en-us/download ... x?id=20098) to web application, its possible do this with modification of web.config ?
Somthing like
Code: Select all
<add assembly="php_sqlsrv_54_nts.dll, Version=3.0.0.0, Culture=neutral, PublicKeyToken=2771987119c16a03" section="mssql-native"/>


I cant use php mssql because I need windows authentication to connect to DB.

Thanks for your reply

Re: Load sqlsrv

PostPosted: December 2nd, 2014, 9:40 pm
by Jakub Misek
Hi,

You can't add references to native DLLs (those ones compiled for legacy PHP).

There is MSSQL extension for Phalanger
Code: Select all
<add assembly="PhpNetMsSql, Version=4.0.0.0, Culture=neutral, PublicKeyToken=2771987119c16a03" />

Re: Load sqlsrv

PostPosted: December 2nd, 2014, 9:51 pm
by o.strubl
Thanks for reply,
but i cant use PhpNetMsSql because it doesnt support sqldrv_connection function. I realy need it, because of it supports windows authentication (connect to DB)
Its possible compile it? From source, from example?

https://sqlsrvphp.codeplex.com/SourceControl/latest

Thanks

Re: Load sqlsrv

PostPosted: December 2nd, 2014, 10:30 pm
by Jakub Misek
PhpNetMsSql is built on .NET SqlConnection (http://msdn.microsoft.com/en-us/library ... n(v=vs.100).aspx) which supports it as well.

Phalanger supports only .NET components.