[ boomLM @ 05.04.2007. 19:04 ] @
Evo koda i sta me muci... : Code: [WebMethod(Description = "Vraca listu...")] public string DajListu() { SqlConnection sqlConn; //OleDbConnection oleConn; //OleDbDataReader rdr; XmlReader rdr; string ret = ""; try { //otvara konnekciju sa sql expres ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// string connstring = @"server=.\sqlexpress;Integrated Security=SSPI; initial catalog=AdventureWorks_Data"; // ???? ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //@"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""D:\Fakultet\kuiglhgzk...itd,itd"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"; sqlConn = new SqlConnection(connstring); //oleConn = new OleDbConnection(connstring); sqlConn.Open(); //oleConn.Open(); // vraca XML podatke koristenjem FOR XML AUTO klauzule string sqlstring = "SELECT VendorID,AccountNumber,Name,CreditRating FROM Purchasing.Vendor WHERE ActiveFlag=1 ORDERED BY Name FOR XML AUTO"; SqlCommand command = new SqlCommand(sqlstring, sqlConn); //OleDbCommand command = new OleDbCommand(sqlstring, oleConn); // izvrsava sql upit i vraca sql xmlrideru rdr = command.ExecuteXmlReader(); // prolazi kroz rider i daje nam xml rdr.Read(); while (rdr.ReadState != System.Xml.ReadState.EndOfFile) { ret += rdr.ReadOuterXml(); } // dodaje root element //ret = rdr.GetName(0); ret = "<vendors>" + ret + "</vendors>"; sqlConn.Close(); //oleConn.Close(); rdr.Close(); } catch (Exception exs) { return exs.ToString(); } finally { } return ret; } prijavljuje sledecu gresku: <?xml version="1.0" encoding="utf-8" ?> <string xmlns="http://tempuri.org/">System.Data.SqlClient.SqlException: Cannot open database "AdventureWorks_Data" requested by the login. The login failed. Login failed for user 'ime servera\imeAdministratora'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at MyWebService.DajListuIgraca() in d:\Fakultet\...MyWebService.cs:line 43</string> A u ServerExploreru prilikom dodavanja konekcije (Testiranja konekcija) kaze da je sve OK ??? Predpostavljam da ima neke veze sa logovanjem na bazu ali...??? Nista nisam podesavao - razdesavao ![]() Help! |