ASP to SQL without a DSN
I have an asp program that calls a C program that uses db-library to connect to Sql Server 2000. The error produced is "Login failed for user '\'." Here are some of the particulars
Web Server is running Windows Server 2003
Database server is running SQL Server 2000 on Windows NT 4
The program runs fine from the dos prompt on the web server.
Other asp programs that use DSN-Less and DSN connections to
attach to the db server work fine.
DB-Library is set up to use a Secure Connection
The web server is setup to use Basic authentication.
In the asp page I print out the username and domain by using WshNetwork. The username is correct; HOWEVER, the domain name is blank. I suspect that this is the source of my problem, but can not find a solution.
Is there a way to have ASP pass to SQL Server the Username, Password and domain that was used when activating the asp page?
Please help, I am about to call it a year already.
~Julie
|