I have develop .asp application with OWC11 Pivot table. I connect to external datasource from MSSQL server to retrieve data. Everytimes, the user of the page have to enter a user name or password to connect to the data source when opening the page. How to avoid this? Can user direct connect to datasource when opening page without enter the username and password and without change the SQL mode to "Window Authentication" mode?
For your information, Windows Authentication is not available for the data source to be connect.
Anyone can help me? Thanks.