martinpg2001
New Member
Hi, I am reasonably new to Progress, and have two related questions about running a secondary login broker. Here's the situation: I am running Progress 10.2B on Windows 2003 Server, and I want to expose it as an ODBC datasource. I can start the Progress Server using the command line:
>proserve database
I then start the secondary login broker using either:
>proserve QAProgress1 -S 9999 -m3
or
>proserve -pf odbcstartup.pf (contents of odbcstartup.pf I give below)
This is all well and good, but if I log out of the Windows machine, then the ODBC server seems to go down. So my basic question is: can I start the ODBC server in such a way that it runs as a service?
I'm pretty sure the answer is yes, but the problem I'm having is that the documentation seems to rely on the using the Progress Explorer tool, and being able to access a folder called ODBC DataServer in it. For example: "double-click the ODBC DataServer folder".
So, can anyone help me configure the Progress Explorer tool so that this folder is present? Alternatively, is there some way to start an ODBC server at the command line so that it starts as a service?
One tantalizing reference is to a Support article P7243 (or something similar) but I can't find the document on the Progress Support site.
Thanks for any help, Martin
Contents of odbcstartup.pf:
# This is my ODBC startup file.
-db E:\OpenEdge\WRK\QAProgress1.db
-H machine_name
-m3
# -Ma 1
# -Mi 1
# -Mpb 1
-N TCP
-S 9999
-ServerType SQL
>proserve database
I then start the secondary login broker using either:
>proserve QAProgress1 -S 9999 -m3
or
>proserve -pf odbcstartup.pf (contents of odbcstartup.pf I give below)
This is all well and good, but if I log out of the Windows machine, then the ODBC server seems to go down. So my basic question is: can I start the ODBC server in such a way that it runs as a service?
I'm pretty sure the answer is yes, but the problem I'm having is that the documentation seems to rely on the using the Progress Explorer tool, and being able to access a folder called ODBC DataServer in it. For example: "double-click the ODBC DataServer folder".
So, can anyone help me configure the Progress Explorer tool so that this folder is present? Alternatively, is there some way to start an ODBC server at the command line so that it starts as a service?
One tantalizing reference is to a Support article P7243 (or something similar) but I can't find the document on the Progress Support site.
Thanks for any help, Martin
Contents of odbcstartup.pf:
# This is my ODBC startup file.
-db E:\OpenEdge\WRK\QAProgress1.db
-H machine_name
-m3
# -Ma 1
# -Mi 1
# -Mpb 1
-N TCP
-S 9999
-ServerType SQL