Lenny Sorey
|
| Posted: 08/28/2002, 8:31 AM |
|
Anyone got a complete explantation of how to use JDBC for MYSQL within CodeCharge?
JDBC Driver - org.gjt.mm.mysql.Driver
Database URL - jdbc:mysql://localhost/TCB
I place this information into the Connection properties section along with login info and password.
When I refresh I get the following error:
Data Source Name is not found and there is no specified default driver.
How do I set a path within CodeCharge to my jdbc driver.
i.e. D:\java\Tomcat41\common\lib\mm.mysql-2.0.14-bin.jar
Any examples out there that use JDBC with MYSQL and show how to set up?
Any help would be appreciated!!
Thanks,
Lenny
|
|
|
 |
WilliamB
|
| Posted: 08/28/2002, 9:21 AM |
|
You cannot use a JDBC connection within CodeCharge. JDBC drivers are used by Java programs and CodeCharge is not written in Java. As far as I know, the only way to connect to a MySQL database during design time is to install the MyODBC driver then create an ODBC DSN for the MySQL database. This DSN is what you use to connect CC to MySQL. Of course your server side connection can use the JDBC driver if you are generating in JSP.
|
|
|
|
|
