locked
SQL Server and VB .net Issue RRS feed

  • Question

  • I have used Global Temp Tables in my sql server 2008 SP and when i call this from VB .net it throws this Errors-

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Grant_Maximizer_Solution.frmUnitCostDetails.LoadSummaryGridWithRecipientSite() in C:\FTP\GMS Nupur\GMSImport_Latest\Grant Maximizer Solution\frmUnitCostDetails.vb:line 1859

    I am calling other sp with same concept it works but here it does create issue.

    Need urgent help.

    Thanks, Nupur Deshmukh

    Wednesday, April 24, 2013 11:45 AM

Answers

  • If you have an urgent problem, you need to supply more information about what you are doing. What are you trying to do? What does your code look like? What does your table look like? What is the text for the exception?


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Proposed as answer by Kalman Toth Thursday, May 2, 2013 12:48 AM
    • Marked as answer by Kalman Toth Friday, May 3, 2013 7:50 AM
    Wednesday, April 24, 2013 12:47 PM

All replies

  •    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Grant_Maximizer_Solution.frmUnitCostDetails.LoadSummaryGridWithRecipientSite() in C:\FTP\GMS Nupur\GMSImport_Latest\Grant Maximizer Solution\frmUnitCostDetails.vb:line 1859
    Wednesday, April 24, 2013 11:46 AM
  • This is a Transact SQL forum. Probably your question needs to be posted in another forum. I don't know if it is the right one, but maybe the Data Access forum?
    Wednesday, April 24, 2013 11:49 AM
  • If you have an urgent problem, you need to supply more information about what you are doing. What are you trying to do? What does your code look like? What does your table look like? What is the text for the exception?


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Proposed as answer by Kalman Toth Thursday, May 2, 2013 12:48 AM
    • Marked as answer by Kalman Toth Friday, May 3, 2013 7:50 AM
    Wednesday, April 24, 2013 12:47 PM
  • This message doesn't tell us what the problem is. If you have other threads on the same topic, can you provide links, so I'll merge them?

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Wednesday, April 24, 2013 1:12 PM
  • There were two similar posts with only a couple of minutes between them, but te older one seems to have disappeared.
    Wednesday, April 24, 2013 1:24 PM
  • You're missing the top part of the error message, impossible to see what the problem might be.

    Chuck Pedretti | Magenic – North Region | magenic.com

    Wednesday, April 24, 2013 2:35 PM
  • I tried merging twice and got an error both times. May be another moderator can merge these threads.

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Wednesday, April 24, 2013 2:59 PM