Bug report #8022

Ubuntu DSN connection

Added by Laurentiu Mihai over 7 years ago. Updated over 7 years ago.

Status:Closed
Priority:High
Assignee:-
Category:Data Provider/MSSQL
Affected QGIS version:1.8.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:16868

Description

Hello,

I have a problem. Follow Ubuntu + FreeTDS + unixODBC + qgis 1.8.0

Settings FreeTDS
[MSSQL]
host = 192.168.0.1
port = 1433
tds version = 7.0

Settings /etc/odbcinst.ini
[FreeTDS]
Description = FreeTDS driver
Driver = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
Setup=/usr/lib/i386-linux-gnu/odbc/libtdsS.so
FileUsage = 1
UsageCount = 1

Settings /etc/odbc.ini
[SQLC]
Description = MS SQL Server
Driver = FreeTDS
Server = 192.168.0.1
UID = USERNAME
PWD = PASSWORD
ReadOnly = No
Port = 1433
Database = TEST

Setting QGIS
Add MSSQL Spatial Layer
Button: New
  1. In pop-up complete #
    Name: TEST
    DSN: SQLC
    Username: USERNAME
    Password: PASSWORD

Check Save username
Check Save password

TEST "Connection to was successful"

Ok, now download Layer from server. It's ok
SAVE Project to my computer, Close QGIS.

If i want to open Project, in qgis i have this error:
Handle bad layers: "service='SQLC' estimatedmetadata=true srid=32635 type=POLYGON table="dbo"."TEST" (SP_GEOMETRY) sql="

Why ?

History

#1 Updated by Giovanni Manghi over 7 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed

Questions need to be posted on the users/developers mailing lists or IRC or gis.stackexchange.com the tracker is for bug reports and feature requests. Cheers!

Also available in: Atom PDF