SQL Server connection with GRASS

Question

Is it possible to connect to a SQL Server database with GRASS?

I tried this way:

>db.connect driver=ODBC database='dbname=mydb,host=myserv'
(Mon Dec 12 15:34:27 2016) Completed (0 sec)`

But next, when I try to show a list of tables:

>db.tables
-p                                                                    
ERROR: Unable to open database <dbname=mydb,host=myserv>

The database is hosted on a server on my local network and I use GRASS 7.0.5 and SQL Server 12

til_b · Accepted Answer · 2016-12-12 15:54:36Z

1

Your connection string probably is wrong (has comma instead of semicolon). Try using something like

db.connect driver=ODBC database='dbname=mydb;host=myserv'

and then use

db.login

answered Dec 12 '16 at 15:47

til_b

3,14215 silver badges32 bronze badges

I tried but without success. Judging by this tutorial northrivergeographic.com/… ,it seems to be a comma separator and apostrophes are not necessary. I tried with the server's IP adress instead of the name, and also using db.login first. It doesn't work. – Drvr3 Dec 13 '16 at 8:30
Please check the documentation in GRASS GIS 7 as well: grass.osgeo.org/grass70/manuals/db.connect.html#odbc may require the use of db.login grass.osgeo.org/grass70/manuals/db.login.html – markusN Dec 14 '16 at 7:02

add a comment |

1 Answer 1