blazor-starter-kit icon indicating copy to clipboard operation
blazor-starter-kit copied to clipboard
verified publisher icon fullstackhero

Change db to oracle db it not not work

Open Hunglmc opened this issue 2 years ago • 2 comments

when i change db to oracle with code internal static IServiceCollection AddDatabase( this IServiceCollection services, IConfiguration configuration) => services .AddDbContext<VRBSecureSalaryContext>(options => options .UseOracle(configuration.GetConnectionString("OracleConnection"))) .AddTransient<IDatabaseSeeder, DatabaseSeeder>(); and change connect string to oracle the system Oracle.ManagedDataAccess.Client.OracleException: 'ORA-01435: user does not exist when i run migrate()

I tried using toad and connecting with normal connection information and didn't encounter any problems. Please let me know what problem I have or how to change to oracle db

Hunglmc avatar Dec 08 '23 08:12 Hunglmc

What user name is in your connection string? It should be the same as the one you are using when connecting with Toad.

MomboMan avatar Dec 08 '23 21:12 MomboMan

What user name is in your connection string? It should be the same as the one you are using when connecting with Toad. Yes, they are all the same and similar to toad. Perhaps it's because we need to add a user with a schema identity

Hunglmc avatar Dec 10 '23 17:12 Hunglmc