Jdk 1.2 or above
Microsoft SQL SERVER 2005 or above clients.
Steps for using JDBC - ODBC Bridge using Microsoft SQL SERVER 2005.
1)Create a DSN(User) with same name that is listed in jdbc uri.
Go to control panel --> Administrative tools --> Click Data Source(ODBC)
2) Click on Add and Select SQL SERVER (which is the last 1 in the list)
3)Click on finish. You will get the following dialog box.
I.)Enter DSN name in the Data Source Name text filed(this is most Important because You'll use just like Database name)
II.)Description is not mandatory(not used)
III.)To Enter Server of SQL Copy the SERVER name from Microsoft SQL Server 2005
IV.)AND Paste It in the Server DropDown List filed.
V.)Then Click NEXT
VI.) again Click NEXT
VII.)Select The CheckBoX
And Most Important Select The DATABASE You Want to
USE like I used HOTEL my Data Base in this Example.
For EX. You have database User
But whatever the Database You choose,You'll refer It with the DSN name you have given.
In this Example "User" is given as DSN name
VIII.) click the **NEXT** AND then Click Finish
IX.) A dialog Box Will appear like this
X.) click on Test Data Source
Result should be like this
