This week's book giveaway is in the Design forum.
We're giving away four copies of Mastering Non-Functional Requirements and have Sameer Paradkar on-line!
See this thread for details.
Win a copy of Mastering Non-Functional Requirements this week in the Design forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Code to creat a Data Source  RSS feed

 
Aran King
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 732
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!