1

Topic: Connection error to basis

Hello.
On the server 2008 there is an apache 2.2, php 5.3 innersrv and ms sql 2008.
At attempt to come on a site writes an error
Fatal error: Uncaught exception ' com_exception ' with message ' Source: ADODB.Connection Description: the specified supplier is not possible to find. Possibly, it is installed incorrectly. ' in C:\wwwroot\www_php\cfg.php:34 Stack trace: #0 C:\wwwroot\www_php\cfg.php (34): com-> Open (' Provider=SQLNCL... ') #1 C:\wwwroot\www_php\cfg.php (42): ConnectMSSQL-> __ construct () #2 C:\wwwroot\www_php\index.php (25): include_once (' C:\wwwroot\www_... ') #3 {main} thrown in C:\wwwroot\www_php\cfg.php on line 34
In what there can be a business where to dig?
On similar errors in Google search suggest to check up a line of connection about instructions .
But at me one , . MSSQLSERVER.

2

Re: Connection error to basis

x64?

3

Re: Connection error to basis

vdvas wrote:

Hello.
On the server 2008 there is an apache 2.2, php 5.3 innersrv and ms sql 2008.
At attempt to come on a site writes an error
Fatal error: Uncaught exception ' com_exception ' with message ' Source: ADODB.Connection Description: the specified supplier is not possible to find. Possibly, it is installed incorrectly. ' in C:\wwwroot\www_php\cfg.php:34 Stack trace: #0 C:\wwwroot\www_php\cfg.php (34): com-> Open (' Provider=SQLNCL... ') #1 C:\wwwroot\www_php\cfg.php (42): ConnectMSSQL-> __ construct () #2 C:\wwwroot\www_php\index.php (25): include_once (' C:\wwwroot\www_... ') #3 {main} thrown in C:\wwwroot\www_php\cfg.php on line 34
In what there can be a business where to dig?
On similar errors in Google search suggest to check up a line of connection about instructions .
But at me one , . MSSQLSERVER.

Use 32-bit application, and the driver are installed 64-bit, or on the contrary.
, or download the normal version of drivers, PHP and drivers sqlserver 3.1 suitable versions.

4

Re: Connection error to basis

Windows Server 2008 R2 std x64
MS A SQL Server 2008 ent x64
PHP copied from other server.
There already there was a driver file, do not know what version x32 or x64.
In php.ini line
extension=php_sqlsrv_53_ts.dll
What it is necessary to download and install?
php mssql driver x64?
ODBC driver it is necessary? What version?

5

Re: Connection error to basis

vdvas wrote:

Windows Server 2008 R2 std x64
MS A SQL Server 2008 ent x64
PHP copied from other server.
There already there was a driver file, do not know what version x32 or x64.
In php.ini line
extension=php_sqlsrv_53_ts.dll
What it is necessary to download and install?
php mssql driver x64?
ODBC driver it is necessary? What version?

Well here, perfectly.
The server x64, and PHP x86 - here they also are not on friendly terms.
Swing from site Miscrosoft the 32-bit driver for your version MS SQL, and put it in a silent mode (it is necessary to google a command).
After setting - to reboot and all should earn.

6

Re: Connection error to basis

7

Re: Connection error to basis

And why in a silent mode it is necessary to put?  system?

8

Re: Connection error to basis

vdvas wrote:

and why in a silent mode it is necessary to put?  system?

It is supported, but the fitter considers that it is cleverer than the user, and does not allow to install the second driver if already there is one, suggesting to take down before the unnecessary leaking.

9

Re: Connection error to basis

sqlncli x32 at setting writes it is not supported by system.
Through msiexec too most only writes in the event log.
Tried pache 2.4 x64 and php5.6 x64 - not  dll.
Though swung 64 bit versions dll.
In broad gulls of the apache - unable to load.

10

Re: Connection error to basis

Piece of an output of a command
"C:\PHP56\php.exe"-i | more
PDO
PDO support => enabled
PDO drivers => sqlsrv
pdo_sqlsrv
pdo_sqlsrv support => enabled
Version => 3.0.2.2R (Unofficial)
Unofficial Changes => Works with Native Clients 11/10/9
Directive => Local Value => Master Value
pdo_sqlsrv.client_buffer_max_kb_size => 10240 => 10240
pdo_sqlsrv.log_severity => 0 => 0
Like as dll it is loaded but broad gulls of the apache suggest otherwise also a site produces 500 error.

11

Re: Connection error to basis

Delivered apache 2.4 x64 and php 5.6 x64 with drivers mssql x64.
The server produces 500 error. In broad gulls an error at connection to the server sql.
I think that an error in the code, can it is necessary Provider change.
$cfg [' ADODB '] = ' Provider=SQLNCLI; Data Source=127.0.0.1; Initial Catalog=db; Persist Security Info=True; DataTypeCompatibility=80; MARS Connection=True; User ID=sqluser; Password=sqlpass';