Connection to an Access Table Problem

[ktrinad]

By: jared fuhs - jayhuse

Connection to an Access Table Problem

2002-11-06 11:59

Hello, ok i have the parms set up in the data configuration within ireport, but when i try to do the test it gives me this error. Am i missing a parm setting or something ?

 

 

ava.lang.UnsatisfiedLinkError: sun/jdbc/odbc/JdbcOdbc.allocEnv Possible causes: If you are trying to use J/Direct (@dll.import), check your compiler version (for JVC, requires 4336 or greater.) If you are trying to use RNI, there are new requirements: see documentation.

at sun/jdbc/odbc/JdbcOdbc.allocEnv

at sun/jdbc/odbc/JdbcOdbc.SQLAllocEnv

at sun/jdbc/odbc/JdbcOdbcDriver.initialize

at sun/jdbc/odbc/JdbcOdbcDriver.connect

at java/sql/DriverManager.getConnection

at java/sql/DriverManager.getConnection

at com/businesslogic/ireport/ui/DBConnectionForm.buttonTest_click

at com/ms/wfc/core/EventHandler.invoke

at com/ms/wfc/core/Component.fireEvent

at com/ms/wfc/ui/Control.onClick

at com/ms/wfc/ui/Button.onClick

at com/ms/wfc/ui/Button.wndProc

at com/ms/wfc/ui/Control$ControlWindow.wndProc

at com/ms/wfc/app/Window.callback

at com/ms/wfc/win32/Windows.SendMessage

at com/ms/wfc/ui/Control.sendMessage

at com/ms/wfc/ui/Control.reflectMessage

at com/ms/wfc/ui/Control.wmCommand

at com/ms/wfc/ui/Control.wndProc

 

 

s

 

 

 

 

By: Giulio Toffoli - gt78

RE: Connection to an Access Table Problem

2002-11-06 14:08

Read the new tutorial:

http://ireport.sourceforge.net/tutorial3.html

 

giulio

 

 

 

 

By: jared fuhs - jayhuse

RE: Connection to an Access Table Problem

2002-11-06 14:31

Guilio, I have two machines, windows 95 appears to work ok with what you suggested but, the Windows 2000 professional addition for some reason gives me the error described above.

I do not think it is with my setting withing IReport, It might however be some of the libraries or something with the ODBC.

 

Any Ideas would be great ???

 

thanks

 

 

 

 

 

By: Giulio Toffoli - gt78

RE: Connection to an Access Table Problem

2002-11-06 14:42

Ah, I forgot.. the test with sun driver fails ever. It is not important. Save the connection as it is, without testing it.

 

Giulio

 

 

 

 

By: jared fuhs - jayhuse

RE: Connection to an Access Table Problem

2002-11-06 14:42

Taken Care of, Professional 2000 out of the box was pointing to some different libraries, thanks for you time thou !!

 

Jay

 

 

 

 

By: Giulio Toffoli - gt78

RE: Connection to an Access Table Problem

2002-11-06 14:44

Now works all?

 

 

 

 

By: Giulio Toffoli - gt78

RE: Connection to an Access Table Problem

2002-11-06 14:39

I have made this new tutorial on my Win2000 Professional...

The error talk about sun.jdbc.odbc.JdbcOdbcBridge and about Microsoft JVM. You MUST use com.ms.jdbc.odbc.jdbcOdbcBridge (the micosoft bridge) when you use wizard or query tool. The sun driver must be used only for compilation.

 

giulio

 

 

 

 

 

 

 

 

By: NoOneCare - pl88

RE: Connection to an Access Table Problem SOS

2003-09-25 15:08

I still had the same problem with ODBC/MS Access with different symptoms. My env is iReport 2.1/2.2+ JDK 1.4.2 +W2K. I have both sun ODBC (odbcjdbc.dll) and MS ODBC dll (msjdbc10.dll) in the JDK142/jre/bin. I tried sun ODBC/JDBC bridge in test connection works fine, but no data was NOT filled. The MS ODBC/JDBC bridge could not pass test connection, I got classpath problem.

 

However, everything works with SAP DB.

 

Any idea? I really hope to solve this problem so I can test iReport without my database server.

 

thanks in advance.