Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)

117 views

beginner

Skip to first unread message

higi nugrasjati

unread,

Mar 13, 2014, 10:21:26 PM3/13/14

to penta...@googlegroups.com

Saya ingin me-lookup data yg sumbernya dari Ms Access (OS Ubuntu 12.04 64Bit)

Saya sudah membuat setting ODBC dengan melakukan konfigurasi di

odbc.ini

[MASTER00]

Description = Microsoft Access Try DB

Driver = MDBTools

Database = /home/higi/mabs/MASTER00.MDB

Servername = localhost

Username =

Password =

port = 5432

dan odbcinst.ini

[MDBTools]

Description = MDBTools Driver

Driver = /usr/lib/x86_64-linux-gnu/odbc/libmdbodbc.so.1

Setup =

FileUsage = 1

UsageCount =

Dan ketika mengetikan perintah

isql MASTER00

Hasilnya Connected

Kemudian saya membuat koneksi di pentaho..

MS Access - ODBC

ODBC DSN Source Name = MASTER00

Ketika test connection muncul error

Error connecting to database [MS00] : 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)

at org.pentaho.commons.launcher.Launcher.main (Launcher.java:134)

at java.lang.reflect.Method.invoke (Method.java:601)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:57)

at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)

at org.pentaho.di.ui.spoon.Spoon.main (Spoon.java:567)

at org.pentaho.di.ui.spoon.Spoon.start (Spoon.java:6968)

at org.pentaho.di.ui.spoon.Spoon.readAndDispatch (Spoon.java:1183)

at org.eclipse.swt.widgets.Display.readAndDispatch (null:-1)

at org.eclipse.swt.widgets.Display.runDeferredEvents (null:-1)

at org.eclipse.swt.widgets.Widget.sendEvent (null:-1)

at org.eclipse.swt.widgets.EventTable.sendEvent (null:-1)

at org.eclipse.swt.widgets.TypedListener.handleEvent (null:-1)

at org.pentaho.di.ui.spoon.Spoon$24.widgetDefaultSelected (Spoon.java:5275)

at org.pentaho.di.ui.spoon.Spoon.access$1900 (Spoon.java:310)

at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree (Spoon.java:2792)

at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection (SpoonDBDelegate.java:88)

at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open (DatabaseDialog.java:62)

at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open (XulDatabaseDialog.java:115)

at org.pentaho.ui.xul.swt.tags.SwtDialog.show (SwtDialog.java:304)

at org.pentaho.ui.xul.swt.tags.SwtDialog.show (SwtDialog.java:378)

at org.eclipse.jface.window.Window.open (Window.java:796)

at org.eclipse.jface.window.Window.runEventLoop (Window.java:820)

at org.eclipse.swt.widgets.Display.readAndDispatch (null:-1)

at org.eclipse.swt.widgets.Display.runDeferredEvents (null:-1)

at org.eclipse.swt.widgets.Widget.sendEvent (null:-1)

at org.eclipse.swt.widgets.EventTable.sendEvent (null:-1)

at org.eclipse.swt.widgets.TypedListener.handleEvent (null:-1)

at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected (SwtButton.java:119)

at org.pentaho.ui.xul.swt.tags.SwtButton.access$500 (SwtButton.java:26)

at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke (AbstractXulComponent.java:123)

at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke (AbstractXulComponent.java:139)

at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke (AbstractXulDomContainer.java:329)

at java.lang.reflect.Method.invoke (Method.java:601)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:57)

at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)

at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection (DataHandler.java:533)

at org.pentaho.di.core.database.DatabaseMeta.testConnection (DatabaseMeta.java:2464)

at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport (DatabaseFactory.java:86)

at org.pentaho.di.core.database.Database.connect (Database.java:269)

at org.pentaho.di.core.database.Database.connect (Database.java:279)

at org.pentaho.di.core.database.Database.connect (Database.java:317)

at org.pentaho.di.core.database.Database.normalConnect (Database.java:352)

at org.pentaho.di.core.database.Database.connectUsingClass (Database.java:490)

at java.sql.DriverManager.getConnection (DriverManager.java:243)

at java.sql.DriverManager.getConnection (DriverManager.java:579)

at sun.jdbc.odbc.JdbcOdbcDriver.connect (JdbcOdbcDriver.java:153)

at sun.jdbc.odbc.JdbcOdbcDriver.initialize (JdbcOdbcDriver.java:453)

org.pentaho.di.core.exception.KettleDatabaseException: