Api error System.ArgumentException: Format of the initialization string does not conform to specification starting at index 258

Question

I'm currently trying to work through connecting to a cloud-based database with an Api I've found a lot of similar questions but all the fixes I have found on stack haven't worked for my solution any help would be appreciated [Error that the Api is showing - program.cs ConnectionString ]

ConnectionString in appsettings:


    "ConnectionStrings": {
        "MyContext": 
    "Server=tcp:removed.database.windows.net,1433;Initial Catalog=kawamaraedb;Persist Security Info=False;User  ID=Removed;Password='Removed';MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
  },

ID and Password are correct

My fix

I figured it out i had to manually type in the connection string from azure and take out alot of the added code string

FROM THIS:

Server=tcp:sql.database.windows.net,1433;Initial Catalog=YOUR DB;Persist Security Info=False;User ID={USER};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

TO THIS

"Data Source=tcp:sql.database.windows.net,1433;Initial Catalog=YOUR DB;User Id={USER};Password={YOUR PASSWORD}"

Mohammad · Accepted Answer · 2022-07-14 09:45:29Z

1

It's not related to Visual Studio 2022. It seems that the connection string is not correct. For instance, InitialCatalog is not a valid key and should be Initial Catalog. You may discover more at Connection String Property

answered Jul 14, 2022 at 9:45

Mohammad

5892 gold badges9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jam Over a year ago

ill look into that now

Jam Over a year ago

it is written as initial catalog in the connection string i shouldve been clear i have been able to access the database via visual studio i can scaffold it into a solution but the api always has a heart attack when i try execute anything

Jam Over a year ago

also the connection string is the one i received from azure

Collectives™ on Stack Overflow

Api error System.ArgumentException: Format of the initialization string does not conform to specification starting at index 258

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related