Sign the database in odbc

Thread view:

kobzarev - 03 Dec 2005 07:52 GMT

Hello ALL.

I write program, using MS Acess Database with odbc:jdbc
............................................................................................
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
consq = DriverManager.getConnection("jdbc:odbc:MS Access");
smt = consq.createStatement();
............................................................................................
But it begin work only after signing in (WinXP) ControlPanel ->
Administrator -> ODBC -> I sign the path to my database and sign the name of
database (E:\WordGame\ADB.mdb).
How can I automatically sign it? I don't want to do this every time I run it
on another computer.
________________________
Kobzarev_Ivan
berje@yandex.ru

Reply to this Message

Ben_ - 03 Dec 2005 08:50 GMT

Did you create a User DNS or a System DSN ?

Reply to this Message

kobzarev - 03 Dec 2005 10:29 GMT

No.

> Did you create a User DNS or a System DSN ?

Reply to this Message

Ben_ - 03 Dec 2005 11:41 GMT

But, what did you configure in the Control Panel then ?

Reply to this Message

kobzarev - 03 Dec 2005 11:51 GMT

ODBC...And in ODNC I sign for the Acess Driver the Path and name of my
database

Reply to this Message

kobzarev - 03 Dec 2005 11:56 GMT

I configures User DSN.... I don't see it -(. User DSN in ODBC

Reply to this Message

Hal Rosser - 04 Dec 2005 00:51 GMT

To be able to move the application to another computer, you should look at
"DSN-LESS" connections to the database. Its the best way to go.
(I heard you could make a File dsn, then open it in a text editor and use
that info to make your DSN-less connection.)
Try googling with 'dsn-less' and java.
That way you do not need a DSN.

HTH

Reply to this Message

Sign the database in odbc

Free Magazines