Test Connection with Oracle Name Server

[michaellevy]

Our application expects that the local machine has Oracle client installed and that it is configured to use Oracle name server. At installation we want the user to provide the database alias, user name, and password so we can test the database connection and store the info. The machine has no datasources defined and we do not know or care what the name of the database server is.
The built in SQL functions and dialogs do not work in this situation.

We have an InstallScript MSI project with the following code in OnFirstUIBefore to prompt the user for the 3 needed values.

szTitle  = "Database Connection";
szMsg    = "Enter the values for the database connection.";
szField1 = "Database Name:";
szField2 = "User ID:";
szField3 = "Password:";
nResult  = SdShowDlgEdit3 (szTitle, szMsg, szField1, szField2, szField3, svDatabase, svUserName, svPassword);

How would I go about testing the connection given the three values provided by the install user?

[Charlieh]

I too wolud like to know how you test an Oracle connection. This is really holding me up now, please advise, many thanks.

Charlie:confused: