VB3 ODBC connect dialog

From: Mark Holdernesse <mholdern_at_sitgtrc1.telstra.com.au>
Date: Tue, 12 May 1998 07:00:34 GMT
Message-ID: <3557f371.26634949_at_saXnews.telecom.com.au>

I've created a dialog to input a username & password for an oracle database.

I use the following to connect to the database

    Set gdb_mnd = OpenDatabase("", False, False, "ODBC;DSN=" & <DSN> & ";UID=" & <username> & ";PWD=" & <password.)

This works fine unless the user makes a mistake with the username or password. In this case the oracle odbc driver pops up it's own dialog box where the user can correct the problem. How do I supress this dialog and trap the error within the VB code to reprompt the user?

TIA
Mark Received on Tue May 12 1998 - 09:00:34 CEST