OdbcDataReader reader.Close() NOT SUPPORTED!!!

Question

Hey folks If anyone has any ideas on how to get around this it would be GREATLY appreciated. I am trying to pull data from a memory resident TimesTen database. I have an ODBC connection to this database and am using the .NET ODBC add on for visual studio. I am able so successfully establish a connection to the database read information from the database and populate the information in to a list box. The problem is that when I go to call the data reader I am getting an ODBCException error that the reader.Close() function is not supported by the driver. I am assuming that the error is refering to the ODBC TimesTen 4.532 driver I am using to make the connection from my computer to the datasource. Are there any utilities out there that will bridge the gap between the prodominant OLE functionalities of the VS environment and the ODBC data provider / ODBC drivers? Any assistance would be greatly appreciated. Thanks Bob

deepikag15 · Answer

Hello I am working on c# and times ten database version 4.0. OdbcConnection ttConnect = new OdbcConnection(ttconnectString); ttConnect.ConnectionTimeout = 120; ttConnect.Open(); OdbcCommand ttCommand = ttConnect.CreateCommand(); OdbcTransaction ttTrans; ttTrans = ttConnect.BeginTransaction(IsolationLevel.ReadCommitted); ttCommand.Transaction = ttTrans; try { ttCommand.CommandText = insert into mb.t_mb_agent_prop..; ttCommand.ExecuteNonQuery(); ttTrans.Commit(); } I keep getting this error- {ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function } [System.Data.Odbc.OdbcException]: {System.Data.Odbc.OdbcException} System.Object: {System.Data.Odbc.OdbcException} _className: null _COMPlusExceptionCode: -532459699 _exceptionMethod: _exceptionMethodString: null _helpURL: null _HResult: -2146233087 _innerException: { } _message: System error. _remoteStackIndex: 0 _remoteStackTraceString: null _source: null _stackTrace: {System.Array} _stackTraceString: null _xcode: -532459699 _xptrs: 0 HelpLink: null HResult: -2146233087 InnerException: { } Message: ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function Source: ttcl40.dll StackTrace:  at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle SQL_HANDLE hType RETCODE retcode)
 at System.Data.Odbc.OdbcDataReader.NextResult()
 at System.Data.Odbc.OdbcDataReader.FirstResult()
 at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior String method)
 at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
 at testxtenconnection.WebForm1.Page_Load(Object sender EventArgs e) in c:\inetpub\wwwroot\testxtenconnection\webform1.aspx.cs:line 89 TargetSite: {System.Reflection.RuntimeMethodInfo} After this when I try inserting a row directly from the command line I get a Lock request denied because of time-out error. Since all of us are working on the same thing it will be great if we can post anything that we find out about insert/update through C#. Thanks.

keith.baas · Answer

Bob I don't have a solution but perhaps an alternate work around. From the sql description it looks like your working w/ Aspect tables. If that's true the Real Time System Grabber will dump this data to an oracle table where i'm guessing you'll get a more standard response to closing the datasource. Just an idea. I'm working at hitting this stuff myself and am very interested in what you come up with. Regards Keith