Hi Jim,
I used Leroy's idea and it worked,
I have a parameters table where I store the string to connect to SQL
and on the forms data enviroment I applied the code as explaind by leroy @ the beforeopentables method and the connection worked just fine.
Bernardo
>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
B.D.H.