How to connect SQL anywhere 11 with JDBC?

[former_SQLA_member1694930]

Please help me to connect ASA anywhere 11.0.0 to JDBC. I need to use SAP Lumira BI. They have to be connected via JDBC.

Please help me with step by step procedure.

Really appriciate.

[former_SQLA_member1694930]

Thank you Chris,

I have read the link, but I still can not connect my ASA 11.0.0 to SAP Lumira (BI). SAP Lumira did not provide connection to ASA 11.0.0, So I choose JDBC Generic connection

Can you please kindly help me where to type:

1. Path

set classpath=%classpath%;install-dir\\java\\jodbc.jar

1. load driver

DriverManager.registerDriver( (Driver) Class.forName( "ianywhere.ml.jdbcodbc.jdbc3.IDriver").newInstance() );

1. Suply a URL to the driver

Connection con = DriverManager.getConnection( "jdbc:ianywhere:DSN=SQL Anywhere 11 Demo" )

Please help me out...I can not upload any image, because my point is not enough.

Thank you very much for your reply..Really appriciate that..

Best regards,

Hasan

[chris_keating]

I do not have any experience with SAP Lumina. But a quick web search shows that the generic driver setup is reasonably easy. It appears that you are prompted to supply the JAR file of the JDBC driver. You will also need the other supporting files in the path (i.e., the SA BIN32 or BIN64 drirectory depending on the bitness of the Java being used) if you are using the SQL Anywhere JDBC driver - it has native components. You will then see a dialog asking for the class and url which are described above.

You do not need a DSN so you can simple provide a connection string. If you are not sure how to setup a connection string, we can help with that on this forum. The basic premise is:

ENG=<your_db_engine_name>;DBN=<database_name>;UID=<user_id>;PWD=<password>

If you have not already started the database engine and database, you can add

DBF=<your_database_filepath>

This will autostart a standalone server.

If you have more specific questions about this, you will want to raise those in support or in the SAP Community Network for Lumina.

[VolkerBarth]

See also Jason Hinsperger's answer here from today, it tells that SQL Anywhere is a pre-defined data source with Lumira...

[chris_keating]

There are two JDBC options that can be used - The SQL Anywhere JDBC driver which is not a pure java and jConnect which is pure-Java. To learn more, read SQL Anywhere JDBC driver.