When defining a Custom Connection String in UltraDev, you have the option of using a driver on the Application Server or on the Local Machine.
Note: This option is not available in the Macintosh version of UltraDev. All connections use the Application Server.
In the Windows version, you must select Using Driver on Application Server when utilizing theServer.MapPath approach.
When using the Server ASP object, it can only be invoked via a web and application server. This is the connection method used when Using Driver on Application Server is selected. Selecting Using Driver on Local Machine connects to the database directly via ODBC; the web server, and thus the ASP Application Server, are not invoked.
It is acceptable to select Using Driver on Application Server when the server resides on the same machine as UltraDev, as when using Personal Web Server.
Note: In UltraDev 4, there is no longer a "Run Time" and "Design Time" connection. If you must useServer.MapPath for your Run Time connection, the same connection string must also apply to your design environment.
The following image shows the dialog box used to define a Custom Connection String in UltraDev using Server.MapPath and one of the connection string examples displayed above.