PDA

View Full Version : Connection to sybase anywhere database



marcus.cavalcanti
03-06-2006, 03:02 PM
Hi,

I'm a new user in pentaho, I have used the mondrian software in the past but now I'm trying to migrate to the pentaho BI solution.
As my first test, I installed the demo solution and I'm trying to customize one of the actions, making it conect to my sybase anywhere database using JDBC for ODBC driver.

I have added to my jndi.properties the following lines :

Multipla/type=javax.sql.DataSource
Multipla/driver=sun.jdbc.odbc.JdbcOdbcDriver
Multipla/url=jdbc:odbc:MULTIPLA
Multipla/user=BYTEC
Multipla/password=BYTEC

and changed the SQL_Datasouce.xaction file in the action part as I show above :












org.pentaho.component.SQLLookupRule
rule

Multipla






I have already restarted the jboss and that doesn't resolve the problem.

Can you help me where is my error ?

Thanks in advance,

Marcus. http://forums.pentaho.org/archived_att/files/Document.txt

marcus.cavalcanti
03-06-2006, 03:03 PM
I have attached the action file, because the text in the last interaction got truncated. http://forums.pentaho.org/archived_att/files/SQL_Datasource.xaction