# How to Fix : 42601: syntax error at or near "value" When Try To Access Hangfire Dashboard

**URL:** <https://discuss.hangfire.io/t/how-to-fix-42601-syntax-error-at-or-near-value-when-try-to-access-hangfire-dashboard/9801>\
**Category:** bug?\
**Tags:** postgres, dashboard, aspnetcore\
**Created:** [March 11, 2023, 7:11am UTC](https://discuss.hangfire.io/t/how-to-fix-42601-syntax-error-at-or-near-value-when-try-to-access-hangfire-dashboard/9801 "2023-03-11T07:11:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mahson63](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@Mahson63](https://discuss.hangfire.io/u/Mahson63)\
**Post date:** [March 11, 2023, 7:11am UTC](https://discuss.hangfire.io/t/how-to-fix-42601-syntax-error-at-or-near-value-when-try-to-access-hangfire-dashboard/9801/1 "2023-03-11T07:11:15Z")

</div>

I Use Hangfire With Postgresql Storage in .net-6.0 and install this package : Hangfire.PostgreSql version 1.9.10

This is My Code In Program.cs :

```auto
var builder = WebApplication.CreateBuilder(args);

builder.Services.AddHangfire(config => config.UsePostgreSqlStorage(builder.Configuration.GetConnectionString("HangfireConnection")));
builder.Services.AddHangfireServer();

var app = builder.Build();

app.UseHangfireDashboard();

```

This is My Connection string in webconfig :

```auto
    "ConnectionStrings": {
    "HangfireConnection": "Host=db1.motorazmasamin.com;Port= ***;Database=Hangfire;Username=*** ;Password=***"
},

```

Build Database Correctly!, But When Type Dashboard URL([http://localhost/hangfire](http://localhost/hangfire)) , Return This Error:

> {“data”:null,“status”:-1,“message”:“42601: syntax error at or near “value”\r\n\r\nPOSITION: 59”,“statusCode”:“500”}

But When Change Connection String to SQL Server and change Package To Hangfire.SqlServer , It’s Correct!