Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
ASP Tutorial
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

How to set up a system DSN?

Print

This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine. To do that you need to follow a couple of steps:

Open the 'ODBC Data Source Administrator'
( Start -> Control Panel -> Administrative Tools -> Data Sources ) 

Flip to the System DSN tab

Click Add...

In the box that will appear you should select the Microsoft Access driver and click Finish

Type in a name that is easily remembered and relevant to your database in the 'Data Source Name' textbox

Click Select and browse to your local database file

Click OK all the way out

You have now created a DSN which will come in handy when you try to connect and retrieve information from your database.




Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.