dreamweaver jdbc_conn - 达人(未来)

2004/09/21 | dreamweaver jdbc_conn
类别(java) | 评论(0) | 阅读(71) | 发表于 11:48: Using JDBC connections

Macromedia Dreamweaver UltraDev recognizes many standard JDBC drivers. When a driver is recognized, it becomes accessible in the driver pop-up menu in the Connections dialog box. The recognition of JDBC drivers varies between the Windows and Macintosh platforms. Connection strings and drivers will vary depending upon the database. Please check the database vendor documentation for specific connection strings and driver information. Several examples of JDBC connections are listed below.

Windows:
Dreamweaver UltraDev on the windows platform has a folder named JDBCDrivers. Most drivers placed in this folder will be recognized by UltraDev. Drivers located in the system CLASSPATH will also be recognized. values can be added to the CLASSPATH system variable as follows:
1 On the NT desktop, right-click the 'My Computer' icon to access the context menu. Select Properties from the pop-up menu. Then, select the Environment tab.

The Environment tab appears:

2 In the System Variables list, select the CLASSPATH variable if it exists. If the CLASSPATH variable doesn't exist, select any other variable.

3 In the Variable text box, make sure CLASSPATH appears. If you selected another variable in step 2 above, delete its name and enter CLASSPATH.

Note: The initial variable will be unaffected and will continue to be listed in System Variables.

4 In the value text box, enter the path to the driver.

Note: If the CLASSPATH variable already exists, place a semicolon at the end of the the path. Next, append the new path after the semicolon.

Note: Dreamweaver UltraDev must be restarted for driver recognition to occur.

Macintosh:
Dreamweaver UltraDev will recognize most standard JDBC drivers when they are placed in the MRJ classpath. The path is typically Hard Drive: System Folder: Extensions: MRJ Libraries: MRJ Classes:. After placing a driver in the MRJ Classes folder, it is necessary to restart the system in order for it to recognize the JDBC drivers.

Windows/Macintosh - JDBC Connections:
For more information on Windows JDBC connections, search for JDBC drivers on the Sun Web site, or contact the database vendor for a JDBC driver.
When connecting on the Macintosh platform, most type 4 JDBC drivers can be used instead of the RMI JDBC driver.

Sun JDBC-ODBC Bridge
Note: To use this driver, you must first install the JSP update.
Type: JDBC

Driver: sun.jdbc.odbc.JdbcOdbcDriver

URL: JDBC:ODBC:pubs

URL Format: JDBC:ODBC:[data source name]

MS JDBC-ODBC Bridge
Note: To use this driver, you must first install the JSP update.
Type: JDBC

Driver: com.ms.jdbc.odbc.JdbcOdbcDriver

URL: JDBC:ODBC:dsn=pubs;UID=Ingmar;PWD=Bergman;

URL Format: JDBC:ODBC:dsn=[data source name];UID=[user name];PWD=[password];

Oracle Thin Driver
Type: JDBC

Driver: oracle.jdbc.driver.OracleDriver

Username: Orson

Password: Welles

URL: jdbc:oracle:thin:@192.255.132.46:1521:orcl

URL Format: jdbc:oracle:thin:@[host]:[port]:[database]

Inet Driver
Type: JDBC

Driver: com.inet.tds.TdsDriver

Username: Alfred

Password: Hitchcock

URL: jdbc:inetdae:192.234.21.47:1433?database=pubs

URL Format: jdbc:inetdae:[host]:[port]?database=[database]

RMI JDBC
Type:JDBC

Driver: RmiJdbc.RJDriver

Username: Charlie

Password:Chaplin

URL: jdbc:rmi://mothra.macromedia.com/jdbc:odbc:ScaalCoffee

URL Format: jdbc:rmi://[host]/jdbc:odbc:[data source name]

MySQL
Type:JDBC

Driver: org.gjt.mm.mysql.Driver

Username: David

Password:Cronenberg

URL: jdbc:mysql://192.234.21.47:3306/test

URL Format: jdbc:mysql://[host]:[port]/[database]

UDB/DB2
Type:JDBC

Driver: COM.ibm.db2.jdbc.net.DB2Driver

Username: db2admin

Password:db2pass

URL: jdbc:db2//machine_name/SAMPLE

URL Format: jdbc:db2://[host]:[port]/[database]

Pervasive
Type:JDBC

Driver: com.pervasive.jdbc.v2.Driver

Username: username

Password:the-password

URL: jdbc:pervasive://machine-name:1583/Demodata

URL Format: jdbc:pervasive://[host]:[port]/[database]

www.macromedia.com/support/ultradev/ts/documents/jdbc_conn.htm; 0

http://fuguotao.5d.cn/

评论Comments