Have u actually tried to connect to ur DB from the Query Analyser of MSSQL using the same uid and pwd. If its working, then it should be working in the asp also. Please post ur connection string to know errors if any.
I have already done that. I'm at my wits' end! I have tried ODBC and OLE connection strings, but I still get the same error on the page even though Dreamweaver says the connection was made successfully when I use it to test the connection. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Forbes - ITD Sent: Tuesday, September 13, 2005 12:01 PM To: [email protected] Subject: RE: [ASP] SQL Server Connection Problem You have to supply a password and if the password is blank use pwd= So "uid=sa;pwd=" __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
