MS-Access conection through SAPDB toMiniwas - authentication error

[marcel_janssen]

Hi Experts,

I'm trying to establish a ODBC connection from MSACCESS to My MiniWas.

I have installed SAPDB 7.4.3.23 and ODBC74.

When I try to connect to the Database I get an authorization failure>

I've tried:

user-id = control

pw = control (like stated in the SAP-DB documentation)

I even also created a new DB-administrator within SAPDB. - still to luck

Even still I get the following error:

[SAP AG][SQLOD32DLL][SAP DB]Invalid authorization specification:; -4008 POS(1) Unknown user name/password combination. (#-4008)

Within SAPDB I do have access with user control & password control.

Previously I used ODBC-linking on MiniSAP (with MSDE server). There I had no problems at all

Who can help me out?

Many thanks in advance.

Marcel

[roland_mallmann]

Hi Marcel,

the control user (=DBM user) is not an SQL user. You should use a SQL enabled user, the DBA user for example. I take it you used the default for the DBA user too, which should then be named 'superdba'. I suggest you try this user.

Regards,

Roland

Message was edited by: Roland Mallmann

[marcel_janssen]

Hi Roland,

May thanks for your info. I'm a little further now, but still no success. Please take into account I'm a complete newby related to SAPDB.

I managed now to get into xuser (with user SAPR3 and pw SAP).

There I find the following users with their parameters:

USERKEY : DEFAULT

USERID : SAPR3

PASSWORD :

repeat passw :

SERVERDB : BSP

SERVERNODE :

SQLMODE : SAPR3

CACHELIMIT : -1

TIMEOUT : 0

ISOLATION : 0

DBLOCALE :

USERKEY : c

USERID : CONTROL

PASSWORD :

repeat passw :

SERVERDB : BSP

SERVERNODE :

SQLMODE : INTERNAL

CACHELIMIT : -1

TIMEOUT : -1

ISOLATION : -1

DBLOCALE :

USERKEY : w

USERID : SUPERDBA

PASSWORD :

repeat passw :

SERVERDB : BSP

SERVERNODE :

SQLMODE : INTERNAL

CACHELIMIT : -1

TIMEOUT : -1

ISOLATION : -1

DBLOCALE :

With all of these users I remain getting teh same authorization errors, when connecting to ODBC (and also when connecting with SQL-studio.

What am I overseeing?

Many thanks,

Marcel

[roland_mallmann]

Hi Marcel,

can you try the following from the commandline:

<b>dbmcli -d <DBNAME> -u control,<pw></b>[hit Enter]

You'll then be presented with a DBMCLI-session:

<b>dbmcli on <DBNAME>></b>

From there, try to connect with both your DBA and SAP user, for example:

<b>dbmcli on <DBNAME>>sql_connect superdba,<pw></b>

If you get the -4008 error here, then you've specified a wrong password. Are you sure you know the passwords?

Hope that helps.

Regards,

Roland