Design-Time Same as Run-Time Connection
in UltraDev, with your page open, you need to click MODIFY>CONNECTIONS
and then click
2. Now you need to give your connection a name.
We are going to call it connTutorial in this example.
NOTE: we are entering information for the Run-Time
connection (in other words this connection is for the web server).
3. Now select the Type of connection - were going
to choose ADO (Conection
string) (or DSN-Less connection string as it more commonly
4. Now cut and paste the connection string we made
earlier into the String
5. If you click the Test
button, UltraDev will try and connect to the database specified
in the string, so you will have to make sure you are online (if
web server is remote). Whether this works or not, if you click
OK, Ultradev WILL insert the code into the web page.
6. Now click on the Design-Time
tab and fill in the relevant information for the design-time connection.
Here you have a couple of options. If you are always connected
to your web server (over a network for example) then you can check
the Same as Run-Time checkbox.
Or you can set up a local DSN or a local DSN-less connection string
to enable UltraDev to populate it's dialog boxes whilst offline.
Here we have selected to have the design-time connection
the same as the run-time connection - I.E. we will be connected
to the web server whilst designing the pages.
7. Once you are satisfied, click OK.
You will now see your new connection in the Connections box, and
thus it will be available for use in your web pages.