Hi Alex

Yes this is what i mean with create connection .
The problem is I upsized my data to SQL6.5 and it creates a connection called Upsize and I obviously have to overwrite this connection with whatever the user has setup as his login name etc in the ODBC DATA source..
Any Suggestions????

Thanks
Fida

>You mean, as in:
>
>CREATE CONNECTION [ ConnectionName ] ;
> [ DATASOURCE cDataSource ;
> [ USERID cUserId ] ;
> [ PASSWORD cPassWord ] ;
> [ DATABASE cDatabase ] ] | CONNSTRING cConnectionString ]
>
>
>
>
>>>>>>>>>>>>>>>>>>>>>>>>>
>>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)
>>>
>