Dear Christophe! Have you tried connecting with ogrinfo?
Volker Am Dienstag 12 April 2011, 12:40:47 schrieb Christophe B: > Hello, > > We have encountered a problem on version 1.7 of QGIS can support the > connection to SQL Server 2008. > > When it connects to the base layer does not contain any vector object and > the attribute table contains the correct columns and many rows, but they > all contain "ERROR" ... > > One of you has it managed to run this connection? > > Thank you! > > Christophe Baume > > Code : > > the sql table is defined as : > > CREATE TABLE [dbo].[T_CommuneGeographie]( > > [COMGEO_Id] [uniqueidentifier] ROWGUIDCOL NOT NULL, > > [COMGEO_Commune_COM_Id] [uniqueidentifier] NOT NULL, > > [COMGEO_Geographie] [geography] NOT NULL, > > [COMGEO_DateDebut] [date] NULL, > > [COMGEO_DateFin] [date] NULL, > > CONSTRAINT [PK_T_CommuneGeographie] PRIMARY KEY CLUSTERED > > ( > > [COMGEO_Id] ASC > > )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = > OFF , ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] > > ) ON [PRIMARY] > > > > the lines entered into the python console: > > conn_string = > "MSSQL:server=.\SQLExpress;database=ObservatoireCommerce;trusted_connection > =yes;tables=dbo.T_CommuneGeographie(COMGEO_Geographie)" > > qgis.utils.iface.addVectorLayer(conn_string,'test','ogr') _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
