The code snippet:
Expand|Select|Wrap|Line Numbers
- try
- {
- // Connect to database
- // Initialize a new OleDbConnection
- cnOleDBSDE = new OleDbConnection();
- // Setup the connection string
- cnOleDBSDE.ConnectionString = "Data Provider=" +DBProvider+ ";"+
- "Provider=" + DBShapeProvider + ";" +
- "Data Source=" + DBName + ";" +
- "Pooling=" + Pooling.ToString() + ";" +
- "User Id=" + UserId + ";" +
- "Password=" + Password;
- // Open the connection
- cnOleDBSDE.Open();
- }
Expand|Select|Wrap|Line Numbers
- cnOleDBSDE
- {System.Data.OleDb.OleDbConnection}
- base {System.Data.Common.DbConnection}: {System.Data.OleDb.OleDbConnection}
- ConnectionString: "Data Provider=MSDAORA.1;Provider=MSDataShape;Data Source=sdeprod;Pooling=False;User Id=UID;Password=PASSWORD"
- ConnectionTimeout: 15
- Database: ""
- DataSource: "sdeprod"
- Provider: "MSDataShape"
- ServerVersion: 'cnOleDBSDE.ServerVersion' threw an exception of type 'System.InvalidOperationException'
- State: Closed
Expand|Select|Wrap|Line Numbers
- cnOleDBSDE
- {System.Data.OleDb.OleDbConnection}
- base {System.Data.Common.DbConnection}: {System.Data.OleDb.OleDbConnection}
- ConnectionString: "Data Provider=MSDAORA.1;Provider=MSDataShape;Data Source=sdeprod;Pooling=False;User Id=UID;Password=PASSWORD"
- ConnectionTimeout: 15
- Database: ""
- DataSource: "sdeprod"
- Provider: "MSDataShape"
- ServerVersion: 'cnOleDBSDE.ServerVersion' threw an exception of type 'System.InvalidOperationException'
- State: Closed
ex
{"Data provider could not be initialized."}
[System.Data.OleDb.OleDbException]: {"Data provider could not be initialized."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: null
Message: "Data provider could not be initialized."
Source: "MSDataShape"
StackTrace: " at System.Data.OleDb.OleDbConnectionInternal..ctor(Ol eDbConnectionString constr, OleDbConnection connection)\r\n at System.Data.OleDb.OleDbConnectionFactory.CreateCon nection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)\r\n at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)\r\n at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)\r\n at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)\r\n at System.Data.OleDb.OleDbConnection.Open()\r\n at GDAC.GDAC.OpenOleDbConnection(String DBName, String DBProvider, String DBShapeProvider, Boolean Pooling, String UserId, String Password) in D:\\ETS\\GDAC\\GDAC.cs:line 471"
TargetSite: {Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)}
Any ideas?