msado15.dll stop working after moving to Windows XP SP2
Posted on 2005-03-04
Currently I use this line in my global.asa
<!-- METADATA TYPE="TypeLib" FILE="C:\Program Files\Common Files\system\ado\msado15.dll" -->
My asp codes work perfectly with Windows 2000 Server. After I copied it to my notebook running Windows XP SP2 then it stopped working, it kept giving me the error:
variable is underfined 'adCmdText'
I can work around this error by including the adovbs.inc on every page, but want to know how to make it work with the METADATA TYPE library method.
I have search everywhere on the net without a real solution. Please give me the working solution if you have experienced the same problem and have found the way to fix it.