There is no server for database obf.db

Posted by Admin on 24-Apr-2010 09:09

im trying to build a network based application, but i didn't know to connect using multi-user mode in appbuilder.

anyone who know what can i do?

thanks in advance.

All Replies

Posted by Admin on 24-Apr-2010 09:21

but i didn't know to connect using multi-user mode in appbuilder.

Are you asking how to connect to a server or how to start a server?

Is your database on the same machine as the AppBuilder will be running or on a different machine/different platform?

Posted by Admin on 24-Apr-2010 21:36

same machine as my appbuilder running.

i want to establish a client server program.

how can i do that?

thanks.

Posted by Admin on 25-Apr-2010 03:36

same machine as my appbuilder running.

i want to establish a client server program.

how can i do that?

thanks.

From the OpenEdge program group in your start menu choose the "proenv" script. That opens a windows shell with the required environment set.

Switch to the folder in which your database resides and type:

preserve -S 12345

That will start a dabase server listening for connections on part 12345.

Then from the AppBuilder connect database dialog, connect to the database using the file open dialog and the "multiple users" toogle checked in the Options portion of that dialog.

Posted by Admin on 25-Apr-2010 06:21

 got trouble about proenv.

how to switch to the folder?

im using cd command.

but still "proenv".

when im type "preserve -S 12345"

it say "preserve" in not recognized as an internal or external command, operable command or batch file.

how can i fixed this?

thanks again and sorry im newbie in this progress.

Posted by Admin on 25-Apr-2010 06:31

Sorry my fault. Try "proserve" instead of "preserve".

CD is the right command to switch to the folder, the prompt will always show proenv. (you may change the prompt with the prompt command when it's important for you)

Posted by Admin on 25-Apr-2010 06:31

And don't forget the db name as a parameter to proserve.

Posted by Admin on 25-Apr-2010 06:46

thanks, you help me a lot..

i hope you can help me again if i found any problem in my program.

thanks again.

God Bless.

Posted by Admin on 25-Apr-2010 06:56

For the long turn you might as well check the PDF docu for the

OpenEdge Explorer, a tool that allows you to launch DB's

automatically. From your screenshot I could see that you're on 10.2B

where OEE is available by default.

Posted by Admin on 25-Apr-2010 21:32

got another problem.

i can't connect my client to my server?

what should i do?

i thought file sharing is enough.

but its a big mistake.

anyone who can help me to solve my problem?

thanks in advance.

Posted by Admin on 26-Apr-2010 01:51

Progress is not MS Access :-) So file sharing is not suitable for a multi-user connection.

From the command line add

-db obf -H -S 12345

From the procedure editor:

Connect obf -H -S 12345

In the AppBuilder connection dialog enter the IP address of the DB server in the hostname field, obf as the database name and 12345 as the port number or service name.

Posted by Admin on 26-Apr-2010 04:09

got trouble to the 2nd pc.

connecting to the server..

command line means proenv?

connecting using procedure editor : "could not connect to server for database obf,errno 10060."

i have 2 pc..

pc1 for the server where

i open the proenv

and switch my folder then i type the proserve obf.db -S 12345

pc2 for my client where

i type proserve -db obf -H 192.168.1.100 -S 12345

(192.168.1.100) is the ip address of the server.

when im in procedure editor running the connect obf -H 192.168.1.100 -S 12345

i got an error, could not connect.

how can i fixed this error?

thanks.

Posted by Admin on 26-Apr-2010 04:16

how can i fixed this error?

Training?

pc2 for my client where

i type proserve -db obf -H 192.168.1.100 -S 12345

(192.168.1.100) is the ip address of the server.

when im in procedure editor running the connect obf -H 192.168.1.100 -S 12345

i got an error, could not connect.

 

On the second PC don't use proserve, as that would (try to) start a server. Proserve needs to be run on the server.

On the second PC, try

prowin32 -db odf -H 192.168.1.100 -S 12345

Posted by Admin on 26-Apr-2010 04:22

sir i got same error.

i have a screen shot on my pc2..

Posted by Admin on 26-Apr-2010 04:26

sir i got same error.

Firewall issue?

Posted by Admin on 26-Apr-2010 04:42

i turn off my firewall.

then i tried again,

new error was pop

THERE IS NO SERVER ACTIVE FOR THE DATABASE OBF ON -H 192.168.1.100 -S 12345. (704)

i have a screen shot sir.

Posted by Admin on 26-Apr-2010 06:15

sir mike.

i tried fixing my problem

but same error was pop.

i have a screen shot of what i've done.

please tell me where i got wrong?

thanks.

Posted by Admin on 26-Apr-2010 06:26

please tell me where i got wrong?

It's usually hard to guess everything a beginner may do wrong remotely. A consultant or trainer on site is usually a very effective way of starting...

For the current issue, it looks like you did start the server (proserve) using a lower case -s parameter. Progress startup parameters ARE case sensitive. Try starting the server (proserve) using a upper case -S 12345 instead.

To do so you'll first have to shut down the database server process:

proshut -by obs

Posted by Admin on 26-Apr-2010 09:03

no active server?

Posted by Admin on 26-Apr-2010 09:11

no active server?

Ok. Sometimes I helps to read the output of commands that you run...

"This server is licensed for local logins only." (4393)

Wou only have development server licenses, not a workgroup or enterprise server license. A workgroup or enterprise server license is required to run client/server.

Posted by Admin on 26-Apr-2010 09:18

sir it means i need to buy or  download free trial?

no another option?

thanks

Posted by kevin_saunders on 27-Apr-2010 02:46

No, there is no other option. The minimum license you require for client/server is a 5 user workgroup databse server.

Posted by Admin on 07-Aug-2010 15:09

sir. i got another problem accessing the server..
i have 2 client, my first cleint connect successfully but the other one says "tbl was used by client1, wait or choose cancel"..

what should i do..

i configure may server like this "proserve -db obf.db -H AREKUSHISU -S 12345"..

where i got wrong?

thanks in advance..

i got a screen shot of my 2 client..

Posted by Admin on 07-Aug-2010 15:15

i have 2 client, my first cleint connect successfully but the other one says "tbl was used by client1, wait or choose cancel"..

Answered here: http://communities.progress.com/pcom/message/100972#100972

This thread is closed