public static void DoPubsAdHoc() { object[] o = null; try { // instanciate web service pubs_ssl_endpoint e = new pubs_ssl_endpoint(); e.Url = "https://zmv92/pubs_ssl"; e.sqlSession = new SqlSoapHeader.sqlSession(); e.sqlSession.initiate = true; //e.sqlSession.MustUnderstand = true; //e.sqlSession.timeout = 12; e.sqlSecurityValue = new SqlSoapHeader.Security(); e.sqlSecurityValue.Username = "******"; e.sqlSecurityValue.Password = "******"; //e.sqlSecurityValue.MustUnderstand = true; // use security of current client principal //e.Credentials = System.Net.CredentialCache.DefaultCredentials; // this works, SQL Server uses is zmv92\fred // user should be "sa" e.Credentials = new System.Net.NetworkCredential("fred", "fred", "zmv92"); SqlParameter[] n = null; o = e.sqlbatch("select suser_name()", ref n); // process array of results ProcessWSResults(o); //Console.WriteLine(e.sqlSession.sessionId); } catch (SoapException se) { Console.WriteLine("SoapException:"); // nothing in here //Console.WriteLine("Message = {0}", se.Message); Console.WriteLine("Code = {0}", se.Code); Console.WriteLine("Detail message = {0}", se.Detail.OuterXml); } catch (Exception e) { // other exceptions Console.WriteLine(e.Message); if (e.InnerException != null) { Console.WriteLine(e.InnerException.Message); } Console.WriteLine(e.GetType().ToString()); } }
public static void DoPubsAdHoc() { object[] o = null; try { // instanciate web service pubs_ssl_endpoint e = new pubs_ssl_endpoint(); e.Url = "https://zmv92/pubs_ssl"; //e.sqlSession = new SqlSoapHeader.sqlSession(); //e.sqlSession.MustUnderstand = true; //e.sqlSession.initiate = true; //e.sqlSession.timeout = 12; e.sqlSecurityValue = new SqlSoapHeader.Security(); e.sqlSecurityValue.Username = "******"; e.sqlSecurityValue.Password = "******"; //e.sqlSecurityValue.MustUnderstand = true; //SqlTransaction t = new SqlTransaction(); //t.Type = SqlTransactionType.Begin; // use security of current client principal //e.Credentials = System.Net.CredentialCache.DefaultCredentials; // this works //e.Credentials = new System.Net.NetworkCredential("fred","fred","zmv92"); e.Credentials = new System.Net.NetworkCredential("fred", "fred", "zmv92"); // set up the parameter(s) /* * SqlParameter[] p = new SqlParameter[1]; * p[0] = new SqlParameter(); * p[0].name = "state"; * p[0].Value = "OR"; * * // invoke parameterized query and return result(s) * o = e.sqlbatch("select * from authors where state = 'OR'", ref p); */ SqlParameter[] n = null; o = e.sqlbatch("select suser_name()", ref n); // process array of results ProcessWSResults(o); //Console.WriteLine(e.sqlSession.sessionId); } catch (SoapException se) { Console.WriteLine("SoapException:"); // nothing in here //Console.WriteLine("Message = {0}", se.Message); Console.WriteLine("Code = {0}", se.Code); Console.WriteLine("Detail message = {0}", se.Detail.OuterXml); } catch (Exception e) { // other exceptions Console.WriteLine(e.Message); if (e.InnerException != null) { Console.WriteLine(e.InnerException.Message); } Console.WriteLine(e.GetType().ToString()); } }