TheQuestioner
Programmer
I have created an ADE (comipiled ADP) application, that on startup, prompts the user for standard SQL Server (MSDE) connection details, if it cannot connect to the last used connection.
My application will eventually be installed on various client environments. Each of these clients will obviously have different servers that will be hosting my application's backend MSDE database.
The problem I have is as the client's server name is always going to be different from my development server's name , on startup my application pauses for some time (30 seconds+) whilst it tries to connect using the old development environment connection details. Once this fails, a couple of error messages appear, and then finally my New Connection Details Entry screen is displayed.
What I want to do is display my New Connection Details Entries screen as soon as my application has started. I want this screen to display the last connection details without actually trying to connect first.
I can obviously store the connection details in a INI file and then get my app to fetch it on startup, but how do I stop it from trying to connect to the last used connection? Any help would be greatly appreciated.
My application will eventually be installed on various client environments. Each of these clients will obviously have different servers that will be hosting my application's backend MSDE database.
The problem I have is as the client's server name is always going to be different from my development server's name , on startup my application pauses for some time (30 seconds+) whilst it tries to connect using the old development environment connection details. Once this fails, a couple of error messages appear, and then finally my New Connection Details Entry screen is displayed.
What I want to do is display my New Connection Details Entries screen as soon as my application has started. I want this screen to display the last connection details without actually trying to connect first.
I can obviously store the connection details in a INI file and then get my app to fetch it on startup, but how do I stop it from trying to connect to the last used connection? Any help would be greatly appreciated.