Hi All,
We have just beocme an OEM and will soon be upgrading our clients form SQL 8
to 11. This requires an "authenticated" database. We will modify our main
appliction to execute the necessary authentication sql on the client side.
Howerer, we have written several side applications using Access and
InofMaker. What is the best way to connect to the database using these tools
without forcing the end user to execute a "SET TEMPORARY OPTION" statement
each time they run those side applications.

TIA
Mike

Will Access and Infomaker be updating the database? If so, you will need
to add InitString=<set_connection_authentication_option> to the ODBC
configuration (via the advanced tab Additional Connection Parms). If
these are read-only, there will be no need to authenticate these
connections using the most common OEM option.

Mike Marston wrote:

Chris,
Thanks for the response. The side apps are all read only, so it sounds like
we don't have to do anything with them.

Mike
"Chris Keating (Sybase iAnywhere)" <keating_nospam (AT) sybase (DOT) com> wrote in
message news:4b197a5f$1 (AT) forums-1-dub (DOT) ..