Does anybody know if Access2000 supports COM+.
I'm writing a DLL for ASP that must have the option of Access or SQL Server as a datasource.
Printable View
Does anybody know if Access2000 supports COM+.
I'm writing a DLL for ASP that must have the option of Access or SQL Server as a datasource.
it shouldn't matter what your data source is, what exactly are you trying to support in COM+ that you are concerned about?
I'm worried that I cannot find any documentation in Access re COM+ or MS DTC.
The DLL will eventually be talking to linked servers so thats why I'm worried about Access.
Distributed Transactions across SQL Servers isn't a problem, but when you lob an Access database into the equation my first incling would be to scream and run a mile, i'll do some digging for you, I reckon it might depend a lot on OLEDB, but i'm still not optimistic. You might be better off setting up some surrogate tables in one of your SQL servers and running a DTS package to import the data periodically (how often is up to you), then you can stick with the SQL server. It's not a generic solution, and it's only off the top of my head. Like I said I'll go and have a look around and see what transaction levels (distribution wise) Access supports....