I am writing a VB5 app to access Sybase SQLServer 11.02 via DAO and ODBC.
There are a number of cursor types that can be used. Any suggestions?
Here are the DAO VB cursor types:
Thanks a lot!
Subject: NT and ODBC
Date: Sun, 19 Apr 1998 15:01:16 -0400
Organization: Jump Inc.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Xref: forums-1-dub sybase.public.sqlserver.nt:5065
Article PK: 1092428
Subject: Re: NT and ODBC
X-Newsreader: Microsoft Internet News 4.70.1155
Date: Tue, 21 Apr 1998 19:16:25 -0400
Xref: forums-1-dub sybase.public.sqlserver.nt:5060
Article PK: 1092424
It really depends what you're attempting. I have some fairly large projects
using the same connections you are using and I end up using different
cursor types in different situations. If you need an updatable recordset
dbOpenDynaset will work for you. If you're filling combo boxes or other
things that you can just read through once, then you can use dbOpenSnapshot
or ForwardOnly (these really turn out the same) --you can also use the
dbSqlPassthrough option to greatly increase your speed if you are doing
read-only queries (you need to change your syntax to Sybase SQL instead of
JET syntax if you use passthroughs). You can look at VB5 OpenRecordset
Method help for a more complete rundown on the cursor types (for example
Dynamic sets are only available via ODBCDirect workspaces). If you'd like,
you can email me directly if you have further questions. hope this helps.