I don't have problem direct connecting arcgis to postgresql if my database name contains only letters, but when the name contains dashes or underscore e.g:"gisdb-dev", I receive an error when setting up direct connection using ArcCatalog.
Failed to connect to the specified server. Do you want to continue? Invalid SQL Syntax
I'm sure I didn't break any database name restriction on PostgreSQL or ESRI side. I've look around and can't find any solution for this problem.
Had anyone came across this problem and have a solution?
- Windows 7 Ultimate x64
- ArcGIS 10.1 sp1
- PostgreSQL 9.1.3 x64
- PostGIS 2.0 x64