Bug report #16190
Updated by Nyall Dawson over 5 years ago
Hello,
I think there is a problem with the MSSQL connector because I have different result if I connect with "Add a MSSQL spatial layer" or with "Add vector layer"/Database/MSSQL !
With a localhost Database, I agree everything works fine. But in this example, I don't use a local database, it is located on a virtual network through VPN (database is on a server, and I connect to this server through a VPN).
- if I connect with "Add vector layer"/Database/MSSQL (host=192.168.0.100\\SQLEXPRESS), I can connect to spatial vectors, it's OK
- if I use the same connection with "Add a MSSQL spatial layer" or with QGIS Browser, I have this error message _"[Microsoft][ODBC SQL Server Driver][SQL Server]Échec de l'ouverture de session de l'utilisateur 'XXXXX\\XXXXX'. [Microsoft][Gestionnaire de pilotes ODBC] Échec SQLSetConnectAttr du pilote QODBC3: Unable to connect"_
The thing is I need to have access not only to spatial layers, but to the whole database. And without the data connection, I can't.
Thanks for the answer.
I think there is a problem with the MSSQL connector because I have different result if I connect with "Add a MSSQL spatial layer" or with "Add vector layer"/Database/MSSQL !
With a localhost Database, I agree everything works fine. But in this example, I don't use a local database, it is located on a virtual network through VPN (database is on a server, and I connect to this server through a VPN).
- if I connect with "Add vector layer"/Database/MSSQL (host=192.168.0.100\\SQLEXPRESS), I can connect to spatial vectors, it's OK
- if I use the same connection with "Add a MSSQL spatial layer" or with QGIS Browser, I have this error message _"[Microsoft][ODBC SQL Server Driver][SQL Server]Échec de l'ouverture de session de l'utilisateur 'XXXXX\\XXXXX'. [Microsoft][Gestionnaire de pilotes ODBC] Échec SQLSetConnectAttr du pilote QODBC3: Unable to connect"_
The thing is I need to have access not only to spatial layers, but to the whole database. And without the data connection, I can't.
Thanks for the answer.