Hello,I am trying to execute a query against Eloqua using the DataDirect Cloud ODBC driver and I get the following errorERROR [HY000] [DataDirect][ODBC Cloud driver][Service]Session already in use.
Here is the call stack
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 ConsoleApplication.Program.D2C_DownloadFormSubmits() in c:\users\apendhar\documents\visual studio 2015\Projects\EloquaDownloadMetrics\ConsoleApplication\Program.cs:line 33 at ConsoleApplication.Program.Main(String args) in c:\users\apendhar\documents\visual studio 2015\Projects\EloquaDownloadMetrics\ConsoleApplication\Program.cs:line 17Any idea what is the problem and how can I resolve it?
We are looking into this and will follow up with a response.
I have ODBC trace log files also but didn't find a way to attach them here. Let me know if you need them.
I'm looking into this and will contact you directly.
As far as I remember I was testing a query via the D2C UI and it was taking too long.
I then switched to writing a .NET application using the ODBC driver.
My very first attempt to execute a query gave me the above mentioned exception. I wonder which session was conflicting. The OdbcCommand.ExecuteReader method return the exception and that crashed the app.
On subsequent runs I got the same exception.
Probably the session was still active in D2C?
I will send you the logs directly.
Thanks for the reply. I did set the timeout to -1 for my test application.