Page 1 of 1

Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 12:40 pm
by tgozum

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


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 12:53 pm
by mobhar

Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 1:16 pm
by tgozum

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,


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 1:40 pm
by Webmaster

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.


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 1:50 pm
by tgozum

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


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 2:48 pm
by Webmaster

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.


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 3:46 pm
by tgozum

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?


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 3:53 pm
by mobhar

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


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 4:03 pm
by tgozum

still no change


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 4:43 pm
by Webmaster

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.


Re: Class 'VARIANT' not found

Posted: Fri Oct 18, 2013 4:51 pm
by tgozum

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


Re: Class 'VARIANT' not found

Posted: Sat Oct 19, 2013 9:26 am
by Webmaster

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