This content has been marked as final. Show 2 replies
I'm not familiar with DB2, but what was the procedure that you followed when you created the login for SADMIN?
Did you follow the same procedure for the new user?
Can you also execute a query when you use ODBCSQL with the new user?
See instructions on Supportweb: How Do You Test Connectivity Through ODBC Data Sources Created by Siebel? [ID 475610.1]
I think I know where the issue is.
When I was "Configure a new Enterprise in a Gateway Name Server",
I entered "SADMIN" as Current IBM DB2 SQL ID/Group Name instead of "SSEROLE" (default)
Also, during the "Database Configuration Wizard",
I entered "SADMIN" as Security Group ID/Grantee instead of "SSEROLE"
I will reinstall with SSEROLE and see what happens.