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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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…
Learn how to use the free Acronis True Image app to easily transfer data between iPhones and Android phones.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month12 days, 5 hours left to enroll

752 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