I started using QGIS a few weeks ago. I've been able to create some very nice maps with it. I've used the OpenLayers plugins to bring in different basemaps, I've brought in shapefiles and connected to our local WMS server.
But, when I connect to our local SQL server, I can bring in shapefiles, but they don't show up. I can see all the data associated with them if I look at the properties table. QGIS even gives me the item count, if I ask for it.
Does anyone know of a reason why I wouldn't be able to see the geometry in my maps and what I might do to fix it?
Regarding coordinate system: The SQL database has everything in three different projections, SRID 3078, SRID 4326 and SRID 3857 (I don't know why). I chose one set and tried each projection. In each case, the data I brought in was the only layer in the project and the project CRS was set to match the layer CRS. Only the data from SRID 3078 was visible.
I can't see the database directly, so I don't know if there's a geometry column. Looking at all three datasets, each shows a feature count of 915. I can do a query (set filter) and the same query for all three results in 116. Nothing looks different from one to another. It's just that two of the three don't show up in the map.
I should also note that I had our IT guy who's gathered all this data and put it in the SQL database create a shapefile from one of the datasets that I needed and couldn't read. That showed up fine, too.