Hi,
when I try to login into BaaN for some User the following message is comming

Fatal error : Error 5064 (bdb_errno 5064) on SELECT
Can not continue in ottstpstdlib (mess)

How I solve the problem . Please suggest me



Regards
Amitabha Sarkar
MERINO PANEL PRODUCTS LTD.

amitabhaa2003@yahoo.co.in

Errors > 1000 are database errors. Take 1000 to the error nr. and you get your DB error code (this is valid for any database).

So for your case, Baan DB error 5064 is MSSQL error 4064 = "Cannot open user default database. Login failed.", so check that user settings in the database.

The problem can be any one of the below reasons.
1. Check your database owner. Your database owner may be different than a group user.
Ex. If your group user is 'baandb' then your database name should be baandb. If you go to users in Baandb database, there will be one user called 'dbo'. This should associated with 'baandb' login.
If it is different, you can change it with stored procedure 'sp_changedbowner'
2. Your group user password in SQL server may be different in SQL server in compared to the %BSE/lib/msql/msql_groups file.
If this is different, you can login to Baan, but you will get this error anytime when you create/delete table from Baan.

Please see the event viewer, it will give correct message.

Hope this helps.

I know this is an old post but I often rely on this board to assist be with problems and so thought I should post this in case anyone else experiences the same problem as I have.

victor_cleto is correct with this one. You will find that if you open MS SQL Enterprise Manager, go to Security, go to Logins. Look at the default database for the user which is trying to access BaaN - the default database for the user is blank. Right click on the user and choose properties, specify the default database for the user and you should now find the user is able to login.

Regards
Chris_kzn