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
