dsn less connection to an Access database

[Tarab Hussain]

Hi,

Is there a way to do a DSN-less connection to an Access database in Java?

Thanks

[william huang]

"Tarab Hussain" <tarabhussain@hotmail.com> wrote:
>
>Hi,
>
>Is there a way to do a DSN-less connection to an Access database in Java?
>
>Thanks

I dont think it is possible to have a DSN-less connection to Access DB in
java. First, Access does not run and listen for remote connections. Also
the JDBC-ODBC bridge does not support remote access to DB. So if you have
a program that is running on a remote host, or on Linux, Unix, you won't
be able to connect to the remote MS-Access database. If you have a solution
please let me know.

[Paul Clapham]

I don't think the original question was about databases in a remote
computer. It was about databases that are not registered as an ODBC data
source. And of course there is a way to connect to these databases: use a
driver that doesn't go via ODBC.

PC2

"william huang" <whuang04@yahoo.com> wrote in message
news:3b211f57$1@news.devx.com...
>
> "Tarab Hussain" <tarabhussain@hotmail.com> wrote:
> >
> >Hi,
> >
> >Is there a way to do a DSN-less connection to an Access database in Java?
> >
> >Thanks
>
> I dont think it is possible to have a DSN-less connection to Access DB in
> java. First, Access does not run and listen for remote connections. Also
> the JDBC-ODBC bridge does not support remote access to DB. So if you have
> a program that is running on a remote host, or on Linux, Unix, you won't
> be able to connect to the remote MS-Access database. If you have a
solution
> please let me know.
>