Hitachi Vantara Pentaho Community Forums
Results 1 to 15 of 15

Thread: Connection to MS SQL using ODBC

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Connection to MS SQL using ODBC

    Hello Everyone,

    I am trying to create database connection to MS SQL using ODBC and getting the following error (see below)

    Could anybody give me a hint on what I am doing wrong?

    Also we are running MS SQL 2008 server, can I connect to it using JDBC or JNDI?

    Thank you,
    Alex


    Error connecting to database [test] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    It looks like your ODBC name you are using is not specified in your Windows. The ODBC DNS Source Name must be identical is your Windows ODBC name

    And yes, you can use JDBC or JNDI

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you johanhammink! You were right, before using ODBC DNS, I have to specify ODBC DNS data source!

    So that is what I did. Now I have a question. Every time I need to put data in my MS SQL database I have to go administrative tools and specify ODBC DSN data source for every database on the server. It does not sound too difficult, but I wonder if there is a short cut: such as providing SQL server address instead?

    Thank you,
    Alex

  4. #4
    Join Date
    Nov 2008
    Posts
    777

    Default

    Quote Originally Posted by august_month View Post
    ...but I wonder if there is a short cut: such as providing SQL server address instead?
    Using ODBC has its limitations. For the option you seek (and for better performance) you should consider using a JDBC driver.

    http://sourceforge.net/projects/jtds/
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  5. #5
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you!

  6. #6
    Join Date
    Sep 2011
    Posts
    171

    Default

    Is there any kind of tutorial on how to set up JDBC connection to MS SQL server? I am getting the following error. ( left TCP/IP unchanged)

    Error connecting to database [JDBCTest] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Exception while loading class
    com.microsoft.sqlserver.jdbc.SQLServerDriver


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Exception while loading class
    com.microsoft.sqlserver.jdbc.SQLServerDriver


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:374)
    at org.pentaho.di.core.database.Database.connect(Database.java:323)
    at org.pentaho.di.core.database.Database.connect(Database.java:285)
    at org.pentaho.di.core.database.Database.connect(Database.java:275)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6611)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Exception while loading class
    com.microsoft.sqlserver.jdbc.SQLServerDriver

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:429)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:358)
    ... 39 more
    Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:420)
    ... 40 more

    Hostname : 10.1.144.11\OOIDATA001
    Port : 1433

  7. #7
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by august_month View Post
    Exception while loading class
    com.microsoft.sqlserver.jdbc.SQLServerDriver
    From what I recall this indicates that it couldn't find the JAR file for this connection.
    Try using the MS SQL Server rather than MS SQL Server (Native)

    MS SQL Server (Native) uses the Microsoft driver, MS SQL Server uses jTDS (an open source, and therefore redistributable, library)

  8. #8
    Join Date
    Sep 2011
    Posts
    171

    Default

    I am getting the same error: Is it possible to point to jar file? I also downloaded JDBC driver from Microsoft server



    Error connecting to database [JDBCTest] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '10.1.144.11\OOIDATA001'.


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '10.1.144.11\OOIDATA001'.


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:374)
    at org.pentaho.di.core.database.Database.connect(Database.java:323)
    at org.pentaho.di.core.database.Database.connect(Database.java:285)
    at org.pentaho.di.core.database.Database.connect(Database.java:275)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6611)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '10.1.144.11\OOIDATA001'.

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:358)
    ... 39 more
    Caused by: java.sql.SQLException: Unknown server host name '10.1.144.11\OOIDATA001'.
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:401)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490)
    ... 40 more
    Caused by: java.net.UnknownHostException: 10.1.144.11\OOIDATA001
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
    at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)
    ... 45 more

    Hostname : 10.1.144.11\OOIDATA001
    Port : 1433
    Database name : TestIRISStaginTables

  9. #9
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by august_month View Post
    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    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.

    One of the "better practices" with PDI is to use variables and populate the kettle.properties file

    If your Kettle Properties file has lines that read:
    OOIDATA-HOST=10.1.144.11
    OOIDATA-DB=OOIDATA001
    OOIDATA-USER=myusername
    OOIDATA-PASS=Encrypted <Gibberish> (See the usage for Encr.bat for more info!)

    Then you can configure all your connections that go to this DB using variables (ie in the hostname box, put ${OOIDATA-HOST} )
    If the DB name or the Host IP change for any reason (eg. you are running the same type of transform from two hosts, one of which has a NAT in the way, the IP can be different for the two hosts, while the transform remains the same)

    Even better still is to use JNDI, but that's a topic for a whole other set of posts.
    Last edited by gutlez; 09-28-2011 at 03:13 PM.

  10. #10
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you, gutlez!

    I tried updating kettle.properties, but now I get the following error: I assumed that kettle.properties loads when I launch Spoon.bat. Is this correct or do I need to load kettle.properties separately?

    Regards,
    Alex


    Error connecting to database [JDBC] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '${OOIDATA-HOST}'.


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '${OOIDATA-HOST}'.


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:374)
    at org.pentaho.di.core.database.Database.connect(Database.java:323)
    at org.pentaho.di.core.database.Database.connect(Database.java:285)
    at org.pentaho.di.core.database.Database.connect(Database.java:275)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6611)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '${OOIDATA-HOST}'.

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:358)
    ... 39 more
    Caused by: java.sql.SQLException: Unknown server host name '${OOIDATA-HOST}'.
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:401)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490)
    ... 40 more
    Caused by: java.net.UnknownHostException: ${OOIDATA-HOST}
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
    at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)

  11. #11
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    So lets start back at walking and then work up to running

    In your DB config box, put in your hostname (or IP) in the host name box, user name etc, and let's get it working there first... once we have that working, then we can work on getting your properties file set up and working.

  12. #12
    Join Date
    Sep 2011
    Posts
    171

    Default

    ok, here is what I get when I choose MY SQL and JDBC (native) and IP 10.1.144.11\OOIDATA001

    Error connecting to database [JDBC] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '10.1.144.11\OOIDATA001'.


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '10.1.144.11\OOIDATA001'.


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:374)
    at org.pentaho.di.core.database.Database.connect(Database.java:323)
    at org.pentaho.di.core.database.Database.connect(Database.java:285)
    at org.pentaho.di.core.database.Database.connect(Database.java:275)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6611)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Unknown server host name '10.1.144.11\OOIDATA001'.

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:358)
    ... 39 more
    Caused by: java.sql.SQLException: Unknown server host name '10.1.144.11\OOIDATA001'.
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:401)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490)
    ... 40 more
    Caused by: java.net.UnknownHostException: 10.1.144.11\OOIDATA001
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
    at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)
    ... 45 more

    Hostname : 10.1.144.11\OOIDATA001
    Port : 1433
    Database name : TestIRISStagingTables

  13. #13
    Join Date
    Sep 2011
    Posts
    171

    Default

    And here is what I get, if I try 10.1.144.11


    Error connecting to database [JDBC] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Login failed for user 'sviridap'.


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Login failed for user 'sviridap'.


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:374)
    at org.pentaho.di.core.database.Database.connect(Database.java:323)
    at org.pentaho.di.core.database.Database.connect(Database.java:285)
    at org.pentaho.di.core.database.Database.connect(Database.java:275)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6611)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Login failed for user 'sviridap'.

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:510)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:358)
    ... 39 more
    Caused by: java.sql.SQLException: Login failed for user 'sviridap'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
    at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490)
    ... 40 more

    Hostname : 10.1.144.11
    Port : 1433
    Database name : TestIRISStagingTables

  14. #14
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by august_month View Post
    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Login failed for user 'sviridap'.
    We are getting closer! This says that it's talking to the DB server on your host, but that it didn't like your username / password combination.

    Question: Do you use DB authentication, or Windows authentication?

    Can you take a screenshot of your database configuration window?

  15. #15
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you, again!

    I lost my mind. I have different name and password for the DB connection.

    It worked!

    Sorry!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.