Cannot attach to password Database

[Reto Carigiet]

Hi

i have an IB 6.0 Opensource Installation with Windows 2000 Server
and Windows 2000 Clients.

The Users have no rights on the client Machine, only to start the
application., on the server side the users can also acces the
directory with the *.gdb files.

Now, when i start the Delphi App who make an interbase connection,
i has the Error "Cannot attach to Password Database" and the program abort.

I work with the bde and ibx.

Which minimal rights need a user for accesing interbase correctly?

Thanks in advance
Reto Carigiet

[Sergio Bertolotti]

Reto Carigiet wrote:

Hi Reto,
What version of Delphi do you use ????
You must install the server verison of Interbase on the server win2000.
You must install ONLY the client on the other win2000 client PC.
I suggest to you to work with IBX. BDE it's not necessary for connet to IB
Server.
The default user that InterBase create is :

USER : SYSDBA
PASSWORD : masterkey

this is administrator of the server DB.
Which type of protocol do you use for connect to IB Server from your clients
???
Best regards and excuse me for my bad english.
****************************************
* Sergio Bertolotti
* Software consultant
* e-mail : sergio.b...@tin.it
****************************************

[Craig Stuntz [TeamB]]

Reto Carigiet wrote:

> i have an IB 6.0 Opensource Installation with Windows 2000 Server
> and Windows 2000 Clients.

Make sure you're using IB 6.0.1.6 or later.

> The Users have no rights on the client Machine, only to start the
> application., on the server side the users can also acces the
> directory with the *.gdb files.

Users have no need to read/write the directory containing the IB DB.
In fact, it's a security hole if they can. Only the process running IB
server needs permissions on this folder.

>
> Now, when i start the Delphi App who make an interbase connection,
> i has the Error "Cannot attach to Password Database" and the program
> abort.

Again, make sure you're using 6.0.1.6 or later. Also, check to be
sure there is only one copy of gds32.dll on client and server, and that
its version is identical to the server's.

-Craig

--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Performance Monitor -- Analyze and control your IB7
server: http://delphi.weblogs.com/IBPerformanceMonitor

[Reto Carigiet]

Hi, it was not an interbase problem, the server version is later than
6.0.1.6
and i changed gds32.dll but i had the same error message.

Then i gave my client application full access on the client program
directory,
and then it works.

Thanks for your help.
Reto Carigiet

"Craig Stuntz [TeamB]" <cst...@vertexsoftware.com> schrieb im Newsbeitrag
news:3f144996$1...@newsgroups.borland.com...

[Sergio Bertolotti]

Reto Carigiet wrote:

Hi Reto,
which type of protocol do you use to connect your client of IB ???
If you use TCP/IP the connection string is :

-- hostname/IPAddress:<PathOFDB> --

for example if your parameters is :

ServerNAme : SERVER2000
IPAddress : 192.168.1.1.
Path of DB on server : C:\DEMO\MYDB.GDB

for connect to server use this settings :

Remote connection parameter not local connection
192.168.1.1:C:\DEMO\MYDB.GDB
USERNAME : yourvalidusername
PASSWORD : yourvalidpassword
DIALECT : 1 or 3 (depend of your settings)
CHARSET : if you use this parameter

If you install a client of DB you must test connection with IBConsole tool -
select menu SERVER - COMMUNICATION DIAGNOSTICS.
Port of TCP/IP that IB Server and client use to communicate is 3050.
Best regards,

[Dave White]

"Sergio Bertolotti" <sergio.b...@tin.it> wrote in message
news:3f14...@newsgroups.borland.com...

> You must install ONLY the client on the other win2000 client PC.

Why?? I allways install the client and server on all client PCs, just
'cause I'm lazy and it means less options to uncheck during installation <G>
I've had no problems with this. In addition, my development machines MUST
have the vlient and server installed as I usually test new ideas with a
local copy of the database.

Dave White

[Sergio Bertolotti]

Dave White wrote:

Hi Dave,
for develop my application, I use a notebook with Interbase Server 6.0.2.0.
I install server and client on the same notebook.
Is the same if I have the Desktop version of Interbase Server, because the
DB and the client is locally, and I can develop and test my program locally
before install on the real server with a clients on the network.
I don't say that is impossible to install Interbase server and client on the
same PC, but is not reasonable.
Why I have to force my clients to running a InterBase server process in
memory for nothing ?
If you don't use a opensource version of InterBase Server for example 6.5 or
7.0 on all your PC on the network, how much do you pay your license for a
server and the relative clients ???
Why Borland have develop a Server and client version of Interbase ???