This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am having some weird issues in trying to connect to Microsoft SQL Server with an OleDB connection. I have Spatial data (Geometry) in my database, and when I try to pull from an ODBC connection, I manage to get all the data, including the geometry data to come through for 2 out of 20 datasets. All the rest I get the data, but I dont get the Geometry data.
So the work around was to try use an OleDB connection to the database. When I connect this way and test the connection, I get a successful connection. However, when I try to run the actual connection, it gives me an error that connection is unsuccessful.
Has anybody got any experience to fix this issue??