Kbase P16010: How can I determine if the connection parameters passed, hav
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/5/2003 |
|
Status: Unverified
GOAL:
How can I determine if the connection parameters passed, have been recognized by the DataServer?
GOAL:
Is there a way to validate that the connection parameters passed to the DataServer are working
FACT(s) (Environment):
MS SQL DataServer
FIX:
Often times when a connection string is passed to the DataServer, other than an outward message referencing an incorrect parameter, there really is no way for the user to determine if the connection parameters entered have been recognized by the DataServer.
Take for example, the following string:
-Dsrv qt_cache_size,12000,skip_schema_check,MSS_PRESERVE_CURS,1,PRGRS_BLOCK_CURS,0,PRGRS_CONNECT,DSN=sqlserver,TXN_ISOLATION,1,BINDING,0 -U sa
the user has no idea if any of these parameters are truly working as expected. Since this information is not stored anywhere within the schema holder, it cannot be captured or recorded into the dataserv.lg file. Since there is a need to better identify this information, Bug# 20021217-013 has been logged to address this issue.
An exception to the rule is when using 'skip_schema_check'. When this parameter is entered into the connection string, the DataServer denotes this information into the dataserv.lg file.