weird connection error

microsoft.public.dotnet.framework.adonet

11 Jul 2006 7:20 PM

ECathell

Name have been changed to protect the innocent.

This is the only class that is causing me this issue and I can't figure out why. Everything before this one loads fine, and the ones after this load fine. I have checked the underlying tables and the user has proper permissions. I do not get the error, but I have more permissions than he does. The other person using the application does not get this error either, but he has elevated privileges too...I have done everything I can think of and it is still occurring ...

The bit of code that is causing this is simply a matter of loading a new instantiation of a product class from dsinvmgmt.products.getallproducts.

The class that is actually the editor for that class loads before it but in a different class. So I wouldn't think that would be interfering. Below is the message of the ex.tostring.

---------------------------

System.Data.SqlClient.SqlException: Login failed for user 'DOMAIN\user'.

   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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

   at dsInvmgmtDataSetTableAdapters.ProductsTableAdapter.GetAllProducts() in dsInvmgmtDataSet.Designer.vb:line 16398

   at Designers.Plant_Orders_Designer.initializeTables() in Plant_OrdersDesigner\Plant_Orders_Designer.vb:line 260

----------------------------------------------------------------------

this is line 260: SetProducts(ProductsTableAdapter.GetAllProducts)