>Hi All,
>
>I was wondering on how to get rid of the ODBC connection
>screen that pops-up for each of the views I have setup in
>the Data Environment.
>
>I have tried setting up the connection before opening the
>form using the sqlconnect() but I dont know how to tell
>the data environment how to use the connection handle.
>
>I have 4 ODBC views in my data environment and the users would
>need to type in their informix password 4 times the way it is setup
>now.
>
>I am sure there is a better solution...
>
>Thanks in advance.
>
>Pascal
If you look at Connection Designer you may see radio button: "Display ODBC login prompts". You may select 'Never' here. It also controlled by Connection property DispLogin (you may set it to 3 using DBSetProp).
Edward Pikman
Independent Consultant