https://community.esri.com/t5/data-management-questions/sql-database-name-a-reserved-word/m-p/1044160#M43206 <P>We have a SQL database that our Real Estate system populates nightly and we use that data to build our parcel attributes. The database name is "Public", which is a SQL reserved word. I can create a working connection file to this database in ArcMap, but not in ArcGIS Pro. Short of renaming the database and rewriting our scripts, has anyone found a workaround for this?</P> Tue, 06 Apr 2021 14:41:29 GMT KennieHarris 2021-04-06T14:41:29Z https://community.esri.com/t5/data-management-questions/sql-database-name-a-reserved-word/m-p/1044160#M43206 <P>We have a SQL database that our Real Estate system populates nightly and we use that data to build our parcel attributes. The database name is "Public", which is a SQL reserved word. I can create a working connection file to this database in ArcMap, but not in ArcGIS Pro. Short of renaming the database and rewriting our scripts, has anyone found a workaround for this?</P> Tue, 06 Apr 2021 14:41:29 GMT https://community.esri.com/t5/data-management-questions/sql-database-name-a-reserved-word/m-p/1044160#M43206 KennieHarris 2021-04-06T14:41:29Z https://community.esri.com/t5/data-management-questions/sql-database-name-a-reserved-word/m-p/1044477#M43211 <P>What does Pro do when you attempt the connection?</P><P>More importantly, what does your parcel attribute update process look like. You mention scripts, so I'm assuming Python? Could you use something like <STRONG>sqlalchemy</STRONG> to connect to the database instead of doing it through Pro?</P> Wed, 07 Apr 2021 00:21:29 GMT https://community.esri.com/t5/data-management-questions/sql-database-name-a-reserved-word/m-p/1044477#M43211 jcarlson 2021-04-07T00:21:29Z