C# Very wierd odbc connection issue

BrokenArrows

I built a very simple application which connects to a database via a configured odbc datasource and returns the result of a query.

It is a single EXE with no configuration files.

The application works perfectly but for some reason i found that if i place it in one directory it fails to connect to the database but another directory it works fine.

Example :

C:\MyTools\Utility\MyApp.exe (fails)
C:\MyTools\Utility2\MyApp.exe (succeeds)

I dont know whats going on. There are no configured paths in the code.

Any idea what could be unique to this folder which would cause it to fail.

Colonel Panic

Hard to tell without knowing what you're doing. What have you tried? What happens when you debug the program from those example locations?

goldenhoarde

try renaming the exe that is not working as a test. Vaguely remember having to do this before for something similar. If my brain gets up to speed and remembers anything else i'll repost

amen

Why exactly does it fail ? Are you catching exceptions ?

BrokenArrows

I figured it out.

The original program which my program was designed to replace was configured to run in compatibility mode for some reason.

My program had the same file name as the original and it looks like when you replace a file with the same file name it keeps the compatibility mode settings.

Turning off the compatibility mode and it all works.