Load sqlsrv

Discussion about the open-source Phalanger [?] project.

Load sqlsrv

Postby o.strubl » December 2nd, 2014, 8:49 pm

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
o.strubl
 
Posts: 2
Joined: December 2nd, 2014, 7:58 pm

Re: Load sqlsrv

Postby Jakub Misek » December 2nd, 2014, 9:40 pm

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" />
Jakub Misek │ DEVSENSE s.r.o. | @misekjakubjakub@devsense.com
User avatar
Jakub Misek
 
Posts: 2092
Joined: January 4th, 2012, 2:42 pm
Location: Prague

Re: Load sqlsrv

Postby o.strubl » December 2nd, 2014, 9:51 pm

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
o.strubl
 
Posts: 2
Joined: December 2nd, 2014, 7:58 pm

Re: Load sqlsrv

Postby Jakub Misek » December 2nd, 2014, 10:30 pm

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.
Jakub Misek │ DEVSENSE s.r.o. | @misekjakubjakub@devsense.com
User avatar
Jakub Misek
 
Posts: 2092
Joined: January 4th, 2012, 2:42 pm
Location: Prague


Return to Phalanger project

Who is online

Users browsing this forum: No registered users and 23 guests

cron

User Control Panel

Login

Who is online

In total there are 23 users online :: 0 registered, 0 hidden and 23 guests (based on users active over the past 5 minutes)
Most users ever online was 256 on March 28th, 2024, 9:42 am

Users browsing this forum: No registered users and 23 guests