Jdbc Odbc remote database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Jdbc Odbc remote database

Hybrid View

  1. #1
    Nikhil Guest

    Jdbc Odbc remote database


    Hi,
    can anybody tell me how to connect to a remote database( MS Access) from
    Java jdk1.3 using jdbc-odbc driver?

    Thanx in advance,
    Nikhil

  2. #2
    Paul Clapham Guest

    Re: Jdbc Odbc remote database

    I'd set up ODBC to connect to the remote database. But "How do I set up
    ODBC to connect to a remote database" is not exactly a question about the
    Java JDK, is it?

    PC2

    "Nikhil" <mamo_nil@hotmail.com> wrote in message
    news:3b17656e$1@news.devx.com...
    >
    > Hi,
    > can anybody tell me how to connect to a remote database( MS Access) from
    > Java jdk1.3 using jdbc-odbc driver?
    >
    > Thanx in advance,
    > Nikhil




  3. #3
    Nikhil Guest

    Re: Jdbc Odbc remote database


    Paul, Thanx for your response. In a small sentence my question is ..
    1) Say My java applcation is running in the machine x1.x2.x3.x4
    2) I would like to connect to a MS-Access database which is in the machine
    y1.y2.y3.y4
    3) I create a DSN in the second machine y1.y2.y3.y4 to Map to the databse.
    then what the exact url I can use in DriverManager.getConnection() method.

    I had tried with jdbc.odbc.//y1.y2.y3.y4/MyDSN, jdbc.odbc.@y1.y2.y3.y4:MyDSN.
    But neither of these working properly. I am getting error:

    [Microsoft][ODBC Driver Manager] Data source name not found and no default
    driver specified

    I hope the question is clear.
    Cheers,
    Nikhil

    "Paul Clapham" <pclapham@core-mark.com> wrote:
    >I'd set up ODBC to connect to the remote database. But "How do I set up
    >ODBC to connect to a remote database" is not exactly a question about the
    >Java JDK, is it?
    >
    >PC2
    >
    >"Nikhil" <mamo_nil@hotmail.com> wrote in message
    >news:3b17656e$1@news.devx.com...
    >>
    >> Hi,
    >> can anybody tell me how to connect to a remote database( MS Access) from
    >> Java jdk1.3 using jdbc-odbc driver?
    >>
    >> Thanx in advance,
    >> Nikhil

    >
    >



  4. #4
    Rajkamal Guest

    Re: Jdbc Odbc remote database


    Hi Nikhil

    if you are using ODBC databases, information about ISAM,RDBMS or Jet Engine
    Based Databases are specified in the properties of the DSN

    To set the properties of DSN you should probably write a Native function.
    Regards

    Rajkamal

    "Nikhil" <mamo_nil@hotmail.com> wrote:
    >
    >Paul, Thanx for your response. In a small sentence my question is ..
    >1) Say My java applcation is running in the machine x1.x2.x3.x4
    >2) I would like to connect to a MS-Access database which is in the machine
    >y1.y2.y3.y4
    >3) I create a DSN in the second machine y1.y2.y3.y4 to Map to the databse.
    > then what the exact url I can use in DriverManager.getConnection() method.
    >
    >I had tried with jdbc.odbc.//y1.y2.y3.y4/MyDSN, jdbc.odbc.@y1.y2.y3.y4:MyDSN.
    >But neither of these working properly. I am getting error:
    >
    >[Microsoft][ODBC Driver Manager] Data source name not found and no default
    >driver specified
    >
    >I hope the question is clear.
    >Cheers,
    >Nikhil
    >
    >"Paul Clapham" <pclapham@core-mark.com> wrote:
    >>I'd set up ODBC to connect to the remote database. But "How do I set up
    >>ODBC to connect to a remote database" is not exactly a question about the
    >>Java JDK, is it?
    >>
    >>PC2
    >>
    >>"Nikhil" <mamo_nil@hotmail.com> wrote in message
    >>news:3b17656e$1@news.devx.com...
    >>>
    >>> Hi,
    >>> can anybody tell me how to connect to a remote database( MS Access)

    from
    >>> Java jdk1.3 using jdbc-odbc driver?
    >>>
    >>> Thanx in advance,
    >>> Nikhil

    >>
    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center