Skip to main content
Solved

Acumatica is using mysql or sql how to identify in c# code. Or In Acumatica how to get the provider name in C# code to identify the SQL or MySql.


Forum|alt.badge.img

Acumatica is using mysql or sql how to identify in c# code. Or In Acumatica how to get the provider name in C# code to identify the SQL or MySql.

Best answer by hyadav08

I have find solution and solution is -
PXDatabase.Provider this will give the information that database is used in SQL or MySQL

View original
Did this topic help you find an answer to your question?

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+18
  • Captain II
  • 3382 replies
  • May 17, 2024

@hyadav08 You can check the Web.Config file Connection string.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 10 replies
  • May 17, 2024
Naveen Boga wrote:

@hyadav08 You can check the Web.Config file Connection string.

@Naveen Boga 
this is the way to find out
string ProviderName = ConfigurationManager.ConnectionStrings["ProjectX"].ProviderName;

But it can;t solve my purpose. to specific find out database is SQL or MySql


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 10 replies
  • Answer
  • May 24, 2024

I have find solution and solution is -
PXDatabase.Provider this will give the information that database is used in SQL or MySQL


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings