SqlSetLVersion%

Sets the DB-Library client behavior to version 4.2 or version 6.0 behavior in a login record.

Syntax

SqlSetLVersion% ( loginrec%, version% )

where

loginrec%

A login record, which is passed as a parameter to SqlOpen%. The value of loginrec% is returned by SqlLogin%.

version%

The DB-Library client behavior to use. Must be either SQLVER60% to set DB-Library 6.0 behavior or SQLVER42% to set DB-Library 4.2 behavior.

Returns

succeed (1) or fail (0).

Remarks

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

Using the SQLVER60% value means that SQL Server will treat that 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 SqlColInfo%.

Using the SQLVER42% value (or not calling SqlSetLVersion% for the login record) means that SQL Server will treat that connection as a DB-Library 4.2x 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 SqlColInfo%

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

See Also

SqlLogin%, SqlOpen%, SqlSetLApp%, SqlSetLHost%, SqlSetLPwd%