Home page
or browse popular tags
ASP Tutorial

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?


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.


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

  • Comments

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