Sign the database in odbc

Discussion in 'Java' started by kobzarev, Dec 3, 2005.

  1. kobzarev

    kobzarev Guest

    Hello ALL.

    I write program, using MS Acess Database with odbc:jdbc
    .............................................................................................
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    consq = DriverManager.getConnection("jdbc:eek:dbc: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
    kobzarev, Dec 3, 2005
    #1
    1. Advertising

  2. kobzarev

    Ben_ Guest

    Did you create a User DNS or a System DSN ?
    Ben_, Dec 3, 2005
    #2
    1. Advertising

  3. kobzarev

    kobzarev Guest

    No.
    "Ben_" <> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
    news:43915c66$0$441$...
    > Did you create a User DNS or a System DSN ?
    >
    >
    kobzarev, Dec 3, 2005
    #3
  4. kobzarev

    Ben_ Guest

    But, what did you configure in the Control Panel then ?
    Ben_, Dec 3, 2005
    #4
  5. kobzarev

    kobzarev Guest

    ODBC...And in ODNC I sign for the Acess Driver the Path and name of my
    database
    kobzarev, Dec 3, 2005
    #5
  6. kobzarev

    kobzarev Guest

    I configures User DSN.... I don't see it -(. User DSN in ODBC
    kobzarev, Dec 3, 2005
    #6
  7. kobzarev

    Hal Rosser Guest

    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
    Hal Rosser, Dec 4, 2005
    #7
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Giuseppe D'Elia

    Error with ASP.NET opening OleDb/ODBC database

    Giuseppe D'Elia, Jul 15, 2003, in forum: ASP .Net
    Replies:
    2
    Views:
    1,425
    John Toop
    Jul 25, 2003
  2. Jimmy
    Replies:
    1
    Views:
    932
    Cowboy \(Gregory A. Beamer\)
    Nov 21, 2006
  3. Wes Gamble
    Replies:
    1
    Views:
    159
    Gerardo Santana Gómez Garrido
    Apr 5, 2006
  4. Jimmy
    Replies:
    3
    Views:
    2,393
    shimmyshack
    Nov 20, 2006
  5. Shiuh-Lin Lee
    Replies:
    6
    Views:
    197
    Thomas 'PointedEars' Lahn
    Feb 4, 2010
Loading...

Share This Page