Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

NT and ODBC

2 posts in Windows NT Last posting was on 1998-04-21 23:16:25.0Z
Rob Ratterman Posted on 1998-04-19 19:01:16.0Z
From: "Rob Ratterman" <jump@goodnews.net>
Subject: NT and ODBC
Date: Sun, 19 Apr 1998 15:01:16 -0400
Lines: 18
Organization: Jump Inc.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <K0unAw7a9GA.689@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5065
Article PK: 1092428

Hello all...

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:

dbOpenSnapshot
dbOpenForwardOnly
dbOpenDynaset
dbOpenDynamic


Thanks a lot!

Rob


Trent Posted on 1998-04-21 23:16:25.0Z
From: "Trent" <trentm@panamax.com>
Subject: Re: NT and ODBC
References: <K0unAw7a9GA.689@forums.powersoft.com>
Message-ID: <01bd6d84$b3cb55c0$f472a826@trentmears>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 21 Apr 1998 19:16:25 -0400
Lines: 31
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
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.

Rob Ratterman wrote
> 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:
>
> dbOpenSnapshot
> dbOpenForwardOnly
> dbOpenDynaset
> dbOpenDynamic
>
> Thanks a lot!
> Rob