• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Connecting to Data Sources

With a well-designed data source at the ready, you’re prepared to establish a connection to it from your Web application. You can achieve a connection in several ways, depending on the application server in use. Typically, application servers offer several alternative routes to establishing a connection. One method might be easier to set up but not quite as efficient, whereas the other might be more difficult to create but more robust. It’s good to know what the options are so that you can decide which type of connection is best in a given situation.

Making ASP Connections

Although there are some variations, ASP connections occur in one of two ways: either through a Data Source Name (DSN) or through a connection string. Although the DSN connection is easier to set up, it does have somewhat of an impact on the performance of the application server. Connection strings are, in general, more robust but also require more detailed information, such as a precise path to the data source on the server.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint