DBSETLVERSION

Sets the DB-Library client behavior to version 4.2 or version 6.0 behavior in a LOGINREC structure.

Syntax

RETCODE DBSETLVERSION (
PLOGINREC ploginrec,
BYTE version)

where

ploginrec

A pointer to a LOGINREC structure, which is passed as a parameter to dbopen. You can get one of these pointers by calling dblogin.

version

The DB-Library client behavior to use. Must be either DBVER60 to set DB-Library 6.0 behavior or DBVER42 to set DB-Library 4.2 behavior.

Returns

SUCCEED or FAIL.

Remarks

If this function is not called, the default is DB-Library 4.2 behavior.

Using the DBVER60 value means that SQL Server will treat the connection as a DB-Library 6.0 client in every way. SQL Server will:

• Return decimal and numeric data values
• Return complete column information (including identity column information) to DB-Library and dbcolinfo

Using the DBVER42 value (or not calling DBSETLVERSION for the LOGINREC) means that SQL Server will treat the connection as a DB-Library 4.2 client. SQL Server will:

• Convert decimal and numeric data values to float before returning them to the client
• Return limited, version 4.2 column information (not including identity column information) to DB-Library and dbcolinfo

Note that using DBVER60 is not required to use SQL Server 6.0 server cursors.

See Also

dblogin, dbopen, DBSETLAPP, DBSETLHOST, DBSETLPWD