Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


ODBC Driver Settings fail for a VB appln on Win 2K

Posted on 2003-03-26
Medium Priority
Last Modified: 2007-12-19

I have created an installable(using Installshield Pro 5.5) of a VB-Oracle application , which I have developed . I have installed this pack on Windows 95,98 and NT and it works fine on all this machines. When I install it on Windows 2000 , the application is installed , but when I run this application I get an error . My first splash screen itself, does connections to database , so it shows error on first screen itself, and the error that is logged is

08:21:49 FATAL   Program Aborted
08:36:16 ERROR   Unexpected Error 40002
08:36:16         Error Source: MicrosoftRDO.RdoConnection
08:36:16         Error Description: IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I have checked my DSN-ODBC settings and everything is perfect. I have a proper entry in teh tnsnames.ora too, no connect string mismatches . All this settings worked perfectly on Win 9x n NT, then what could be the problem on a Win 2K machine?

I specially tested my application on 2000 , because our clients use 2000 . So it's important that I get it running on this machine.

Thanks & Regards
Question by:Chitra91

Accepted Solution

rafsalman earned 600 total points
ID: 8209419
Hmm my reply doesn't seem to have gone through

In short then - I think this is down to Windows File protection.

NT, 98, 95 do not have WFP.

ME, 2k and XP do.

Essentially this feature prevents you from replacing a file which was originally installed as part of the operating system - this is to reduce the risks of DLL Hell, where mismatched file versions causes problems with other applications in the system. This feature is described in a little more detail in the articles below:

253571 Description of the System File Protection Feature (Windows ME)

222193 Description of the Windows File Protection Feature (Windows 2000 and XP)

It is probably better to deploy the oldest versions of the files if you want to avoid issues with Windows File Protection, but it is important to test the deployment package on each target operating system to ensure that it installs and runs correctly.

I would imagine this is a problem with the ODBC DLLs from your message, but it is worth checking out other DLLs on MS site to see if they are a standard component of Win 2k OS - if so will need to use the oldest version number of the systems it is included with and which you want to install on (applies to ME, 2k and XP).  Sometimes DLLs are older in win 2k compared to ME.





Expert Comment

ID: 8595683
This question is still open and getting old. If any of the comment(s) above helped you please accept it as an answer or split the points who ever helped you in this question. Your attention in finalising this question is very much appreciated. Thanks in advance,


- If you would like to close this question and have your points refunded, please post a question in community support area on http://www.experts-exchange.com/Community_Support/ giving the address of this question. Thank you      


Cleanup Volunteer


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question