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
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.