Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Connect to oracle db odbc win32/64 probelm delphi10


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 3 - Last Post: Aug 3, 2017 12:39 AM Last Post By: Elmothana Khogali Threads: [ Previous | Next ]
Elmothana Khogali

Posts: 24
Registered: 9/14/12
Connect to oracle db odbc win32/64 probelm delphi10  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 30, 2017 2:26 AM
Dear All
am using delphi10, and trying to connect to oracle 12c db
when i use udl file to test connection it success
but when trying to connect through ADOConnection1.connectionstring with same configurations, it gives me an error :

"the connection faild because of an error in initializing provider. [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
"
need your help please,,,
Elmothana Khogali

Posts: 24
Registered: 9/14/12
Re: Connect to oracle db odbc win32/64 probelm delphi10  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 31, 2017 2:41 AM   in response to: Elmothana Khogali in response to: Elmothana Khogali
it seems no answer !?
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Connect to oracle db odbc win32/64 probelm delphi10  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 31, 2017 10:39 AM   in response to: Elmothana Khogali in response to: Elmothana Khogali
Elmothana Khogali wrote:
Dear All
am using delphi10, and trying to connect to oracle 12c db
when i use udl file to test connection it success
but when trying to connect through ADOConnection1.connectionstring with same configurations, it gives me an error :

"the connection faild because of an error in initializing provider. [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
"
need your help please,,,

Usually this means you are using a DSN that is using 64 bits when your app is 32
bits or vice versa. The bitness ODBC driver you use must match the bitness of
your app.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Elmothana Khogali

Posts: 24
Registered: 9/14/12
Re: Connect to oracle db odbc win32/64 probelm delphi10  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 3, 2017 12:39 AM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Dear Jeff
thanks for your replay
I see that the problem in 32/64 bit application/DSN
what am trying to know: how solve this issue
i have been googling with no success
if u have special experience, and it could be shared,
please help
regards
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02