G
Guest
Access to SQL server is ok when using SQLserver tools (enterprise manager /
query analyzer) or collecting data through Excel.
By some reason I cannot connect when running a ASP-script, resulting in a
"access denied". The same script can connect without problem on another
machine
I suspected MDAC version problem and have tried to install 2.8, but getting
the response that "2.8RTM is incompatible with this version" and cannot be
installed.
Downloaded the ComponentChecker tool from MS/downloads which says I have v2.5
It's a WinXPP SP2 which should as I understand include v2.81 when installing
SP2
When checking with ComponentChecker and comparing it to "MDAC 2.8 SP1 on
Windows XP SP2" the result says that 34 files are mismatch
Going down in registry to HKLM\Software\Microsoft\DataAccess I find
Full21Install 0xffffffff
FullInstallVer 2.81.1117.0
IE5_Version 0.0.0.0
RollbackVersion 2.60.6526.2
SavedRollbackVersion 2.81.1117.0
Version 2.0.0
query analyzer) or collecting data through Excel.
By some reason I cannot connect when running a ASP-script, resulting in a
"access denied". The same script can connect without problem on another
machine
I suspected MDAC version problem and have tried to install 2.8, but getting
the response that "2.8RTM is incompatible with this version" and cannot be
installed.
Downloaded the ComponentChecker tool from MS/downloads which says I have v2.5
It's a WinXPP SP2 which should as I understand include v2.81 when installing
SP2
When checking with ComponentChecker and comparing it to "MDAC 2.8 SP1 on
Windows XP SP2" the result says that 34 files are mismatch
Going down in registry to HKLM\Software\Microsoft\DataAccess I find
Full21Install 0xffffffff
FullInstallVer 2.81.1117.0
IE5_Version 0.0.0.0
RollbackVersion 2.60.6526.2
SavedRollbackVersion 2.81.1117.0
Version 2.0.0