Hi,
I am new to MySQL.

I am trying to use an sql statement to get a few values.

SQLtemp1 = "select (sum(parametercount)-sum(missesatparameterlevel)/
(23*count(calibrationmasterid))) as hcsum from
staticvariancecalibrationmaster "

I get the following error message :

Microsoft OLE DB Provider for ODBC Drivers error '80020009'

[Microsoft][ODBC Driver Manager] Program type out of range

It works well on my localhost. When I upload it onto my webserver I
get the above mentioned error message.

Any suggestions ?


Cheers.