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?

Markdown supported.
Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

7 Answer(s)
  • User Avatar
    0
    Anjali_Musmade created
    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,

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
  • User Avatar
    0
    yunusemrecaglar created

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

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
  • User Avatar
    0
    Anjali_Musmade created
    Support Team Member

    Hi,

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

    Thanks,

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
  • 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?

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
  • 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

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
  • 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?

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

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

    Markdown supported.
    Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v10.8.0-preview. Updated on September 16, 2026, 14:50
1
ABP Assistant
🔐 You need to be logged in to use the chatbot. Please log in first.