Connecting TestComplete to Oracle DB
Hello, I'm trying to set up a connection from TestComplete to Oracle to do some Testing. Here's the connection string I'm using and also the oracle driver is installed on the machine as shown ...
Forum Discussion
Marsha_R
Champion Level 3
Champion Level 3
Hey Marsha,
Currently, I'm using ADO Object to connect to a different database and that works fine, but I wanted to do the same to connect to Oracle DB as well, but that seems to have some problem related to Oracle driver. I'm not able to figure out what's the issue here.
Thank you
Abhi
What version of Test Complete are you running? If it's the latest you might be running the 64-bit version, and it looks like you only have the 32-bit driver installed.
cunderw Thanks for pointing that out. That was a mistake, and I corrected it by updating the driver name as present in the snapshot, but still get this error even if the driver is available.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have another update on this:
_____________________________
After changing the configuration again, I see that I'm moving in a right direction.
Currently, on my machine, I have a 64-bit Oracle 21c Client installed, and Test Complete version I'm using is also 64-bit
I have created a DSN for this and Tested the connection in the Odbc Administrator Tool, and the connection worked. Only thing left was to use this DSN in my connection String and run the javascript routine to Test the code.
This time, I see another issue:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
It seems that this is due to the compatibility issues due to 64-bit vs 32-bit versions. Still trying to find out more to resolve this.
In the meantime, if you have any idea of what it's due to, please let me know.
Thank you
Abhi
