Uipath connect to Firebird + procedure exec + ODBC driver devart- ERROR [HY000]
Posted: Mon 19 Oct 2020 15:25
Hi,
Please help. And thank you
It gives up after a few days. Calling the firebird PROCEDURE is not working for me.
Connection using ODBC. After ODBC configuration, the connection TEST is correct. At 100%. I checked the connection in a different way. It's ok. Invoking regular SQL query is ok. When trying to call the procedure, I get an error:
ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
I checked the drivers: devart ODBC, from firebird ado.net.driver ODBC, easysoft ODBC. It doesn't work in any case.
Receives a senseless error: ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
The procedure is correct. Recalling it 100% is correct. At least i think so. I am doing the same for MsSQL and it is fine
Source: Execute Query
Message: ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
CREATE_ATID
Exception Type: System.Data.Odbc.OdbcException
RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
CREATE_ATID
Server stack trace:
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at UiPath.Database.DatabaseConnection.ExecuteQuery(String sql, Dictionary`2 parameters, Int32 commandTimeout, CommandType commandType)
at UiPath.Database.Activities.ExecuteQuery.<>c__DisplayClass38_0.<BeginExecute>b__0()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at [0]:
at UiPath.Database.Activities.ExecuteQuery.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
Please help. And thank you
It gives up after a few days. Calling the firebird PROCEDURE is not working for me.
Connection using ODBC. After ODBC configuration, the connection TEST is correct. At 100%. I checked the connection in a different way. It's ok. Invoking regular SQL query is ok. When trying to call the procedure, I get an error:
ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
I checked the drivers: devart ODBC, from firebird ado.net.driver ODBC, easysoft ODBC. It doesn't work in any case.
Receives a senseless error: ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
The procedure is correct. Recalling it 100% is correct. At least i think so. I am doing the same for MsSQL and it is fine
Source: Execute Query
Message: ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
CREATE_ATID
Exception Type: System.Data.Odbc.OdbcException
RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [HY000] [Devart][ODBC][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
CREATE_ATID
Server stack trace:
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at UiPath.Database.DatabaseConnection.ExecuteQuery(String sql, Dictionary`2 parameters, Int32 commandTimeout, CommandType commandType)
at UiPath.Database.Activities.ExecuteQuery.<>c__DisplayClass38_0.<BeginExecute>b__0()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at [0]:
at UiPath.Database.Activities.ExecuteQuery.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)