CODEWITHSUNDEEP
sqldatabase-connectionorchardcms
user1723409
user1723409

Reputation: 133

How to access other database within orchard

I am trying to access an external database to display data in an orchard module my firs attempt I got the following error.

An unhandled exception has occurred and the request was terminated. Please refresh the page. If the error persists, go back

The provider did not return a ProviderManifestToken string.

System.Data.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. ---> System.Data.SqlClient.SqlException: MSDTC on server 'ML-52\SQLEXPRESS' is unavailable.

I was just taking a stab in the dark if anyone has done this or has a simple module that connects to an external DB please share. It will be much appriciated

Thanks in advance.

Upvotes: 1

Views: 575

Answers (1)

Bertrand Le Roy
Bertrand Le Roy

Reputation: 17814

Surround your data access with

using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Suppress)) {

Upvotes: 1

Related Questions