This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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