How to set up a DSN?

Is it possible to make a DSN to an database that is on another server/host?
If so how?
THanks in advance!
Cardwell

Hi Cardwell,
If you are working on a Windows Environment, follow the following steps.
1. Click on the start menu
2. Go to control Panel
3. Click on ODBC.
4. Click on System DSN. ( i mean select the System DSN tab)
5. Click on Add button.
6. Select the driver suitable for the database to which u r connecting else contact ur administrator and find out. Generally its user friendly, u can use Oracle driver for Oracle, SQL Driver for SQL server or what ever database you have installed on ur machine or the server. I want to clarify is that you have to install the Oracle client on your machine if you wish to connect to Oracle.
7. Give a friendly name for the DSN name and then give the properties. Then you are done creating a DSN.
If you need to create a DSN that is dependent on the User who logs in you need to create a 'User DSN' else this System DSN will create for all users irrespective of login.
Hope i clear all your queries. Else you can visit http://msdn.microsoft.com and search on DSN.
Regards
Askani

Originally posted by cardwell cupp:
Is it possible to make a DSN to an database that is on another server/host?
If so how?
THanks in advance!
Cardwell