KB Article #61030

sepfirst flag details

Problem

What is a sepfirstflag ?


Resolution

The ODBC database interface now supports the "sepfirst" flag which allows a different



separator to be used for the DATABASE OPEN specification. This is required for the Lotus



Notes ODBC driver which uses the slash character for its user names.



Usage examples for Lotus Notes:



     DATABASE OPEN @sqlattrs(sepfirst)



"#LotusNotesODBCDataSource#user/rtm/internat#password";



     DATABASE OPEN @sqlattrs(sepfirst)



"#LotusNotesODBCDataSource#user/rtm/internat#password#driverName#driverData";



Where the separator character # can be replaced by any other character not otherwise used



(@,^,%,etc.).