Here is my code. I was using sqlclient.sqldataadapter prior, but had to change due to the application's development.
I have moved to Odbc, but now cant get datasets to fill. What am I missing. The connection is open...
Dim lsSQL As String
Dim lrs As New Odbc.OdbcDataAdapter
Dim lCommand As Odbc.OdbcCommand
Dim ds As New DataSet
Login = False
lsSQL = "Select * FROM tblUser " ' WHERE UserName = " & qStrSQL(User) & " AND activeFlg = 1"
'lsSQL = "Select * FROM tblUser WHERE UserName = " & qStrSQL(User) & " AND activeFlg = 1"
lCommand = New Odbc.OdbcCommand(lsSQL, gConn)
lrs.SelectCommand = lCommand