Create an odbc connection – Adobe Dreamweaver CS3 User Manual
Page 531
DREAMWEAVER CS3
User Guide
524
Although it is adequate for development use with lower-end database systems such as Microsoft Access, the Sun
JDBC-ODBC Bridge driver is not intended for production use. For example, it lets only one JSP page connect to the
database at a time (it does not support concurrent use by multiple threads). For more information on the driver’s
limitations, see TechNote 17392 on the Adobe support center at
.
After you install the bridge driver, you can create the database connection.
Create an ODBC connection
Before connecting through an ODBC driver, make sure the appropriate ODBC driver and the Sun JDBC-ODBC
Bridge driver are installed on the Windows computer running the JSP application server.
1
Define a DSN on the Windows system hosting your application server.
For instructions, see the following articles on the Microsoft website:
•
Windows 2000 users, see Microsoft Knowledge Base Article 300596 at
•
Windows XP users, see Microsoft Knowledge Base Article 305599 at
2
Open a JSP page in Dreamweaver, and then open the Databases panel (Window > Databases).
3
Click the Plus (+) button on the panel, and select Sun JDBC-ODBC Driver (ODBC Database) from the menu.
4
Enter a name for the new connection, without spaces or special characters.
5
Replace the
[odbc dsn]
placeholder in the URL box with the DSN you defined in step 1. The URL box should
look like this:
jdbc:odbc:myDSN
6
Specify the user name and password to access the database.
If you don’t need a user name or password, leave the boxes blank. For example, if your DSN is called Acme and you
don’t need a user name or password to access the database, enter the following parameter values:
Driver:
sun.jdbc.odbc.JdbcOdbcDriver
URL:
jdbc:odbc:Acme
7
Specify the location of the JDBC-ODBC Bridge driver.
•
If the driver is installed on the same computer as Dreamweaver, select Using Driver On This Machine.
•
If the driver is not installed on the same computer as Dreamweaver, select Using Driver On Testing Server.
Note: Macintosh users can ignore this step because all database connections use the application server.
8
Click Test, and then click OK.
Dreamweaver attempts to connect to the database. If the connection fails, double-check the DSN and the other
connection parameters. If the connection still fails, check the settings for the testing folder Dreamweaver uses to
process dynamic pages.
See also
“Set up a testing server” on page 48
“Troubleshooting database connections” on page 525
September 4, 2007