Hi, all...
Always frustrating when things that 'seem' based don't work at the 11th hour...
We have some remote views defined in a DBC, that are to be connected to SQL Server through ODBC.
When we make the connection and try to access the remote views, we get the SQL Server Login prompt for every remove view that we try to open.
I seem to recall that you could either use TRUSTED_CONNECTION=YES, or some option in SQLSETPROP for DISPLOGIN, to suppress those annoying login prompts...but admittedly, I thought those were only for pass-through.
So is there a way to avoid those login prompts when connected to SQL Server through ODBC to access remove views?
Thanks,
Kevin