Benjamin, What is the content of the geometry_columns metadata table in your database?
Best regards, Tamas 2012/7/11 Benjamin <[email protected]> > Hi, I try to connect my application to a DB with the framework Ogr (with > C# warper). When I write folloing code, Ogr methods view the DB but can't > read it. [code] Ogr.RegisterAll(); const string connectionString = > @"Server=SERVEUR_NAME;Database=DATABASE_NAME;trusted_connection=yes"; > DataSource pnn3 = Ogr.Open("MSSQL:" + connectionString, 0); if (pnn3 == > null) throw new IOException("Creation of output file failed."); > Console.WriteLine("pnn3.Name\t=" + pnn3.name); > Console.WriteLine("pnn3.GetLayerCount()\t= " + pnn3.GetLayerCount()); > [/code] It display : [quote] > Server=SERVEUR_NAME;Database=DATABASE_NAME;trusted_connection=yes 0 > [/quote] I know my DB is view because if I switch SERVEUR_NAME and/or > DATABASE_NAME by an other name the exception is throwed On the other hand > driver don't see my layers (it displays 0, and my db has near to 30 > layers). If someone have already connected to db MSSQL, can him suggests me > an example of code (in C or C++ it is also great, it may help me) ? Notes: > I use gdal-1.9.0 (with MSSQL Driver) link usefull : MSSQLSpatial - > Microsoft SQL Server Spatial > Database<http://www.gdal.org/ogr/drv_mssqlspatial.html>Best regards, Benjamin. > ------------------------------ > View this message in context: [gdal-dev] Ogr to access MSSQL > DB<http://osgeo-org.1560.n6.nabble.com/gdal-dev-Ogr-to-access-MSSQL-DB-tp4987592.html> > Sent from the GDAL - Dev mailing list > archive<http://osgeo-org.1560.n6.nabble.com/GDAL-Dev-f3742093.html>at > Nabble.com. > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
