aspose file tools*
The moose likes JDBC 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
Bookmark "Code to creat a Data Source" Watch "Code to creat a Data Source" New topic
Author

Code to creat a Data Source

Aran King
Greenhorn

Joined: Dec 10, 2001
Posts: 4
Hi
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
 
 
subject: Code to creat a Data Source
 
Similar Threads
Hibernate - Database IP changes daily
Connect to MySql with JDBC
how to set the the URL of database directly from the database.properties file
Servlet action is not available
Oracle JDBC connection using JNDI lookup