The moose likes JDBC and Relational Databases and the fly likes Code to creat a Data Source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Code to creat a Data Source" Watch "Code to creat a Data Source" New topic

Code to creat a Data Source

Aran King

Joined: Dec 10, 2001
Posts: 4
I am using an Access database for an application and I am wanting to make it as easy to set up on a windows machine as possible
Is there any way to set up a data source for a database using code instead of having to go to control panel and set it up manually.
any pointers much appreciated
Thanks Aran
Roy Ben Ami
Ranch Hand

Joined: Jan 13, 2002
Posts: 732
when u create a database in windows (like u do in access) you use the control panel thingie to describe a DSN which is just a name to refer to that database.
in most databases there is an option to use somthn called DSN-less connection that dont require u to set the DSN (but are mor complicated).
however access cant have a dsn-less connection so u have to do that thing in control panel (no other way).
for other databases visit this link
I agree. Here's the link:
subject: Code to creat a Data Source
It's not a secret anymore!