Hello, the option MAXUSERTASKS I found myself and it's from the beginning set to an appropriate value. This exclusive option was probably something that I have missed to read.
Thanks Peter > -----Urspr�ngliche Nachricht----- > Von: Schroeder, Alexander [SMTP:[EMAIL PROTECTED] > Gesendet am: Dienstag, 19. August 2003 08:33 > An: H�bschen, Peter; Mailingliste SAPDB (E-Mail) > Betreff: RE: ODBC-Call for <DB-Name> failed > > Hello Peter, > > There are two kinds of limits that may apply. > > First, make sure that the user is NOT EXCLUSIVE. > (see > http://www.sapdb.org/7.4/htmhelp/48/f0daa5225811d3a97d00a0c9449261/content > .htm ) > Users are created by default in EXCLUSIVE mode, if nothing else is > specified. > If your user seems, to be EXCLUSIVE, use > > ALTER USER username NOT EXCLUSIVE > > to lift that restriction. > > Second (not very probable in this case) there is a database parameter > MAXUSERTASKS > that defines the maximum number of parallel sessions that the database > will handle. > > Regards > > Alexander Schr�der > SAP DB, SAP Labs Berlin > > > -----Original Message----- > > From: "H�bschen, Peter" [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, August 19, 2003 8:10 AM > > To: Mailingliste SAPDB (E-Mail) > > Subject: ODBC-Call for <DB-Name> failed > > > > > > Hello all, > > > > is there any limitation how many simultanous sessions a > > single user can open > > and how can I change this (I didn't find a possibility to change)? > > > > I'm asking this, because I've been run into the same error a > > lot of times in > > different circumstances. I'm using Access 97 as frontend and > > if I open for > > example two objects (one connection and one database object) > > I get the error > > 'the ODBC-Call for <MyDB> failed'. I'm also running into the > > same problem if > > I open a bound form (the tables are linked) which has one/some unbound > > combo-boxe(s) which are filled through SQL-statements. Or I > > have open a > > bound form and I try to open a linked table. Or if I tried to export 2 > > Access tables to SAP-DB it always failed on the second table. > > I had to close > > and reopen my database for every table I wanted to export. > > I forgot to mention, before I get the ODBC-Call error, the > > ODBC-driver Input > > form pops up. > > > > I think it's SAPDB related, since I can't open a > > SQL-Studio-Session, if I > > have Access open and the tables linked. > > > > Regards > > Peter > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
