Getting error in connectionstring while setup using CLI

[dhavalvora-azista]

System.ArgumentException: Connection string keyword 'server' is not supported. For a possible alternative, see
https://go.microsoft.com/fwlink/?linkid=2142181.
at Keywords Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.GetIndex(string keyword)
at void Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.set_Item(string keyword, object value)
at void System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(string value)
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder..ctor(string connectionString)
at SqliteConnectionPoolGroup Microsoft.Data.Sqlite.SqliteConnectionFactory.GetPoolGroup(string connectionString)
at void Microsoft.Data.Sqlite.SqliteConnection.set_ConnectionString(string value)
at Microsoft.Data.Sqlite.SqliteConnection..ctor(string connectionString)
at Task Volo.Abp.Studio.Database.SqliteDbConnectionTester.TestConnectionAsync(
TestConnectionInput input, CancellationToken cancellationToken)
at async Task Volo.Abp.Studio.SolutionTemplates.Pipelines.TestConnectionStringStep.ExecuteAsync(
SolutionBuildPipelineContext context)
at async Task Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.eQjPUC2miE(
List , object )
at async Task Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.BuildAsync(
SolutionBuilderContext context)
at async Task Volo.Abp.Studio.Extensions.StandardTemplates.AppNoLayers.AppNoLayersTemplateSolutionBuilder.
BuildAsync(SolutionBuilderContext context)
at async Task Volo.Abp.Studio.Extensions.StandardTemplates.AppNoLayers.AppNoLayersTemplateSolutionBuilder.
BuildAsync(SolutionBuilderContext context)
at async Task Volo.Abp.Studio.SolutionTemplates.SolutionBuilder.BuildAsync(SolutionBuilderContext context)
at async Task Volo.Abp.Studio.Cli.Commands.NewSolutionCommand.ExecuteAsync(CommandLineArgs commandLineArgs)
at async Task Volo.Abp.Studio.Cli.StudioCliService.RunInternalAsync(CommandLineArgs commandLineArgs)
at async Task Volo.Abp.Studio.Cli.StudioCliService.RunAsync(string[] args)
Unhandled exception. System.ArgumentException: Connection string keyword 'server' is not supported. For a possible alternative, see https://go.microsoft.com/fwlink/?linkid=2142181.
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.GetIndex(String keyword)
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.set_Item(String keyword, Object value)
at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder..ctor(String connectionString)
at Microsoft.Data.Sqlite.SqliteConnectionFactory.GetPoolGroup(String connectionString)
at Microsoft.Data.Sqlite.SqliteConnection.set_ConnectionString(String value)
at Microsoft.Data.Sqlite.SqliteConnection..ctor(String connectionString)
at Volo.Abp.Studio.Database.SqliteDbConnectionTester.TestConnectionAsync(TestConnectionInput input, CancellationToken cancellationToken)
at Volo.Abp.Studio.SolutionTemplates.Pipelines.TestConnectionStringStep.ExecuteAsync(SolutionBuildPipelineContext context)
at Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.eQjPUC2miE(List`1 , Object )
at Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.Extensions.StandardTemplates.AppNoLayers.AppNoLayersTemplateSolutionBuilder.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.Extensions.StandardTemplates.AppNoLayers.AppNoLayersTemplateSolutionBuilder.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.SolutionTemplates.SolutionBuilder.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.Cli.Commands.NewSolutionCommand.ExecuteAsync(CommandLineArgs commandLineArgs)
at Volo.Abp.Studio.Cli.StudioCliService.RunInternalAsync(CommandLineArgs commandLineArgs)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.Program.nhO5N0yAR(Object )
at Volo.Abp.Studio.Cli.Program.

(String[] args)

Documentation

Please check the official documentation before asking questions: https://docs.abp.io

GitHub Issues

GitHub issues are for bug reports, feature requests, and other discussions about the framework.

If you're creating a bug/problem report, please include the followings:

• Your ABP Framework version.
• Your User Interface type (Angular/MVC/React... etc.) if the issue is related to a specific UI
• Your database provider(EF Core/MongoDB)
• Exception message and stack trace if available (check the logs).
• Steps needed to reproduce the problem.

Please write in English.

Stack Overflow

Please use Stack Overflow for your questions about using the framework, templates, and samples:

https://stackoverflow.com/questions/tagged/abp

Use abp tag in your questions.

[maliming]

hi

Please share the steps and code to reproduce the problem.

Thanks.

[SentientGeeks-SumitMandal]

COMMAND:
abp new Acme.BookStore -m none --theme leptonx-lite -csf --connection-string "Server=(LocalDb)\MSSQLLocalDB;Database=BookStore;Trusted_Connection=True;TrustServerCertificate=true"

OUTPUT:
[13:33:44 INF] PostHog Client created with Max Batch Size: 100, Flush Interval: 00:00:30, and FlushAt: 20
[13:33:44 INF] Creating your solution...
[13:33:44 INF] Using template: app
[13:33:44 INF] Solution name: Acme.BookStore
[13:33:44 INF] Output folder: C:\Users\USER\Documents\AbpFrameworkProjects\Acme.BookStore
[13:33:44 INF] Database provider: ef
[13:33:44 INF] UI framework: mvc
[13:33:44 INF] Theme: leptonx-lite
[13:33:44 INF] Mobile framework: none
[13:33:44 INF] Test Projects: Yes
[13:33:44 INF] Social Logins: Yes
[13:33:44 INF] Tiered: No
[13:33:44 INF] Public website: No
[13:33:44 INF] Skip running initial tasks: No
[13:33:44 INF] Multi Tenancy: Yes
[13:33:44 INF] Sample Crud Page: No
[13:33:44 INF] Separated tenant schema: No
[13:33:44 INF] Database management system: sqlite
[13:33:44 INF] Connection string: Server=(LocalDb)\MSSQLLocalDB;Database=BookStore;Trusted_Connection=True;TrustServerCertificate=true
[13:33:44 INF] Selected available languages.
[13:33:44 INF] Languages: English, Arabic, Chinese (Simplified), Chinese (Traditional), Czech, English (United Kingdom), Finnish, French, German (Germany), Hindi , Hungarian, Icelandic, Italian, Portuguese (Brazil), Romanian (Romania), Russian, Slovak, Spanish, Swedish, Turkish

System.ArgumentException: Connection string keyword 'server' is not supported. For a possible alternative, see
https://go.microsoft.com/fwlink/?linkid=2142181.
at Keywords Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.GetIndex(string keyword)
at void Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.set_Item(string keyword, object value)
at void System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(string value)
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder..ctor(string connectionString)
at SqliteConnectionPoolGroup Microsoft.Data.Sqlite.SqliteConnectionFactory.GetPoolGroup(string connectionString)
at void Microsoft.Data.Sqlite.SqliteConnection.set_ConnectionString(string value)
at Microsoft.Data.Sqlite.SqliteConnection..ctor(string connectionString)
at Task Volo.Abp.Studio.Database.SqliteDbConnectionTester.TestConnectionAsync(
TestConnectionInput input, CancellationToken cancellationToken)
at async Task Volo.Abp.Studio.SolutionTemplates.Pipelines.TestConnectionStringStep.ExecuteAsync(
SolutionBuildPipelineContext context)
at async Task Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.TTyYk9MerI(
List , object )
at async Task Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.BuildAsync(
SolutionBuilderContext context)
at async Task Volo.Abp.Studio.Extensions.StandardTemplates.App.AppTemplateSolutionBuilder.BuildAsync(
SolutionBuilderContext context)
at async Task Volo.Abp.Studio.Extensions.StandardTemplates.App.AppTemplateSolutionBuilder.BuildAsync(
SolutionBuilderContext context)
at async Task Volo.Abp.Studio.SolutionTemplates.SolutionBuilder.BuildAsync(SolutionBuilderContext context)
at async Task Volo.Abp.Studio.Cli.Commands.NewSolutionCommand.ExecuteAsync(CommandLineArgs commandLineArgs)
at async Task Volo.Abp.Studio.Cli.StudioCliService.RunInternalAsync(CommandLineArgs commandLineArgs)
at async Task Volo.Abp.Studio.Cli.StudioCliService.RunAsync(string[] args)
[13:33:44 INF] Flush called directly via code: 4 items in the queue
Unhandled exception. System.ArgumentException: Connection string keyword 'server' is not supported. For a possible alternative, see https://go.microsoft.com/fwlink/?linkid=2142181.
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.GetIndex(String keyword)
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder.set_Item(String keyword, Object value)
at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
at Microsoft.Data.Sqlite.SqliteConnectionStringBuilder..ctor(String connectionString)
at Microsoft.Data.Sqlite.SqliteConnectionFactory.GetPoolGroup(String connectionString)
at Microsoft.Data.Sqlite.SqliteConnection.set_ConnectionString(String value)
at Microsoft.Data.Sqlite.SqliteConnection..ctor(String connectionString)
at Volo.Abp.Studio.Database.SqliteDbConnectionTester.TestConnectionAsync(TestConnectionInput input, CancellationToken cancellationToken)
at Volo.Abp.Studio.SolutionTemplates.Pipelines.TestConnectionStringStep.ExecuteAsync(SolutionBuildPipelineContext context)
at Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.TTyYk9MerI(List`1 , Object )
at Volo.Abp.Studio.SolutionTemplates.Pipelines.PipelinedTemplateSolutionBuilderBase.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.Extensions.StandardTemplates.App.AppTemplateSolutionBuilder.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.Extensions.StandardTemplates.App.AppTemplateSolutionBuilder.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.SolutionTemplates.SolutionBuilder.BuildAsync(SolutionBuilderContext context)
at Volo.Abp.Studio.Cli.Commands.NewSolutionCommand.ExecuteAsync(CommandLineArgs commandLineArgs)
at Volo.Abp.Studio.Cli.StudioCliService.RunInternalAsync(CommandLineArgs commandLineArgs)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.StudioCliService.RunAsync(String[] args)
at Volo.Abp.Studio.Cli.Program.iUSwHMDP8(Object )
at Volo.Abp.Studio.Cli.Program.

(String[] args)

[maliming]

hi

Please try to specify --database-management-system SqlServer or remove -connection-string .

The default database is SQLite, but you pass a SQL Server connection string.

Thanks.

[SentientGeeks-SumitMandal]

Hi @maliming,

Thanks for the clarification.

I copied that command from the https://abp.io/get-started page "ABP CLI" section.
The page does not add the -dbms flag for SQL Server, which is selected by default, and even if you click it manually, it adds correctly for other options.

SQL Server

MySQL

The page needs to be updated with correct information.

Thanks.

[maliming]

hi

I’ll fix the commands generated by the abp.io website.

Thanks.