Hwo to create a dynamic recordset?
Posted on 2003-02-18
I need a dynamic recordset (it has to be able to move backwards and forwards). Its contents should come from running a stored procedure on the sql server called "getcust". It should be based on a connection that does not use a DSN. I tried a bunch of examples on the net but I seem to get alot of errors. Can anyone show me a snippet that accomplishes what I need? at the moment I have :
conn.Open "Provider=SQLOLEDB; Data Source = nt1; Initial Catalog = sabre_cust; User Id = sa; Password="
If conn.errors.count = 0 Then
set rs = conn.execute("getcust")
however, it is not dynamic so it can only move forward not backward. Any help greatly aprpeciated, its driving me nuts!