Logon (Ours looks like the Banner Client Server Logon)
The Logon Form includes an Event (On Click in Connect) that verifies the Username/Password for the Database. This Event code builds a connect string and tries the connection (using SELECT SYSDATE FROM DUAL; Really, that is all you need.) It then applies that successful connect string to every Pass-Through Query in our MS Access Database (we call it BannerAccess). It can do several hundred in a second or so.
Next: Logon with separate DSN and DBQ
Disclaimer
Use this information and these scripts at your own risk. As a condition of using these
scripts and information from this site, you agree to hold harmless both the
University of Arkansas Cooperative Extension Service and Bruce Knox for any
problems that they may cause or other situations that may arise from their use,
and that neither the Extension Service nor I will be held liable for those
consequences. The scripts and
information are provided "as is" without warranty, implied or
otherwise. Limitation of liability will
be the amount paid to the University of Arkansas specifically for this
information. (It was free:)
visits
http://www.uaex.edu/bknox/Summit_2003_p02.htm Logon (Ours looks like the Banner Client Server Logon)