Hi Guys,
I'm trying to connect to SQL Server 2005 through ODBC via Excel. I have setup a DSN connection and it works fine. But everytime it refresh, it always ask for username and password.
How to connect to SQL via DSN without prompting again for username and password?
Regards,
Joey