Defining A Connection in Dreamweaver MX
In order to start using data in your Dreamweaver MX pages, you need to define a connection for DMX to use. You need to literally tell DMX about your database. It's like introducing a new friend to an old one. In the Application panel group, you can find the Databases panel.
This window will probably be empty unless you have defined a connection before. Click the plus icon, and choose Data Source Name.
Enter a name for your connection. I've started mine with "conn" to remind me that it's a connection, and not any other sort of data when I come to use it later.
I've already set up my ODBC Data Source Name, so I make sure that it's the selected option, and then select my DSN from the list.
I don't need a Username or Password (you'll know if you do), so I'll click Test to test the connection...
That's what we like to see! We're all set now to start building dynamic, data driven pages. Click OK to finalize your settings.