I am using a Sheridan ultragrid and trying to bind its datasource to an ADO recordset. I use the following code -
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.Open "provider=sqloledb;server=ssarup-desk1;uid=shabnam;"
rs.Open "select * from pubs..authors", conn
Set SSUltraGrid1.DataSource = rs
when I run the app, it gives me the error 'Provider does not support minimum binding requirements'. The sheridan help says that I can bind the datasource to an ADO recordset. Any ideas what the problem is? My db is SQL Server 7.0
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.Open "provider=sqloledb;server=ssarup-desk1;uid=shabnam;"
rs.Open "select * from pubs..authors", conn
Set SSUltraGrid1.DataSource = rs
when I run the app, it gives me the error 'Provider does not support minimum binding requirements'. The sheridan help says that I can bind the datasource to an ADO recordset. Any ideas what the problem is? My db is SQL Server 7.0
