Mark Gordon wrote: > I am just starting to mess around with sapdb. I have an > connection pool > that I use to manage connection to the database for web apps. This > connection pool connects to the database with the same userid > and password > for each connection in the pool. It seems that I can only > connect once > with my DOMAIN user. > > I get this error when it goes to connect the second time: > > ERROR SAP DBTech SQL: [-8022] User already connected > > How can I set the user up so that it may connect more then one time?
You did not check the docu or the archive, did you? In the docu (messages) it is written for error -8022 -8022: User already connected Explanation: A user attempts to connect to the database system under a user name which was defined with EXCLUSIVE in a <CREATE USER>, <CREATE USERGROUP>, <ALTER USER>, or <ALTER USERGROUP statement>. Another user has connected using this name. User Action: Wait until the other user has disconnected using a <RELEASE statement>. To enable a user to have various simultaneous connects, NOT EXCLUSIVE must be specified for this user with the <ALTER USER> or <ALTER USERGROUP statement>. These SQL statements may only be executed by the owner of the user or usergroup. And in the archives you could have found this info, too. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
