Sqlsrv extension on 4.0.5

General discussion forum for the Zend Server
Post Reply
ccorliss
Posts: 15
Joined: Mon Sep 28, 2009 3:35 am

Sqlsrv extension on 4.0.5

Post by ccorliss » Mon Sep 28, 2009 3:57 am

I can't get the sqlsrv extension to load on zend server community 4.0.5. I'm using the newest driver from Microsoft:

http://www.microsoft.com/downloads/deta ... laylang=en

FWIW, I've also tried the previous release of this driver.

This works fine on the same machine using php 5.2.8. I haven't been able to find much helpful information in my searches so far. At this point, I think it has to do with the compiler version. The MS driver only has v6 and v9, and I don't know what ZSCE 4.0.5 compiled php with.

I can't find any details on why the extension failed to load, even in the logs.

Does anyone have the sqlsrv extension working under ZSCE 4.0.5 or even just php 5.3? Any troubleshooting tips or things that I could try?

I'm running vista x64 ultimate, q9450/8gb pc8500.

Thanks

michaelle
Posts: 173
Joined: Sun Dec 21, 2008 1:30 pm
Contact:

Re: Sqlsrv extension on 4.0.5

Post by michaelle » Tue Sep 29, 2009 2:42 pm

Can you please specify the error message that you got after restarting your Web server or after trying to access the PHP script via the browser ?
You can see the error(s) in the Event Viewer.

ccorliss
Posts: 15
Joined: Mon Sep 28, 2009 3:35 am

Re: Sqlsrv extension on 4.0.5

Post by ccorliss » Tue Sep 29, 2009 4:38 pm

From the browser, the error message is:
Zend_Db_Adapter_Sqlsrv_Exception: The Sqlsrv extension is required for this adapter but the extension is not loaded

From the Zend Server extension manager, after I click "Turn On" for my extension and "Restart PHP", the error message is:
The system could not load this extension

I don't get any entries in my event logs.

Is the anywhere else I could look for details on why the extension failed to load? It seems crazy that "The system could not load this extension" is the only information available.

michaelle
Posts: 173
Joined: Sun Dec 21, 2008 1:30 pm
Contact:

Re: Sqlsrv extension on 4.0.5

Post by michaelle » Sun Oct 04, 2009 4:08 pm

Was this extension manually compiled and/or added by you ?

ccorliss
Posts: 15
Joined: Mon Sep 28, 2009 3:35 am

Re: Sqlsrv extension on 4.0.5

Post by ccorliss » Sun Oct 04, 2009 4:20 pm

The extension was not modified and came directly from Microsoft: http://www.microsoft.com/downloads/deta ... laylang=en

I copied it into the ext directory and turned it on using the Zend extension manager.

michaelle
Posts: 173
Joined: Sun Dec 21, 2008 1:30 pm
Contact:

Re: Sqlsrv extension on 4.0.5

Post by michaelle » Sun Oct 04, 2009 4:48 pm

If so, you should verify that it is compatible with your operating system and PHP.

ccorliss
Posts: 15
Joined: Mon Sep 28, 2009 3:35 am

Re: Sqlsrv extension on 4.0.5

Post by ccorliss » Sun Oct 04, 2009 5:00 pm

Yes, it is compatible with my OS. Microsoft states that it's compatible with PHP 5.x.x - so it should support 5.3. See below requirements except from Microsoft.

Again, this driver works fine with PHP 5.2.8. I am requesting two things:
1. Where can I find details on why the extension failed to load? It doesn't seem that zend or php is logging these error details anywhere. All I have is "The system could not load this extension".
2. Is anyone currently running the Sqlsrv driver with php 5.3 or zend server 4.0.5?



System Requirements
Supported Operating Systems: Windows 2000 Service Pack 4; Windows 7; Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista Service Pack 1; Windows XP Service Pack 3

PHP 5.X.X. For more information about downloading and installing PHP, visit http://php.net.

Microsoft SQL Server 2008's SQL Server Native Client. You can download SQL Server Native Client from a SQL Server 2008 Feature Pack.

Any edition of SQL Server 2005 or SQL Server 2008.

A Web server configured to run PHP.

radekhulan
Posts: 7
Joined: Thu Oct 29, 2009 12:41 am
Location: localhost (Prague, CZ)

Re: Sqlsrv extension on 4.0.5

Post by radekhulan » Thu Oct 29, 2009 12:51 am

Zend Server CE is compiled using VC8, but Microsoft SQLSRV driver binary is delivered in VC6 / VC9.

You have to compile it yourself using Visual Studio 2005 or download a binary here:
http://hulan.info/item/zend-server-ce-p ... ver-driver

Post Reply