Open Closed

Connection error to two separate databases. #6221


User avatar
0
yunusemrecaglar created
  • ABP Framework version: v7.2.2
  • UI Type: Blazor Server
  • Database System: EF Core (SQL Server, Oracle, MySQL, PostgreSQL, etc..)
  • Tiered (for MVC) or Auth Server Separated (for Angular): yes

Hi, I want to establish connections to two separate databases (Oracle and MSSQL). When trying to connect to the Oracle database, I'm encountering an error similar to the one below: 'System.ArgumentException: 'Server' is an invalid connection string attribute.' How can I resolve this?


7 Answer(s)
  • User Avatar
    0
    Anjali_Musmade created
    Support Team Support Team Member

    Hi ,

    Can you check this once similar ticket https://support.abp.io/QA/Questions/3579/Possible-to-connect-using-two-different-database-management-systems-in-single-solution#

    Thanks,

  • User Avatar
    0
    yunusemrecaglar created

    I didn't see a server error in the link you provided

  • User Avatar
    0
    Anjali_Musmade created
    Support Team Support Team Member

    Hi,

    Please check https://learn.microsoft.com/en-us/answers/questions/899331/system-argumentexception-server-is-an-invalid-conn

    Thanks,

  • User Avatar
    0
    yunusemrecaglar created

    Hello, The system was working. I left, and when I came back after 1 hour, I restarted it, but now it's giving an error. What could be the reason?

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi yunusemrecaglar

    Can you share a simple project to show the error?

    liming.ma@volosoft.com

  • User Avatar
    0
    yunusemrecaglar created

    "options.UseSqlServer<ObiyosisDbContext>(); options.UseOracle<OldSystemDbContext>();",

    "options.UseSqlServer();" When I changed the code from the upper part to the lower part and ran it, the issue was resolved. Now it's not giving that error, even when I revert to the upper part. If it happens again, could I contact you for remote assistance?

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    Of course, you can open a new question if you get a new problem..

Made with ❤️ on ABP v9.1.0-preview. Updated on December 05, 2024, 12:19