Click here to Skip to main content
13,149,756 members (57,488 online)
Rate this:
Please Sign up or sign in to vote.
my Machine configuration is Windows 7 64 bit.

I made DSN for oracle client in Syswow64. I tested the connection is successfully created.

I've an application which I install in Program files(x86) and try to login it gives me error 'unable to connect database'.

This application is successfully login with windows 7 32 bit machine.

SysWow64 dsn is used for making DSN for 32bit Orcale and Program files(x86) is used for 32bit application.

so, where is the problem?
help me.
Posted 22-Jul-12 21:29pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Are you sure the application you installed was not compiled as a 64-bit application. A 64-bit application installed in the "Program Files (x86)" will not run as a 32-bit one. Also, you set your 32-bit DSN via %windir%\SysWoW64\odbcad32.exe.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


This might or might not be your case, but we ran into a similar problem with a 32 bit application not being able to connect and after loads of googling and researching we found out that the problem was that the 32 bit app, being launched from "Program Files (x86)" has parentheses in its path and this breaks something on Oracle's side. You can easily test this by installing the software somewhere else so its path does not have any "special characters" in it. My solution would have been to run the software with a "dos" path (so instead of "c:\program files (x86)\software name\executable.exe" it would be something like "c:\progra~2\softwa~1\execut~1.exe"), upon executing the software, it would check its own path, and if it found any parantheses in it, it would convert the path to a dos-path and start another instance of itself using this path with ShellExecute or CreateProcess and exit, this has been tested and worked well. However, in the end -against my will, so to say- we decided to change the installer so it does not allow the user to instal the software under "Progam files (x86)".

Good luck.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170924.2 | Last Updated 23 Jul 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100