SAP BC to Sybase connection problem

[Maciej Gerke]

Hi,

I've been working with SAP Business Connector (v3.1) for some time and have
a question regarding
its connection to Sybase database (ASA 7.0.1). I configured SAP BC for
connecting by putting
additional classes of driver into server3/lib/classes directory. I use
JConnect5.2 and JRE 1.3.
There is a problem with connecting with remote db. When I use
pub.db.connect service it
still issues such dbMessage:

JZ00L: Login failed. Examine the SQLWarnings chained to this exception for
the reason(s).

User, I'm logging with, exists in database and there is no problem with
logging on remote server
by simple command-line JDBC application.

When using JRE 1.1.8 and JConnect4 pub.db.connect makes a connection but
query and select
services (delete on the other hand works!) have problems. Services still
want to select a column
that I did not specify in service parameters. SAP BC Server issues messages:

----------------------------------------------------------------------------
-------------------
java.sql.SQLException: S0022: Invalid column name 'name'.
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.tds.TdsResultSet.findColumn(TdsResultSet.java)
at com.sybase.jdbc.SybResultSet.findColumn(SybResultSet.java)
at com.sybase.jdbc.SybResultSet.getString(SybResultSet.java)
at
com.sybase.tds.RowFormatToken.getColumnTypeName(RowFormatToken.java)
at
com.wm.app.b2b.server.JDBCHelpers.resultSetToTable(JDBCHelpers.java:2
33)
at
com.wm.app.b2b.server.JDBCConnection.toValues(JDBCConnection.java:976
)
at
com.wm.app.b2b.server.JDBCConnection.execSQL(JDBCConnection.java:596)

at com.wm.app.b2b.server.DBConnection.execSQL(DBConnection.java:520)
at com.wm.app.b2b.server.DBConnection.query(DBConnection.java:430)
at pub.db.query(db.java:518)
at java.lang.reflect.Method.invoke(Native Method)
at
com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:224)
at
com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:330)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:96)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:230)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:279)
at com.wm.lang.flow.FlowState.stepIncremental(FlowState.java:262)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:192)
at wm.server.flow.stepFlow(flow.java:108)
at java.lang.reflect.Method.invoke(Native Method)
at
com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:224)
at
com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:330)
at
com.wm.app.b2b.server.HTTPInvokeHandler.process(HTTPInvokeHandler.jav
a:183)
at com.wm.app.b2b.server.HTTPDispatch.run(HTTPDispatch.java:172)
at com.wm.util.pool.PooledThread.run(PooledThread.java:103)
at java.lang.Thread.run(Unknown Source)

What is the problem? Has anybody any experience with connecting SAP BC to
Sybase?
Thanx for help in advance.

Maciej Gerke

BCC Poznan, Poland