Silent SQLConnect
I'm currently writing an application that once a day collects data from several databases with the same structure and store the selected info in my application database for further processing. This part of the program runs in background with no user intervention. I'm using the SQLConnect method from the cSQLHandleManager class to connect to the different databases providing the correct driver and connection string parameter info. However, if for some reason a connection could not be made it automatically pop ups a login dialog box to enter the correct credentials. This behavior doesn't allow me to do the collecting of data in unattended. Is there a way to check if a connection to a database is successful without displaying the login panel if the connection could not be established successfully?
Kind regards,
Hans van de Laar
Data Access Europe