Unanswered: Setting up DSN and Connecting with ASP
I am having serious problems with connecting to SQL Server via ASP.
I have created a User DSN, however when I am asked if I want to use Windows Authentication or SQL Server authentication, I feel I am having problems. If I choose SQLServer authentication, I am asked to enter a username and password which I do (does this need to be a predefined username and password?). I do this and the connection fails with an error saying that the login is not associated with SQLServer. If I choose windows authentication its fine, but when I try to connect via asp using the username and password I login to get into the machine and the DSN name I set up during the DSN setup, the same error comes up. (for windows authentication does the asp code differ from SQL Server authentication?). I really need help here