Here is my question,
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