ODBC converts the commands defined in the client application to the queries understood by the database like SQL.
SQL is used to create queries to manipulate the data stored in a database. Step 5: Define your default database and click Next. Step 4: Give your DSN a Name and Server name/IP address and click Next. Step 3: Select the corresponding ODBC driver for which you wish to set up a data source and Click Finish. Unknown server host name '10.1.144.11\OOIDATA001'.It's finding and loading the JAR, but your DB config isn't set up right - somehow it's taking 10.1.144.11\OOIDATA001 as the host name, where you want it to be 10.1.144.11. ODBC provides data types and functions that help applications to interact with the database. Step 2: Select Add under the User DSN tab.
Download the SQL Server ODBC driver for your DG4ODBC platform.
These instructions show you how to install the SQL Server driver and create and test an ODBC data source. Unknown server host name '10.1.144.11\OOIDATA001'.Īt .(Database.java:510)Ĭaused by: : Unknown server host name '10.1.144.11\OOIDATA001'.Īt .ConnectionJDBC2.(ConnectionJDBC2.java:401)Īt .ConnectionJDBC3.(ConnectionJDBC3.java:50)Īt .nnect(Driver.java:184)Īt (Unknown Source)Īt .(Database.java:490)Ĭaused by: : 10.1.144.11\OOIDATA001Īt (Unknown Source)Īt (Unknown Source)Īt (Unknown Source)Īt .SharedSocket.createSocketForJDBC3(SharedSocket.java:307)Īt .SharedSocket.(SharedSocket.java:257)Īt .ConnectionJDBC2.(ConnectionJDBC2.java:311) To access SQL Server from Oracle, we used our SQL Server ODBC driver to set up the prerequisite ODBC connection. I am getting the same error: Is it possible to point to jar file? I also downloaded JDBC driver from Microsoft serverĮrror connecting to database: (using class .Driver) :Īt .(Database.java:374)Īt .(Database.java:323)Īt .(Database.java:285)Īt .(Database.java:275)Īt .(DatabaseFactory.java:76)Īt .(DatabaseMeta.java:2455)Īt .ui.test(DatabaseDialog.java:109)Īt .ui.test(CreateDatabaseWizard.java:157)Īt .ui.$3.widgetSelected(CreateDatabaseWizard.java:146)Īt .TypedListener.handleEvent(Unknown Source)Īt .ndEvent(Unknown Source)Īt .ndEvent(Unknown Source)Īt .nDeferredEvents(Unknown Source)Īt .Display.readAndDispatch(Unknown Source)Īt .nEventLoop(Window.java:820)Īt .Window.open(Window.java:796)Īt .ui.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)Īt .ui.(Spoon.java:6611)Īt 0(Native Method)Īt (Unknown Source)Īt (Unknown Source)Īt .invoke(Unknown Source)Īt .(AbstractXulDomContainer.java:329)Īt .(AbstractXulComponent.java:139)Īt .(AbstractXulComponent.java:123)Īt .access$100(SwtMenuitem.java:27)Īt .$1.widgetSelected(SwtMenuitem.java:77)Īt .ui.(Spoon.java:1169)Īt .ui.(Spoon.java:6940)Īt .ui.(Spoon.java:553)Īt .Launcher.main(Launcher.java:134)Ĭaused by: .:Īt .(Database.java:429)Īt .(Database.java:358)Ĭaused by: : .SQLServerDriverĪt $1.run(Unknown Source)Īt (Native Method)Īt (Unknown Source)Īt (Unknown Source)Īt 0(Native Method)Īt (Unknown Source)Īt .(Database.java:420) ( left TCP/IP unchanged)Įrror connecting to database : .:Įrror occured while trying to connect to the databaseĬom. Is there any kind of tutorial on how to set up JDBC connection to MS SQL server? I am getting the following error.