OdbcDataReader reader.Close() NOT SUPPORTED!!!

Boblysan

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

deepikag1521y ago
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)\r\n at System.Data.Odbc.OdbcDataReader.NextResult()\r\n at System.Data.Odbc.OdbcDataReader.FirstResult()\r\n at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)\r\n at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()\r\n 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.
0
keith.baas21y ago
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
0