多步OLE DB操作产生错误

Question

我从Netezza数据源

dss = new DataSet(); 
ad = new OleDbDataAdapter(cmd); 
ad.SelectCommand = new OleDbCommand("SELECT * FROM " + objTable.name); 
ad.SelectCommand.Connection = cn; 
ad.FillSchema(dss, SchemaType.Source); 

我碰到下面的错误运行一个简单的FillSchema的：

System.Data.OleDb.OleDbException: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. 
    at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) 
    at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) 
    at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) 
    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) 
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) 
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 
    at System.Data.OleDb.OleDbConnection.Open() 
    at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) 
    at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) 
    at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) 
    at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) 
    at IMS.DF2.IMSCubeGenerator.IMSCube.AddTableToDatasourceView(table objTable) in C:\DIUP\DF2\IMSCubeGenerator\IMSCube.cs:line 902 

我在做什么错在这里？

如何获取下面的错误（检查每个OLE DB状态值）？

Answer 1

什么是您的连接字符串？

这将是您的驱动程序，您的光标或安全（我有使用集成安全相同的问题）。

将其更改为用户名/密码修复了我的问题。

有关更多信息，请参见here,here和here。