Kbase P23049: How to manually spawn a Progress SQL-92 Server?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/27/2010 |
|
Status: Verified
GOAL:
How to manually spawn a Progress SQL-92 Server?
GOAL:
How to manually spawn an _sqlsrv2 server process?
GOAL:
How to manually start a _sqlsrv2 process?
GOAL:
How to trouble shoot a problem where an _sqlsrv2 server process is not being spawned when a client attempts to communicate with a database broker process.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
To manually spawn a SQL Server use the syntax below.
This is helpful when determining whether the problem relies on the server side or client side.
Windows:
%DLC%\bin\_sqlsrv2 -z -D juniper.serverid=1 -D "juniper.dbfile=dbname"
UNIX:
. $DLC/bin/slib_env
. $DLC/bin/java_env
$DLC/bin/_sqlsrv2 -z -D juniper.serverid=1 -D "juniper.dbfile=dbname"
"dbname" is a physical name of a database you are trying to spawn _sqlsrv2 server on.