Hello,
I have a client attempting to connect to SQL Server 2008 from Access 2010 on a Linux machine. The connection string is the standard ODBC connection string;
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
but the connection always prompts for the username and password.
What changes to the connection string do I need to make in order for this to connect without the login credentials prompt appearing.
Thank you.