OleDB connection.Open() fails in WebService only

[ErikJL]

I have a simple webservice that performs a SELECT query against a database, and then an INSERT statement on the same database/table. The problem arises at the time when we create the second OleDB connection object and attempt to Open() it. The connection string is exactly the same for both connection objects. Another intersting thing is that this code works fine when it is used in a Windows Form project.

The code snippet:

 
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();
}
 

Here is 'cnOleDBSDE' the first time around just before .Open() is called:

 
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
 
 

And here is cnOleDBSDE the second time around (when it fails), just before .Open() is called:

 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
 

I don't see any differences. Here is the exception that is thrown:

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?

[jhardman]

hmm. I don't think you can make a web service in ASP, and this doesn't look like VBScript. Perhaps you meant to post in the .NET forum? I'll move it over for you.

Jared