MS Access SAP MaxDB with ODBC Error -7778

[golo_maichel]

Hi,

I try to connect to a MaxDB Database via ODBCwith MS Access and I get always the error: reserved error -7778

The MaxDB is runing on a linux x64 Server (for Netweaver Portal 7.01) and has the version:

SAP DB (KERNEL 7.7.07 BUILD 015-123-229-754)

X-Server is also running on the server.

I connect from my local PC (Windows XP 32bit) from MS Access and tried the following DSNs and get always the same error:

[ODBC]

DRIVER=SAP DB 7.4

UID=SUPERDBA

SERVERDB=EQ1

SERVERNODE=XX.XX.XX.XX (I tried with IP-Adress and Servername, both accesible form my PC)

[ODBC]

DRIVER=SAP DB

UID=SUPERDBA

SERVERDB=EQ1

SERVERNODE=XX.XX.XX.XX

[ODBC]

SAP DB (Unicode)

UID=SUPERDBA

SERVERDB=EQ1

SERVERNODE=XX.XX.XX.XX

On my PC the MaxDB Client Software ist installed (RDBMS_MAXDB_7.7.04_Build_28 for X86 32 bit)) and the ODBC drivers are properly registered.

Please can anyone help me in this case?

[Former Member]

Hi,

I guess you use a ODBC file DSN. MS Access could not connect to ODBC driver registered as file data soure. Use a system or user data source instead.

Microsoft technical bulletin Q172347 discusses the problem.

Burkhard