I'm attempting to set up a tabledef to link to a SQL Server 2005 table. I'm using SQL Native Client driver. I must use SQL Server authentication rather than Windows authentication. I have the SQL userid and password and they work. But when I set up the connection
in code, I get a Login popup with my Windows id pre-populataed and asking for my Windows password. How do I force the connection to use SQL authentication? I have researched online for hours and can find no definitive answer. There seem to be so many different
parameters for userid and password, UID=, USERID=, USER ID=, PASSWORD=, PWD= etc. etc. I don't know which is right or even if that is the problem.