-
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
-
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
-
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
>
>
-
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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|