syntax error at or near "[" , vs2017 connect to SSAS ,dotConnect for PostgreSQL v.7.13.1402

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
ThomasSH
Posts: 2
Joined: Sat 08 Jun 2019 08:15
Location: Shanghai

syntax error at or near "[" , vs2017 connect to SSAS ,dotConnect for PostgreSQL v.7.13.1402

Post by ThomasSH » Sat 08 Jun 2019 09:19

Hi,

dotConnect for PostgreSQL v.7.13.1402
Microsoft Visual Studio Community 2017 15.9.9
Microsoft Visual Studio Tools for Applications 2017 00369-60000-00001-AA328
Microsoft Visual Studio Tools for Applications 2017

I can create data source to connect PG,but when i add table or view to DataSourceview the error message appear:

===================================

syntax error at or near "[" (Microsoft Visual Studio)

------------------------------
Program Location:

at Devart.Data.PostgreSql.w.a(Boolean A_0, Boolean A_1, Char A_2, Boolean A_3)
at Devart.Data.PostgreSql.f.f(s A_0)
at Devart.Data.PostgreSql.s.n()
at Devart.Data.PostgreSql.PgSqlCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType)
at Microsoft.AnalysisServices.Design.DSVUtilities.AddTableItemsInDataSet(DataSourceView dsv, DataSourceConnection conn, ArrayList tableList, String tableType, Hashtable usedFriendlyNames, ProgressBar progressBar, Int32 progressTotalCount, Int32& progressCounter)
at Microsoft.AnalysisServices.Design.DSVUtilities.ExportDataSet(DataSourceView dsv, DataSourceConnection conn, ArrayList tableList, ArrayList viewList, ArrayList sysTableList, ArrayList sysViewList, IServiceProvider serviceProvider, ProgressBar progressBar)
at Microsoft.AnalysisServices.Wizards.DSVWizardForm.OnFinish(CancelEventArgs e)


Thank you for your supporting,

Pinturiccio
Devart Team
Posts: 2406
Joined: Wed 02 Nov 2011 09:44

Re: syntax error at or near "[" , vs2017 connect to SSAS ,dotConnect for PostgreSQL v.7.13.1402

Post by Pinturiccio » Tue 11 Jun 2019 11:59

For SSDT 2017 dotConnect for PostgreSQL supports only SSIS projects. You can use dotConnect for PostgreSQL in SSDT 2015 or earlier for SSAS projects.

ThomasSH
Posts: 2
Joined: Sat 08 Jun 2019 08:15
Location: Shanghai

Re: syntax error at or near "[" , vs2017 connect to SSAS ,dotConnect for PostgreSQL v.7.13.1402

Post by ThomasSH » Wed 12 Jun 2019 03:47

Pinturiccio,

I install SSDT2015 and it works, you can close this issue,thanks

Best Regards,
Thomas

Post Reply