In article <[log in to unmask]>,
  Ken Vickers <[log in to unmask]> wrote:
> >I hope someone on the list knows this information.  First, the ODBC SE
> >drivers seem to only support "FORWARD ONLY" cursors.  Is this correct?
> >Can it be changed with configuration settings? And, is there a
> >definitive list of what the ODBC SE drivers support.
> The Allbase dynamic sql interface will not allow anything else unfortunately
> :-(

OpenLink's ODBC (and JDBC) drivers support keyset-driven cursor modes, with
full dynamic cursors expected soon. They're available from
http://www.openlinksw.com/.

> >Pet Peeve #2, since the ODBC Drivers store Logon and Filenames when
> >they are configured, there is no simple way for a program prompt for
> >USER/PASSWORD or Database without creating a new Datasource.  If
> >anyone has any insight here it would be appreciated.
> There are several ODBC calls to connect to the DBE. Only one of these allows
> the driver a handle to allow it to ask for input.

It depends on whether the application uses SQLConnect() or SQLDriverConnect(),
because the latter has a flag to control whether logon details could/should be
requested.

Please let us know if you have further queries.

Best regards,

Tim Haynes
Support Consultant
OpenLink Software    Web: http://www.openlinksw.co.uk/
Universal Database Connectivity Technology Providers

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum