- UNIFYBroker Forum
-
Questions
Unable to create Oracle DB agent on IDb v5.3.1 - Error Invalid connection string
We are trying to configure Oracle agent on IdB v5.3.1 Revision #0. Took the sample connection string at https://voice.unifysolutions.net/knowledge-bases/7/articles/2863-oracle-database-agent
as below but IdB does not accept the connection string and raise an error 'Invalid connection string' on "Save Agent"
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostName)(PORT=1251)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)));
We want to user a connection string is following format, if that is supported.
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
User Id=myUsername;Password=myPassword;
Answer
We use the standard libraries, so support whatever they do. Unfortunately the Oracle libraries are poorly documented so it's hard to say exactly what that is.
If the exception is in the logs, could you attach the full exception details? If it's not (e.g. returning the exception to the UI), could you save one that works, stop the service, edit the agent configuration so that it contains what you are after, start the service, it should be in the logs.
Thanks.
Hey Rizwan,
The second connection string that you've provided works as a valid input into UNIFYBroker. Can you give it a go and see if it connects to the database correctly?
Unfortunately the oracle page for connection strings no longer exists. See this link for an archive of it: https://web.archive.org/web/20130627000544/https://docs.oracle.com/cd/E11882_01/win.112/e18754/featConnecting.htm .
I'll update our documentation page with more relevant information
Hi guys,
The second connection string I provided was accepted by the UI.
However, now we are getting the following exception. Please note that we did installed the driver from https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html and on this server, we have VS installed where we can create a custom program to connect to the Oracle database. Please share if there are any additional steps to make IdB work with Oracle DB? thanks.
20190212,05:45:18,UNIFYBroker,AgentEngine,Warning,"The test of agent Test Oracle failed with message Unify.Framework.UnifyDataException: An exception occurred while creating the connection with the 'Oracle.DataAccess.Client' provider. See inner exception for more information: ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.
at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
at Unify.Framework.Data.OracleDataControlExtensions.CreateConnection(String connectionString)
--- End of inner exception stack trace ---
at Unify.Product.IdentityBroker.DatabaseAgent.TestConnection()
at Unify.Product.IdentityBroker.AgentEngine.Test(Guid agentId).",Normal
Unable to find the requested .Net Framework Data Provider. It may not be installed.
The data provider is not visible to UNIFYBroker. Depending on the version of the provider installer that you used and the documentation that you followed, you may need to edit the .config file (https://docs.oracle.com/cd/B28359_01/win.111/b28375/featConfig.htm) or perform a repair install.
Hi Rizwan,
Have you managed to progress this any further?
Feel free to re-open if you need further information
Customer support service by UserEcho
Hey Rizwan,
The second connection string that you've provided works as a valid input into UNIFYBroker. Can you give it a go and see if it connects to the database correctly?
Unfortunately the oracle page for connection strings no longer exists. See this link for an archive of it: https://web.archive.org/web/20130627000544/https://docs.oracle.com/cd/E11882_01/win.112/e18754/featConnecting.htm .
I'll update our documentation page with more relevant information