System error while calling fill method for second data

[Rachana]

Hi,
I am having vb2003-net 1.1

Code was working fine yesterday, today getting error
-----------------------------------------------------------
error:
An unhandled exception of type 'System.Data.SqlClient.SqlException'
occurred in system.data.dll
Additional information: System error.
-----------------------------------------------------------
Last line is highlighted. error while calling method for second data
adapter
-----------------------------------------------------------
My Code is :
Dim mDataSet As New DataSet()

Dim mConn As New SqlConnection()
mConn.ConnectionString = "Data Source=localhost;initial
catalog=transport;integrated security=XXX"
mConn.Open()

Dim mStr1 As String = "select * from mItem"
Dim mStr2 As String = "select * from mPump"

Dim mAdapter1 As New SqlDataAdapter(mStr1, mConn)
mAdapter1.Fill(mDataSet, "mItem")

Dim mAdapter2 As New SqlDataAdapter(mStr2, mConn)
mAdapter2.Fill(mDataSet, "mPump")
--------------------------------------------------------------

Need help...

Thanks,
Regards,

Rachana

 

[Guest]

can you post more error details. maybe the table doesn't exist any more.