Jdbc Odbc remote database

[Nikhil]

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

[Paul Clapham]

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

[Nikhil]

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
>
>

[Rajkamal]

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
>>
>>
>