Use variable not macro substitution.
gnHandle1 = SQLSTRINGCONNECT(lcConnection)
>I need to use a variable for SQLSTRINGCONNECT() I can't seem to make a variable work.
>
>Working Code:
>lcConnection = 'DRIVER=Client Access ODBC Driver (32-bit);SYSTEM=GVAS400;DefaultLibraries=webprddt6;'+;
>'TRANSLATE=1;UID=DRAW;PWD=WEBER;SIGNON=2;SSL=3'
>
>gnHandle1 = SQLSTRINGCONNECT(&lcConnection)
>
>= SQLDISCONNECT(gnHandle1)
>
>None Working Code:
>Select actpth From pathtbl Where compid == 'PC341sde' And pthname == 'ClientAccess' InTo Cursor myodbcx
>lcConnection = myodbcx.actpth
>
>gnHandle1 = SQLSTRINGCONNECT(&lcConnection)
>
>= SQLDISCONNECT(gnHandle1)
--sb--