Unable to connect from 32 bit application with Oracle 32 bit dsn

Question

0.00/5 (No votes)

See more:

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.
Thanks.

Posted 22-Jul-12 21:29pm

ashriv

Add a Solution

2 solutions

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.

Posted 23-Jul-12 2:45am

George L. Jackson

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Code-o-mat · Accepted Answer · 2012-07-23T03:05:00

Hello!

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.