Why is my dataadapter empty?

[shaunieb]

Hi everyone. When i run my application i get the following error on the highlighted line :: Additional information: Value cannot be null.

Dim connStr As String
connStr = String.Format("server={0};user id={1}; password={2}; database=prodev; pooling=false", "main", "root", "root")
Dim Excel As New Microsoft.Office.Interop.Excel.Application
Dim dsExcelExport As DataSet
Dim conn As New MySqlConnection(connStr)
Dim daExcelExport As MySqlDataAdapter
Dim intColumn, intRow, intColumnValue As Integer
Dim strExcelFile As String
Dim strFileName As String

daExcelExport = New MySqlDataAdapter("select * from users", conn)
daExcelExport.Fill(dsExcelExport)