Design-Time Same as Run-Time Connection

 

1. Now, in UltraDev, with your page open, you need to click MODIFY>CONNECTIONS and then click NEW.

 

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 known).

 

4. Now cut and paste the connection string we made earlier into the String box.

 

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.

 

<<Back