Db Multiuser And Local Connection

M

matoriz

New Member
Hi to all of you!!

I am new in this foro and I want to ask for the first time, I hope you can give me some trick....

I serverd my DB in Multiuser mode in a win2000 server and my users connect by using Terminal Server Connection so I have differents session at the same server.... how should I have to connect localy my application ?
I serve using:
c:\dlc91a\bin\_mprosrv.exe c:\cvda2\dbs\cvda.db -n 15

I connect using:
CONNECT -db C:\CVDA2\DBS\CVDA.DB. (this does not work)

Thank you for your help.

 
matoriz said:
Hi to all of you!!

I am new in this foro and I want to ask for the first time, I hope you can give me some trick....

I serverd my DB in Multiuser mode in a win2000 server and my users connect by using Terminal Server Connection so I have differents session at the same server.... how should I have to connect localy my application ?
I serve using:
c:\dlc91a\bin\_mprosrv.exe c:\cvda2\dbs\cvda.db -n 15

I connect using:
CONNECT -db C:\CVDA2\DBS\CVDA.DB. (this does not work)

Thank you for your help.
Click to expand...

If the session is on the same machine as the server then, instead of connecting with a CONNECT string, you can start local sessions with the database name:

Code: 
c:\dlc91a\bin\prowin32.exe c:\cvda2\dbs\cvda.db -p startupProcedure

If you want a character session use _progres.exe instead of prowin32.exe.

If the session is not on the same machine then you need to start the server with a service name using the -S serviceName parameter. The clients then need to use -H hostName and -S serviceName on either their command lines or in their CONNECT strings to find that service.
 
Thank you Tom, this works fine.... but in the same session, if an user connect with an other session this one have an error "there is not server for this database" so I have to configure mi server (I think so) or find a solution to serve my database for all sessions. If you know how do ti please give me a tip.

Thak you for all, u´r expert !
 
If I understand your problem then I think what you need to do is start your server in mulit-user mode (as you already do) with an additional -S serviceName parameter. You then need to add -H hostName and -S serviceName in the client CONNECT strings.

You may also need to adjust Windows security to permit access to the network stack.

If I've misunderstood and you're trying to start windows self-service sessions then you probably need to set ACCESS=all on the service.
 
Re: Db Multiuser And Local Connection (SOLUTION)

Hi Tom, thank you for your help, I used your tips and I have resolved.... I served my db using:

c:\dlc91a\bin\_mprosrv.exe c:\cvda2\dbs\cvda.db -S valles -n 15

and in my services file: (c:\winnt\system32\drivers\etc\services) put

valles 1930/tcp #Servicio de Progress Valle

so I call the connection in my programs using:

CONNECT -db cvda -N TCP -S valles -H 192.168.XX.XX NO-ERROR.

Now each session connects without problems in the same server.

Thank you.
 
You must log in or register to reply here.
Back
Top