Devart Forums

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,

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

Pinturiccio，

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

Best Regards,
Thomas