Hi Community
I want to convert a table with an X and Y couple who is hosted in a database, but when i try to use the "Display XY Data" tool, i have this error :
What does it means ?
Solved! Go to Solution.
Could a special character in the column name throw the SQL error??
I saw that degree marker in there. A cold chill ran down my spine. (Then I realized my windows is open.)
Try a file with safer column names.
The connection to your database is failing.
First try writing to a shapefile instead of a geodatabase to test the tool then fix your database connection.
You have the ODBC 18 driver installed. If you are using ArcMap that will fail. It won't work with ODBC version > 17.
Hi, I'm using ArcGIS Pro
I can connect to my database because i can use the table from my database. It's a SQL database with only table files.
I don't understand your point, can you explain me what I have to do ?
You added a table to your map. Then you used Display XY Data by right clicking??
My first thought was that you specified the Output Feature Class wrong. I still suggest you write to a shapefile to test it but I also see another message about "empty_out_bounds" and the error suggests a typo in one of your "field" parameters. Can you take a screenshot of the dialog and post it here? Like this....
In my simple CSV file test it was able to find the column names on its own, no chance for me to type it wrong.
Hi, for the screenshot you ask :
I test with ".shp" in the name on the Output Feature Class, but it change nothing.
Here the error message :
@JasonBOCQUET - my first question is how are you connecting to your SQL Server database? Are you suing an OLE DB connection or a database connection to MS SQL Server using this approach?
I'm connecting to my SQL server following this path :
I click on Database > New Database Connexion
Database Platform "SQL Server" and Authentication Type : "Database authentication".
This is not the good way to connect to my database ?
Hi @JasonBOCQUET - yes, this is the preferred way to connect to an enterprise geodatabase and then creating a *.sde connection file in ArcGIS Pro to see your data. When you create the *.sde connection file for your eGDB, do you see feature classes, feature datasets and/or more? Based upon the GP error message, it does seem there is a connection problem. This tech support article/workflow may assist.
I see only table in my SQL database because we host only table with X/Y column in our database.
That's why I have to use the "Display X/Y data" tools.
Thank you the additional information and view of the non-spatial tables. I do still think there's a connection issue based upon the GP tools error message. In this table, you can see the SQL Server version and supported SQL Server clients required to make a connection. What SQL Server version and client version are you using?