Hi Alex
Thanks for the reply. This will work fine EXCEPT i need to this at the Connection Designer because i Upsized my app to SQL6.5 and it requires the connection from the connection designer.
Thanks
>>>>>>>>>>>>>>>>>>>>>>>
>>I use an ODBC driver to connect to a SQL 6.5 database.
>>In my program i use sqlconnect('BAUDWIN','SA','') OR
>>SQLSTRINGCONNECT('DRIVER=SQL SERVER ETC ETC')
>>
>>The problem is i would like to use say e.g. the 'baudwin','sa,''
>>as a variable. Can i set this in the config file or how else do i do this.
>>I would like to do the same for the SQLSTRINGCONNECT
>>>>>>>>>>>>>>>>>>>>>>>
>
>Fida,
>
>Wouldn't this work?
>
>lcName = 'BAUDWIN'
>lcUID = 'SA'
>lcPassword = ''
>sqlconnect(lcName,lcUID,lcPassword)
>
Wannabe FoxPert!!!