locked
When I am running the .net class library file and getting DB connectivity issue. RRS feed

  • Question

  •  Dim db As Database = DatabaseFactory.CreateDatabase("SQLDB08")
            Dim dsRead As DataSet = Nothing
            Dim dbCmd As DbCommand = Nothing
    
            dbCmd = db.GetStoredProcCommand("usp_ABC_Getdetails_")

    When I am running the logic I am getting below issue:

    Below is the app.config file:

    <configSections>
        <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </configSections>
      <connectionStrings>
        <add name="SQLDB08" connectionString="Data Source=APSSQL01\V12;Initial Catalog=VTransQA;Integrated Security=True" providerName="System.Data.SqlClient" />
      </connectionStrings>

    Also I have added references "Microsoft.Practices.EnterpriseLibrary.Data.dll" and "Microsoft.Practices.EnterpriseLibrary.Common.dll"



    Wednesday, March 28, 2018 4:53 AM

All replies

  • Hi RamiReddy.com,

    Thank you for posting here.

    According to your question is more related to VB, I will move it to Visual Basic forum for suitable support.

    The CLR Forum discuss and ask questions about .NET Framework Base Classes (BCL) such as Collections, I/O, Regigistry, Globalization, Reflection. Also discuss all the other Microsoft libraries that are built on or extend the .NET Framework, including Managed Extensibility Framework (MEF), Charting Controls, CardSpace, Windows Identity Foundation (WIF), Point of Sale (POS), Transactions.

    Best Regards,

    Wendy


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, March 29, 2018 8:13 AM
  • Rami,

    This seems to be one of the with much tam tam started Microsoft developments which without any sound or documentation about it ended. 

    https://github.com/MicrosoftArchive/enterprise-library


    Success
    Cor

    Thursday, March 29, 2018 1:01 PM
  • You might want to take a look at the below thread. I would create a backup copy of your .config file before making changes.

    https://social.msdn.microsoft.com/Forums/en-US/f1914e7b-f3b6-46cd-b9e4-41edf6121185/buildfailedexception-was-unhandled?forum=adodotnetentityframework


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, March 29, 2018 3:29 PM