follow-up...
We have a SQL Server database that's accessed through an ODBC connection.
We also have remote views defined in a DBC. These remote views use the same ODBC data source. The ODBC login uses SQL Server authentication.
However, when we try to access the remote views, we get the SQL Server login prompt.
We tried to suppress the login through use of different combinations of the following...
SQLSETPROP(0,'DISPLOGIN',3)
nHandle=SQLSTRINGCONNECT('dsn=myDsn;uid=myuid;pwd=mypwd;Database=mydata;trusted_connection=YES')
Those lines appear to execute properly, and we do receive a valid handle. However, when we subsequently attempt to access any of the remote views, we get...
"Error 1526...Connectivity Error [Microsoft] [ODBC Server Server Driver][SQL Server] Login failed for user '(null)'. Reason: not associated with a trusted SQL Server connection.
When we take out the DISPLOGIN line, the SQL Server login screen pops up when we try to access a view.
What are we missing? Is it the setup of the login...or in our connection setup?
Thanks,
Kevin