Use provider=sqloledb;server=database=;uid=;pwd=;
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Maxwell Sabwa Sent: 14 September 2005 8:44 To: [email protected] Subject: RE: [ASP] SQL Server Connection Problem The SQL server is set up with mixed authentication, and Dreamweaver can access the DB just fine when I enter the connection string. It is the ASP scripts which pull this error. The connection string used is: ------------------------------------------------------------------------ -- "Driver={SQL Server};Server=TEST_SERVER;Database=STAFF;Uid=sa;Pwd=" ------------------------------------------------------------------------ -- Max. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David Horowitz Sent: Wednesday, September 14, 2005 4:47 AM To: [email protected] Subject: RE: [ASP] SQL Server Connection Problem Folks, The error says sa is not associated with a trusted connection -- wouldn't that indicate Windows Authentication is being used (or trying to be used) instead of SQL Server Authentication? Maxwell, what is you connection string exactly? David <html><body><p class="MsoNormal"><font face="Arial" style="font-size: 8pt">____________________________________________________________<br>CRBAfri ca - providing professional debt management and credit reference <br>bureau services in Kenya, Uganda, Botswana, Tanzania, Ghana, Zambia, <br>Mauritius and Egypt.<br>____________________________________________________________<br>Ac cessKenya - Your Corporate ISP - CRB's solution provider for fast <br>efficient Email and Internet Services<br>____________________________________________________________<br> <br><br>ATTENTION<br>_______________________________________________________ _____<br>The information in this electronic mail message is private and confidential <br>and only for the addressee. Should you receive this message by mistake, <br>you are hereby notified that any disclosure, reproduction, distribution or <br>use of this message is strictly prohibited. Please inform the sender by reply <br>transmission and delete the message without copying or opening it. Any <br>unauthorised use or interception of this e.mail is illegal. If this e.mail is not <br>intended for you, you may not copy, distribute or disclose the contents to <br>anyone. Save for the bona fide company matters, the CRB Group of <br>companies does not accept responsibility for the opinions expressed in <br>this e.mail.<br>____________________________________________________________</fon t></p></body></html> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
