Home » 2015 » January » 5 » How to create ODBC data source and drivers to connect to Oracle or sql server database

4:48 PM
How to create ODBC data source and drivers to connect to Oracle or sql server database

Here in this article we shall learn to create ODBC data sources that will be used as drivers in connecting to databases like oracle or sql servers.

Click here to see how to create data source for oracle database in control panel.

 

After this is done, you will be able to use this data source in your front end program(Java, VB.net etc). Click here to see the JDBC connectivity if you have already created data source.

To create a data source, Go to Control Panlel--> Administrative Tools and then click on Data sources.

 

  • Then, click on add Button to add a data source.
  • Now from the list select a driver for which you want to set up a data source.
  • Here, we will select Microsoft ODBC for Oracle.

  • Then, Click on Finish.
  • Now, on the next dialog, enter the data source name of your choice.

Now, Click OK and close the windows, You will see the new data source is created as shown in below image:

image

This is it! Now you can use this database driver in your front end program(Java, VB etc)

Click here to see how to create data source for oracle database in control panel.

 

 

 
 

Category: Technical Solution | Views: 1113 | Added by: shanky | Tags: create data sources for oracle, creating data source in control pan, how to create data source driver fo | Rating: 0.0/0

Related blogs


You may also like to see:


[2014-02-02][Technical Solution]
Difference between an Application server and web server
[2014-09-30][Technical Solution]
How to give a global url to an HTML page? How to create a website with custom url?
[2014-11-28][Technical Solution]
Problem Step Recorder(PSR). How to use it?
[2014-02-06][Technical Solution]
tzutil time zone utility to set time zone of the computer using command line
[2022-07-24][Technical Solution]
How to handle Criticism at work? An Insight by Mark Goulston (Harvard's Business review article)

Total comments: 0
avatar