Shancp
Posts: 1
Joined: Wed Jul 01, 2009 1:48 pm

Supress ODBC Error Message

Hi,

I am using SqlConnectionDlg and calling the function TestSqlConnection of TestODBCOnnection in Predefined UI Custom action . When ever i input a wrong uid or password , function return an ODBC error message . Is there any way to suppress this message .
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: Supress ODBC Error Message

Hi,

The error messages cannot be suppressed because this would defeat the purpose (testing if the supplied information is correct).

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
stretchedout2
Posts: 16
Joined: Wed Mar 25, 2009 1:37 pm

Re: Supress ODBC Error Message

Cosmin,

What if you just wanted to test for an ODBC datasource? I'd like to be able to test for the existence of an ODBC datasource and request the info from the user only if it does not exist... without the ugly SQL Error:

[SQLDriverConnect][SQL_STATE:IM002} [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Greg
GabrielBarbu
Posts: 2146
Joined: Thu Jul 09, 2009 11:24 am
Contact: Website

Re: Supress ODBC Error Message

Hello,

This feature is not supported by Advanced Installer. However you can create your own custom action that uses the ODBC API to test for the existence of a Data Source.

Regards,
Gabriel
Gabriel Barbu
Advanced Installer Team
http://www.advancedinstaller.com/

Return to “Common Problems”