Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Konekcija sa SQL bazom C# greska???

[es] :: .NET :: .NET Desktop razvoj :: Konekcija sa SQL bazom C# greska???

[ Pregleda: 2126 | Odgovora: 1 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

boomLM
Misa Boom

Član broj: 96472
Poruke: 85
212.200.179.*



Profil

icon Konekcija sa SQL bazom C# greska???05.04.2007. u 19:04 - pre 206 meseci
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!

 
Odgovor na temu

miodrag77
Miodrag Dragic
NS

Član broj: 43159
Poruke: 59
*.ADSL.neobee.net.



Profil

icon Re: Konekcija sa SQL bazom C# greska???06.04.2007. u 12:51 - pre 206 meseci
probaj da u connect string stavis user i pass
 
Odgovor na temu

[es] :: .NET :: .NET Desktop razvoj :: Konekcija sa SQL bazom C# greska???

[ Pregleda: 2126 | Odgovora: 1 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.