I have just converted a application from MS-Access to SQL-Server.
Although I have embedded the password and user name in a ODBC connection string. Users occansionally still get a SQL Server Login Box. It looks like the ODBC loses connection with the server.
Is anyone aware of any possible solution for this.
I look forward to a reply.