Class 'VARIANT' not found

tgozum · Post by **tgozum** » Fri Oct 18, 2013 12:40 pm

I am running sql server 2008 on windows server 2008 R2 SP1 64 bit

I am receiving

Fatal error: Class 'VARIANT' not found in C:\inetpub\deneme\adodb5\drivers\adodb-ado5.inc.php on line 42

error

I have installed ms sql server native client x64

it does not let me install x86 version. Says package is not compatible with os.

it exactly says "Installation of this product failed because it is not supported on this operating system.

My os is

WINDOWS SERVER 2008 R2 STANDART SERVICE PACK 1 64 BIT

CPU IS

INTEL XEON E5506 CPU

MY SQL SERVER IS ALSO MS SQL SERVER 2008 64 BIT

Please help me with the solution ASAP.

regards

mobhar · Post by **mobhar** » Fri Oct 18, 2013 12:53 pm

http://www.hkvforums.com/viewtopic.php? ... ant#p90860

tgozum · Post by **tgozum** » Fri Oct 18, 2013 1:16 pm

I have gone through all the topics in the forum regarding this issue they did not worked. The problem seems that I cannot install x86 version of native client because my server is x64. however I cannot change the server so we need to figure out a way through it

regadrs,

Post by **Webmaster** » Fri Oct 18, 2013 1:40 pm

According to technet.microsoft.com/en-us/library/cc296170(v=sql.105).aspx:
The x86 version of SQL Server Native Client is required on the computer where PHP is running. If you are using a 64-bit operating system, the x86 version of SQL Server Native Client will be installed with the x64 version of SQL Server Native Client (do not install the x86 version of SQL Server Native Client on an x64 operating system).

So try reinstall the x64 version of SQL Server Native Client.

tgozum · Post by **tgozum** » Fri Oct 18, 2013 1:50 pm

I have uninstalledandre installed and re installed and restarted the server couple of times. Also I regenerated the files. Still no change. I am getting the same error

Post by **Webmaster** » Fri Oct 18, 2013 2:48 pm

As said in http://www.hkvforums.com/viewtopic.php?f=4&t=32071:
As of PHP 5.3.15 / 5.4.5, this COM extension requires php_com_dotnet.dll to be enabled inside of php.ini in order to use these functions, read: http://www.php.net/manual/en/com.installation.php

Are you sure you have enabled the COM extension in your php.ini properly?

Make sure php_com_dotnet.dll does exist in the PHP extension folder specified in php.ini.

tgozum · Post by **tgozum** » Fri Oct 18, 2013 3:46 pm

yes it is there

I added

[COM_DOT_NET]
extension=php_com_dotnet.dll

lines to my php.ini file need to do nything else?

mobhar · Post by **mobhar** » Fri Oct 18, 2013 3:53 pm

After customizing your php.ini file, then make sure you have restarted your web server.

tgozum · Post by **tgozum** » Fri Oct 18, 2013 4:03 pm

still no change

Post by **Webmaster** » Fri Oct 18, 2013 4:43 pm

Make sure you have configured your application pool in IIS and set "Enabled 32-Bit Applications" to True, see Introduction to PHP and MySQL in the help file.

tgozum · Post by **tgozum** » Fri Oct 18, 2013 4:51 pm

it is enabled now but still no change I am gettingth same error

Post by **Webmaster** » Sat Oct 19, 2013 9:26 am

Make sure you install x86 version of PHP 5.x, not x64 version.