all groups > dotnet interop > october 2005 >
You're in the

dotnet interop

group:

OleDb and foxpro dbc in Com+ component


OleDb and foxpro dbc in Com+ component Gibson
10/14/2005 3:55:35 AM
dotnet interop: Hi,

i created a dll for database access. i use it in combination with a
foxpro dbc.
using it directly in an application and/or with mssyl, it works fine.

if i wrap it in a com+ dll and want to open the OleDbConnection it
fails with the following error:

at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.CreateSession()
at System.Data.OleDb.OleDbConnection.Open()
No error information available: E_NOINTERFACE(0x80004002).

Code:
OleDbConnection con = new OleDbConnection("Provider=VFPOLEDB.1;Data
Source="+database);
con.Open();

Trying MS Jet OleDB Provider also fails in COM+ but works directly.

regards

gibson
Re: OleDb and foxpro dbc in Com+ component Gibson
10/14/2005 5:59:15 AM
I found it by myself:
wrong:
[ Transaction( TransactionOption.Required ) ]
working:
[ Transaction( TransactionOption.Supported ) ]
AddThis Social Bookmark Button