Devart Forums

Hi, There,
I have down load the trial version of Devart for Oracle and installed on my machine.

My boss told me once it pass our simple unit tests, we will buy a set licenses.

I run it in MS visual V#. Test it follows the sample in the document. I created the Edmx file. It connects the database and load data back smoothly.

But when I try to run the similar code in our unit test, it always false to connect the Oracle database. Reporting error like "Devart.Data.Oracle.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified."

I already aware the the Visual studio only support 32 bit version. So I make sure my simple test run 32bit and it works fine. But 32 bit unit test always show error. I have used the same connection string for both cases. And I clean my machine so it only have 32bit Oracle Client installed.

Does anyone aware this problems? Or is it because I only have a trial version?

Thanks.

John

Please make sure the connection string is valid. The error looks like there is something wrong with server name.
Do you use Direct mode? If so, please check the SID value, it should correspond to the service name.

john wang wrote:ORA-12154: TNS:could not resolve the connect identifier specified."

It sounds like you are using the mode that depends on the Oracle client being installed. Is the service identifier setup in the tnsnames.ora in your Oracle client install folder? If you want direct mode, which doesn't rely on the Oracle client, you will need to add "Direct=True" to the connection string.