mySQL & JDBC Driver Configuration

[Dino]

Currently working with JDBC connectivity to mySQL data tables and wanted to share my experience and configuration parameters. If anyone has questions regarding JDBC connectivity to mySQL, please feel free to ask. It would be great it others would share there experiences here. All the best from Prague, Dean.

Current set-up which works:

PDM SQL Plug-in (www.profdata.nl)

--------------------------------------------

mySQL = 3.23(www.mysql.com)

JDBC Driver = mm.mysql-2.0.8 (www.mysql.com)

ClassPath = C:mm.mysql-2.0.8;

FMPro Configuration:

SQL Driver = org.gjt.mm.mysql.Driver

SQL URL = jdbc:mysql://

--------------------------------------------

mySQL = 4.1.21(www.mysql.com)

JDBC Driver = mysql-connector-java-5.0.4 (www.mysql.com)

ClassPath = C:mysql-connector-java-5.0.4mysql-connector-java-5.0.4-bin.jar

FMPro Configuration:

SQL Driver = com.mysql.jdbc.Driver

SQL URL = jdbc:mysql://

Edited November 9, 2006 by Guest