>>ok i decide to go with vb sp4 and mdac2.6 so i use the latest and i >>distribute the latest(dlls(sp4) and mdac(2.6)) so now again i'm stuck in same >>problem and along with exe, the project is also giving the same problem now.
>>what changes shud i make in project .. in references i'm using microsoft >>activex data object 2.6 library and in components i'm using adodc 2.6.
>>i've checked up my PC and mdac version on my PC is 2.6 RTM (2.60.6526.3) and >>no conflict at all.
>>then why this probelm????
>>plz help
>Have you checked the MDAC_TYP.EXE version from your Redist folder ?

ya its 2.6 only (2.60.6526.3) and now the problem is coming b4 distributing(after sp4 and mdac2.6 installation). I think going with latest is good idea but then i've set everything right in my project so there shud'nt be any problem.
first the project problem need to be resolved as when i run my program from VB IDE its showing the same problems as i mentioned.
and comchecker is ending up with finding 2.6 RTM (2.60.6526.3) with just one error
Item Name ,Item Type,ErrorString,Status
msdaps.dll,COM ,Key not found = 'HKEY_CLASSES_ROOT\CLSID\{0997A571-126E-11D0-9F8A-00A0C9A0631E}\InProcServer32
any clue ??