Bug report #8022
Ubuntu DSN connection
| 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
Add MSSQL Spatial Layer
Button: New
- 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 almost 11 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!