DB2 DSN CURRENTSCHEMA

[Alan.Squires]

Hi,

I need to create a DB2 system DSN programmatically. I need to set the
currentschema parameter to be equal to the appropriate database name. I
am able to create the DSN ok, but am unable to add the currentschema
parameter. I am using visual fox pro 9. My code follows:

lc_driver = "IBM DB2 ODBC DRIVER" + CHR(0)

lc_dsn = "DESCRIPTION=Connection Description" + CHR(0)+ ;
DSN=TEST" + CHR(0)+ ;
"DBALIAS=" + ALLTRIM(UPPER(lc_DBAlias)) + CHR(0)+ ;
"CURRENTSCHEMA=" + ALLTRIM(UPPER(lcDatabase)) + CHR(0)+ ;
"UID=" + ALLTRIM(lc_AdminUser) + CHR(0)+ ;
"PWD=" + ALLTRIM(lc_AdminPassword) + CHR(0)

fResult = SQLConfigDataSource(0, 4, @lc_driver, @lc_dsn)

I don't get any error message and the DSN is created, but withou the
currentschema.
Any help would be appreciated.

Alan