AW: Problems connection to a secured DB via Client/Server-Driver [NVG-MSW51-SPAM-Content]

[Mi...@nuernberger.de]

Thank you Andrew,

I checked it out, but the same error occured.


-----Ursprüngliche Nachricht-----
Von: Andrew McIntyre [mailto:mcintyre.a@gmail.com] 
Gesendet: Freitag, 13. Oktober 2006 15:45
An: Derby Discussion
Betreff: Re: Problems connection to a secured DB via Client/Server-Driver [NVG-MSW51-SPAM-Content]

On 10/13/06, Mirko.Zieroth@nuernberger.de <Mi...@nuernberger.de> wrote:
>
> I did the following steps:
> 1. Open a commandline window and starting the Networkserver
>         D:\db-derby-10.2\bin>startNetworkServer.bat
>         Server is ready to accept connections on port 1527.
>
> 2. Open a second commandline window and starting ij
> 3. Connecting to the db
> H:\>ij
> IJ Version 10.2
> ij> connect
> 'jdbc:derby://localhost:1527/e:/derbydbs/tests/testdb;user=admin;password=password';
> FEHLER 08004: Connection authentication failure occurred.  Reason: userid or
> password invalid.

Just a guess without consulting the docs, but I think that the client
doesn't consider 'e:' to be a valid part of the database URL. Try:

in D:\db-derby-10.2\bin:

set DERBY_OPTS=-Dderby.system.home=e:\derbydbs\tests
startNetworkServer.bat

and then in ij:

connect 'jdbc:derby://localhost:1527/testdb;user=admin;password=password';

HTH,
andrew

Hinweis:
Der Inhalt dieser E-Mail ist ausschließlich für den bezeichneten Empfänger bestimmt und kann vertrauliche Informationen enthalten. Wenn Sie nicht der Empfänger dieser E-Mail oder dessen Vertreter sind, dann senden Sie bitte die E-Mail an den Absender zurück (Antwort-Funktion bzw. reply email). Entfernen Sie bitte danach die Nachricht aus Ihrem System.
This e-mail message including any attachments may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, please immediately return this e-mail message to the sender by reply e-mail, delete the original message and destroy all copies thereof.
MSW 5.1