I'm getting the following error at the ' reader = cmd.ExecuteReader() ' line of the code below:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.


Here's the code:

VB Code:
  1. Dim oSQLConn As SqlConnection
  2.         Dim sql As String
  3.         Dim cmd As SqlCommand
  4.         Dim reader As SqlDataReader
  5.  
  6.         sql = "select column_name from information_schema.columns where table_name='selfserve_receipt_item_maillist"
  7.  
  8.         oSQLConn = New SqlConnection("Data Source=RMSDEVSQL1;Initial Catalog= SelfserveDB;user id=kiwisql;Password=fruitcake")
  9.         cmd = New SqlCommand(sql, oSQLConn)
  10.         oSQLConn.Open()
  11.         reader = cmd.ExecuteReader()


I'm somewhat new to ADO.NET (what the heck happen to recordsets!) so I'm not used to working with SQLDataReader. Any help would be appreciated.