Bob
|
Posted: 05/31/2001, 2:16 PM |
|
Hi all,
I'm a 'brand new out of the box' CodeCharge newbie just checking
out the product for generating JSP code. So far looks great against
Oracle and MySQL ( which have ODBC divers) but since I cannot locate an
ODBC driver for InstantDb I think I may be out of luck for using
CodeCharge against InstantDb. True?
I'm saying this because of the 'Connection String' field in the
'Database' tab of the Properties wizard looking for a connection source.
Any comments appreaciated in advance!
Karen
|
|
|
CodeCharge
|
Posted: 05/31/2001, 11:50 PM |
|
OK. So you found one technology that we weren't able to cover :)
Well, until someone comes up with a ODBC or JDBC driver for InstantDb, there
is really not much we can do
"Bob" <b@b.com> wrote in message
news:MPG.1580636b95f6fba4989680@news.codecharge.com...
> Hi all,
> I'm a 'brand new out of the box' CodeCharge newbie just checking
> out the product for generating JSP code. So far looks great against
> Oracle and MySQL ( which have ODBC divers) but since I cannot locate an
> ODBC driver for InstantDb I think I may be out of luck for using
> CodeCharge against InstantDb. True?
> I'm saying this because of the 'Connection String' field in the
> 'Database' tab of the Properties wizard looking for a connection source.
>
> Any comments appreaciated in advance!
>
> Karen
|
|
|
Hellen
|
Posted: 06/01/2001, 12:47 AM |
|
Karen,
we haven't tested ODBC connection from CodeCharge to InstatntDB yet, but
we'll do it and keep you posting.
For now we can give the information how to connect to MySQL and Oracle
databases.
MySQL:
First of all you should install ODBC driver. It's available at : http://www.mysql.com/downloads/api-myodbc.html
Then using DataSource(ODBC) you should create DSN for MySQL db. More
information how to connect to MySQL db during design time you can get from
our tutorial: http://support.codecharge.com/tutorials/myodbc.html
For server part connection you should set up the next:
Connection string ==> jdbc:mysql://<host>/<database>
driver ==> org.gjt.mm.mysql.Driver
Oracle:
You should install Oracle Client. During installation check ODBC drivers to
be installed. Then run Net8 Easy Config application to create Service Name
for your Oracle db. The next step is to create DSN using DataSource(ODBC).
When all this done you can connect to Oracle db from CC during design part
the same way as to MySQL db.
For server part connection you should set up:
Connection string ==> jdbc:oracle:thin:@<host>:<port>:<service_name>
driver ==> oracle.jdbc.driver.OracleDriver
Regards,
CC Support
"Bob" <b@b.com> wrote in message
news:MPG.1580636b95f6fba4989680@news.codecharge.com...
> Hi all,
> I'm a 'brand new out of the box' CodeCharge newbie just checking
> out the product for generating JSP code. So far looks great against
> Oracle and MySQL ( which have ODBC divers) but since I cannot locate an
> ODBC driver for InstantDb I think I may be out of luck for using
> CodeCharge against InstantDb. True?
> I'm saying this because of the 'Connection String' field in the
> 'Database' tab of the Properties wizard looking for a connection source.
>
> Any comments appreaciated in advance!
>
> Karen
|
|
|
|