MSSQL 2008 CONNECTION

Applications Database Connections
#1

The scriptcase can connect in mssql 2008.

But the tutorial is old, and show only 2005.

To create the connection, i recommend use NATIVE SRV DRIVE.

Not use the drive with 1.1 version, only 1.0

I send in attached the drive installation.

Required:

Operational System:

  • Windows Server 2003 Service Pack 1

  • Windows XP Service Pack 2

  • Windows Vista

  • Windows Server 2008

  • Need install the Microsoft SQL Server Native Client - sqlncli

http://go.microsoft.com/fwlink/?LinkId=101877

Need get the Driver - SQLServerDriverForPHP

http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx

Install in to extension php folder (ext) and enable this dll in php.ini file:

extension=php_sqlsrv_ts.dll

#2

Re: MSSQL 2008 CONNECTION

The files that you need to install the NATIVE SRV

http://www.4shared.com/file/184158589/95f20f88/install.html
http://www.4shared.com/file/184158148/4949d8ce/SQLServerDriverForPHP.html

#3

Re: MSSQL 2008 CONNECTION

HI!

After succesfully use scriptcase on mysql and firebird now i try to use on mssql 2008 server
i have done all suggestion but the connection respond always that sqlsrv must be activated on php.ini

extension=php_mbstring.dll
extension=php_gd2.dll
extension=php_mysql.dll
extension=php_pdo_mysql.dll
extension=php_sockets.dll
extension=php_pgsql.dll
extension=php_pdo.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll
extension=php_zip.dll
extension=php_interbase.dll
extension=php_pdo_firebird.dll
extension=php_pdo_mssql.dll
extension=php_mssql.dll
extention=php_sqlsrv_ts.dll
extention=php_pdo_sqlsrv_ts.dll

can you help me ’

best regards
vincenzo di pietri

#4

Re: MSSQL 2008 CONNECTION

Following your detailed instructions don’t seems to solve the problem and reading the forum it’s clear this is a common problem also for others.
I purchased the upgrade to enterprise version just to have a connection with sqlserver but it seems there are many problems… are you really sure that this functionality is “running and reliable?”
How can i do to make this running?

Already tried with Sql Server 2005/2008 and PHP drivers 1.0, 1.1 and 2.0 but nothing is changed.

I’m using SC 5.2 ( Vista 64bit )

Thanks to anyone who wants to help me suggesting what i’m wrong…

Giorgio.

#5

Re: MSSQL 2008 CONNECTION

Giorgio did you see this link: http://www.scriptcase.net/phpgenerator/baseknowledge/baseknowledge.php?id_topico=303