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
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.