I just tried that and it worked well. How do I keep the login screen for SQL Server from appearing if the connection fails? This would be like selecting the never option under Display ODBC login prompts when creating a connection within a project.



>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