Unable to Execute Query for Oracle Database

Help Something Else
1

It showing below error. Someone please explain this.
Error:

Execute Query: ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

2

@raja.arslankhan

Looks like you have two instances of oracle or recently if you have upgraded then the old instance oracle home is also added I guess

Try to check in that

Also what query are you trying?

Is the deivers installed comptible with the studio? I mean 32 or 64 for both

Cheers

3

@raja.arslankhan

Have you downloaded the client as 32 bit?

Also check the ODBC you have created, if it is in 32 bit try in 64 same as viceversa

Thanks,
Srini

4

@Srini84 Hi,

Yes it is in 32 bit. can you tell me how I try in 64 bit. For it I need to install 64 bit ODBC?

5

@Anil_G Currently I am using 32 bit and many times I used it for other databases and it was working.

6

Can you try this approach for a Windows project?

  1. Install first and use UiPath.Database.Activities[1.7.1] package

  2. Use a new Connect to database activity → click on Configure Connection… → Connection Wizard → in Data Source choose Oracle.ManagedDataAccess and make sure that in the Data provider, you have also Oracle.ManagedDataAccess. Provide the Hostname, Port, Service name, User name, and Password. (if there are additional details for your connection, you need to configure them in the Advanced… window) → Test connection

  3. If the Test connection was successful you can click OK and use it further in your application. If not, you cannot use anymore the connection.

3
32560×1396 193 KB

After using the above steps, the Connection string and Provided name will be auto-generated in your Properties panel.

Let us know if you were able to Test the connection in the Wizard successfully and run some queries.

7

Hello, this is Gulshan Negi.
Well, I searched for it on Google, and I would like to tell about it in brief:
Well, the error message indicates that there is an issue with the ODBC driver for Oracle, which is being used to connect to an Oracle database. Here’s what the different parts of the error message mean:

ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019: This part of the error message indicates that the ODBC driver was unable to retrieve the text for the ORA-01019 error. ORA-01019 is an Oracle error that usually indicates a connection issue.

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed: This part of the error message indicates that the SQLSetConnectAttr function, which is used to set connection attributes, failed.

ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested (see SQLSetEnvAttr): This part of the error message indicates that the ODBC driver doesn’t support the version of ODBC behavior that the application is requesting.

Based on this error message, it’s possible that there is a compatibility issue between the version of the ODBC driver being used and the version of the Oracle database that you are trying to connect to. You may want to try updating the ODBC driver to a newer version or contacting the support team for the ODBC driver or the Oracle database for further assistance.

I hope you are clear now.
Thanks

8

Thanks All for your contribution.
Actually issue was in ODBC. I was putting service name which was given to me but here was need to put DSN which I have given in TNS file. By this I am able to run Query.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.