I have developed an application in VB.NET and a database in MS SQL SERVER2000.I have defined corresponding controls(fields) on the form and I want to retrieve and display records on those controls from SQL Server database. I have defined parameters for SqlDataAdapter,SqlConnect as well as an appropriate data set accordingly.But my concern here is I can not retrieve/Load those records from the database using On-Click event of Fill method ie SqlDataAdapter1.Fill(dataset1).In which case am getting an error message like "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error."

But still I can preview the records through the SqlDataAdapter!!!!
OLE DB provider for SQL Server was also set correctly.

Is there anything should be taken under consideration in SQL SERVER connection setups???since the same VB.NET form worked fine for MS Access database...

I am really stuck ....please can you help???