Hi Steffen, jep, your recommended command "use user dba dba serverdb adb on dev-srv" works, but gives the same error message about establishing a connection using shared memory.
ERR -25004 A connection to the database could not be established: 1 = could not create comm. shared memory [5]. and right, dbm is a DBM user, so i tried with a DBA user now. thanks for that hint too. but: if i connect to the server db from a remote machine using the very same statement and the dba user then i could connect successfully. only from local there occurs the problem with shared memory... unfortunately, i need some other hint, some very, very important hint for a specific task ;-) (there's another thread on the mailinglist: Database migration from ASCII to UNICODE) i'm not able to export data from an ASCII db and import it into a fresh UNICODE db. meanwhilest i worked around this problem with setting up a new UNICODE db instance and created the whole db schema and master data from our countless sql scripts on our development and integration servers, but if we want to go live with the application at our clients sites then we have to export/import the databases as there are lots of production data ... thx so far! Mit freundlichen Grüßen / Kind regards, Chris Jölly Unycom Information Technology Services GmbH Solutions for Intellectual Property Management Tel.: +43-316-818 818-30 > -----Ursprüngliche Nachricht----- > Von: Schildberg, Steffen [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 19. April 2007 18:43 > An: Chris Jölly > Betreff: AW: Starting loadercli: could not connect to db > > > Hi Chris, > > Chris Jölly [mailto:[EMAIL PROTECTED] wrote: > > Gesendet: Donnerstag, 12. April 2007 15:03 > > An: maxdb@lists.mysql.com > > Betreff: Starting loadercli: could not connect to db > > > > > > i want to execute loadercli on a db server running windows 2003 > > and get the following error: > > > > D:\MaxDB\sdb\programs\bin>loadercli -u dbm,dbm -n dev-srv -d adb > > Loader Server Protocol: 'C:\Documents and > > Settings\adm\Application Data\sdb\loader\log\loader.prt' > > > > Error connecting user DBM to database ADB on dev-srv: -25004 > > A connection to the database could not be established: 1 = > > could not create comm. shared memory [5]. > > > I can't say right now where this error comes from. I'll check this and > get back to you asap. > > > > > if i start loadercli with the -n dev-srv parameter and then > > use USE USER to establish a > > connection the following error displays: > > > > loadercli>USE USER dbm dbm DB adb > > ERR -25281 > > Syntax error at position 18 (Unexpected keyword: DB). > > > Change the command to: > USE USER dbm dbm SERVERDB adb on dev-srv > > and it'll run. But I expect the same error as above. > BTW, is your user dbm the real > database manager user? If so this one is not allowed to use any other > tool than DBMCLI or DBMGUI. You should either use the > database administrator > user or another database user to work with loadercli. > Otherwise the next error > will be: > "Error connecting user DBM to database <db name> on <host > name>: -25005 > User (DBM) logon to database <db name> failed: SQL error > -4008 = Unknown > user name/password combination (error position: 1)" > > Regards, > Steffen > -- > Steffen Schildberg > MaxDB Team > SAP Labs Berlin > http://www.sdn.sap.com/irj/sdn/maxdb > > Sitz der Gesellschaft/Registered Office: Walldorf, Germany > Vorstand/SAP Executive Board: Henning Kagermann > (Sprecher/CEO), Léo Apotheker (stellvertretender > Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard > Oswald, Peter Zencke > Vorsitzender des Aufsichtsrats/Chairperson of the SAP > Supervisory Board: Hasso Plattner > Registergericht/Commercial Register Mannheim No HRB 350269 > > Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder > sonstige vertrauliche Informationen enthalten. Sollten Sie > diese E-Mail irrtümlich erhalten haben, ist Ihnen eine > Kenntnisnahme des Inhalts, eine Vervielfältigung oder > Weitergabe der E-Mail ausdrücklich untersagt. > Bitte benachrichtigen Sie uns und vernichten Sie die > empfangene E-Mail. Vielen Dank. > > This e-mail may contain trade secrets or privileged, > undisclosed, or otherwise confidential information. If you > have received this e-mail in error, you are hereby notified > that any review, copying, or distribution of it is strictly > prohibited. Please inform us immediately and destroy the > original transmittal. Thank you for your cooperation. > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
