I have a program that has been created using Visual Basic 6.0. The application accesses SQL Server 2000 through a data control and ODBC. The recordset returned is a snapshot, but a dynaset is needed.
What needs to be done to return a dynaset instead of a snapshot?
Specs:
DAO 3.51: data control
ODBC Driver: SQLSRV32.dll, 11/18/04, 2000.85.1025.00
Language: VB 6.0
OS: Windows XP Pro
Data Control Data Props: ReadOnly: false, defaulttype: 2 - UseJet, Connect: "odbc;database=sg;uid=sa;pwd=sa;dsn=sg_local;", Recordset type: 1 - Dynaset, RecordSource: select planid from plans,
FAQ
Profile
Private Messages
Log in
