1) check www.able-consulting.com/ado_conn.htm for valid connection strings
2) why not use System.Data.SqlClient ? David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] I am using integrated security between SQL server & IIS and I want to make a trusted OleDb connection with the Trusted_Connection=yes option. However, I keep getting "Login failed for user 'MYSERVER\ASPNET'" ... which obviously is not the currently authenticate IIS user. Does anyone know how to make it use the authenticated IIS user? Thanks... <>< Ryan --- You are currently subscribed to dotnet as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/
