How to connect MSSQL to SAP BC on Linux

[andreas_laufer]

Hello Gurus,

I try to connect a MSSQL DB (located on an Win-VM) to a SAP BC 4.8 CoreFix7 on Linux SLES11.

SAP BC dies while testing the connection.

Her the steps I've done to connect the DB to SAP BC:

1. Inst. of unixODBC package

2. Inst. of Microsoft ODBC Driver 11 for SQL Server

3. Edit of /etc/unixODBC/odbc.ini

[Demo]

Description = MSSQL Datenbank Demo

Trace = Off

TraceFile = stderr

Driver = ODBC Driver 11 for SQL Server

SERVER = 1.1.1.1

USER = Demo

PASSWORD = mypasswd

PORT = 1433

DATABASE = Demo

4. in BC Database Adapter

     Alias:                  Demo

     DB URL:              jdbc:odbc:Demo

     DB Username:     Demo

     DB Password:     mypasswd

     DB Driver:            sun.jdbc.odbc.JdbcOdbcDriver

     Min Connctions:   1

     Max Connections: 10

     Expiration Time:    60000

     Test SQL:

     Loaded Drivers:     <None or new driver>

     --> Submit

In Alias Management select Demo --> Connect

In Service Generation no further entries --> Connect

After this BC dies with:

/sapbc/jvm/jre/lib/amd64/libJdbcOdbc.so: undefined symbol: SQLAllocEnv

Has someone a tip for me or a link to documentation?

Sorry, but I'm newbee with SAP BC

Best regards

Andreas

[Former Member · Accepted solution]

Please provide full version of jvm used.

[andreas_laufer · Accepted solution]

Hello Roman

JVM Version (SAP BC): 5.1.020

Andreas

[Former Member · Accepted solution]

Try to update your jvm to latest patch collection. Check the following SAP Notes:

1326869 - SAP JVM 5.1 Patch Collection 23 (build 5.1.032)

1249462 - How to import an SAP JVM patch into an SAP BC

[andreas_laufer · Accepted solution]

Hello Roman,

with new jvm connect to MSSQL works fine.

Thank you for support

Best regards

Andreas

[ACE-SAP]

Hi

To get answer you should post in the appropriate area =>

Regards