FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Wed, 2003-03-12 at 08:12, Steven J. Backus wrote:
> I have the following msg_handler:
> 
> int msg_handler(DBPROCESS *dbproc, DBINT msgno, int msgstate,
>     int severity, char *msgtext, char *srvname,
>     char *procname, int line)
> {
>   fprintf(stderr, "DB Warning: %s\n\t#%d, severity %d\n", msgtext, msgno,
>           severity);
>   return 0;
> }
> 
> Under the standard sybase dblib I get:
> 
> DB Warning: Changed database context to 'ged'.
>         #5701, severity 0
> DB Warning: Changed language setting to 'us_english'.
>         #5703, severity 0
> 
> With freetds I get:
> 
> DB Warning: Changed database context to 'ged'.
> 
>         #5701, severity 10
> 
> Just thought you might like to know, 10 seems pretty severe for a
> db switch.

Sybase's DBlib uses a 0 severity. Sybase's CTlib uses a severity of 10
for the same message. I guess freetds has standardized on 10 (which
isn't wrong - according to Sybase's SysAdmin guide the lowest level is
10 [status info])

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler AT peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html