• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Dreamweaver MX for Applicati... > Create a Connection with a Data Sour...

Create a Connection with a Data Source Name

To send or retrieve data from a data source, you must open a connection with that data source through Dreamweaver. The first type of connection you'll be connecting to is called a Data Source Name, or DSN. Data sources come in different formats, such as graphics files. A database created by Access is a different type of file than a database created by Oracle or FileMaker Pro. To offer a variety of applications to access different data sources, the Open Database Connectivity standard was developed. Open Database Connectivity, commonly referred to as ODBC, is a universal language that all databases speak. With the appropriate drivers installed for the particular database, the application has the capability to read and write information to and from the database.

Windows systems already have the appropriate drivers installed for Access, SQL Server, dBase, Oracle, FoxPro, Excel, and Paradox. If you're developing with a Macintosh, you will normally connect to the ODBC driver that resides on the testing server.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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