Skip to main content
Question

SQL table generate by FME not visible in QGIS

brandonguo
Contributor
Forum|alt.badge.img+3

I uploaded a table into MSSQL server, but the table is not visible in QGIS.

There is no issue viewing the table in SQL Server Management Studio, and the primary key is generated by counter.

So far, I tried turn Spatial Index on and off; Change the collection type handling; Change Insert into Identify Column on/off. None of those steps work.

Any idea how to modify the writer to let the table visible in QGIS?

 

Update:

In ArcGIS Pro, the table is visible, but can't add to map, gives an error message.

4 replies

chrisatsafe
Contributor
Forum|alt.badge.img+2
  • chrisatsafeContributor
  • Contributor
  • July 9, 2020
Just to confirm, if you duplicate the table in SQL Server Management Studio, can you see the table in QGIS? Or still nothing? Additionally, if you write to a new test table instead of dropping and creating is there any difference?
brandonguo
Contributor
Forum|alt.badge.img+3
  • brandonguoContributor
  • Author
  • Contributor
  • July 12, 2020
chrisatsafe wrote:
Just to confirm, if you duplicate the table in SQL Server Management Studio, can you see the table in QGIS? Or still nothing? Additionally, if you write to a new test table instead of dropping and creating is there any difference?

Still nothing,

There are warnings after running the workbench:

Microsoft SQL Server Spatial Writer: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error 'Description: Class not registered'. Connection string 'Provider=MSOLEDBSQL;

Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. Connection string

D
Forum|alt.badge.img

in QGIS if you add the layer via the Layer Menu using the "Add MSSQL Spatial Layer" option you can see which column QGIS is using for primary_key and change it. It sounds like QGIS is picking the wrong column.

brandonguo
Contributor
Forum|alt.badge.img+3
  • brandonguoContributor
  • Author
  • Contributor
  • July 15, 2020
davebarter wrote:

in QGIS if you add the layer via the Layer Menu using the "Add MSSQL Spatial Layer" option you can see which column QGIS is using for primary_key and change it. It sounds like QGIS is picking the wrong column.

Which QGIS version should I use? Couldn't change the primary_key.

Reply


Helpful Members This Week

Community Stats

30,928
Posts
117,221
Replies
38,733
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.