aspose file tools*
The moose likes JDBC and the fly likes How to set up a DSN? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to set up a DSN?" Watch "How to set up a DSN?" New topic
Author

How to set up a DSN?

cardwell cupp
Ranch Hand

Joined: Aug 16, 2001
Posts: 66
Is it possible to make a DSN to an database that is on another server/host?
If so how?
THanks in advance!
Cardwell
venugopal askani
Greenhorn

Joined: Aug 20, 2001
Posts: 16
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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to set up a DSN?