Hi Chad,

I've created remote views in my application and those connect via a connection. That's why I need one...

Jim

>Jim,
>
>I've not been following this thread, so please forgive me if this has already been discussed and shot down, but why not use a connection string instead of a connection. Then you can just fill in the username and password before you ever try to make the connection via SQLSTRINGCONNECT()
>
>HTH,
>Chad
>
>>ALL,
>>
>> Ok, I've been sitting at work looking at this ODBC issue for the past 4 hours. I need to know if there is a way to have a connection in a project and set the properties, such as userid and password, BEFORE connecting.
>>
>>Thanks
>>
>>Jim