[ 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!

[ miodrag77 @ 06.04.2007. 12:51 ] @
probaj da u connect string stavis user i pass