When i try to make a Snowflake ODBC connection with auth:externalbrowser it fails at QGIS databaseconnection in menu new vectorlayer. The ODBC connection works fine in Excel. The username is in format firstname.lastname@company.com.
Steps to reproduce the issue
ODBC-64bits
User DNS:
name : snowflake
user: firstname.lastname@company.com
auth: externalbrowser
QGIS
click on Menuoption: Open Datasource manager -> Vector -> source type: Database
Data type : ODBC
Authentication:
User name: firstname.lastname@company.com
Password: empty because of ODBC externalbrowser choise
When i click on "test Connection" i first get the external browser verification from the ODBC settings wich is alright.
_But the there is the error message: "Connection failed - Check settings and try again."
Extended error information: Unable to initialize ODBC connection to DSN for firstname.lastname@company.com@snowflake,
"It seems that the email in the username is not handled very well, and the extra 'at' sign confuses me. Also, the comma at the end seems odd."
Versions
QGIS version
3.38.2-Grenoble
QGIS code revision
130c432394
Qt version
5.15.13
Python version
3.12.5
GDAL/OGR version
3.9.2
PROJ version
9.4.0
EPSG Registry database version
v11.004 (2024-02-24)
GEOS version
3.12.2-CAPI-1.18.2
SQLite version
3.45.1
PDAL version
2.6.3
PostgreSQL client version
16.2
SpatiaLite version
5.1.0
QWT version
6.2.0
QScintilla2 version
2.14.1
OS version
Windows 10 Version 2009
What is the bug or the crash?
When i try to make a Snowflake ODBC connection with auth:externalbrowser it fails at QGIS databaseconnection in menu new vectorlayer. The ODBC connection works fine in Excel. The username is in format firstname.lastname@company.com.
Steps to reproduce the issue
ODBC-64bits
User DNS:
name : snowflake
user: firstname.lastname@company.com
auth: externalbrowser
QGIS click on Menuoption: Open Datasource manager -> Vector -> source type: Database
Data type : ODBC
When i click on "test Connection" i first get the external browser verification from the ODBC settings wich is alright. _But the there is the error message: "Connection failed - Check settings and try again." Extended error information: Unable to initialize ODBC connection to DSN for firstname.lastname@company.com@snowflake,
"It seems that the email in the username is not handled very well, and the extra 'at' sign confuses me. Also, the comma at the end seems odd."
Versions
QGIS version 3.38.2-Grenoble QGIS code revision 130c432394 Qt version 5.15.13 Python version 3.12.5 GDAL/OGR version 3.9.2 PROJ version 9.4.0 EPSG Registry database version v11.004 (2024-02-24) GEOS version 3.12.2-CAPI-1.18.2 SQLite version 3.45.1 PDAL version 2.6.3 PostgreSQL client version 16.2 SpatiaLite version 5.1.0 QWT version 6.2.0 QScintilla2 version 2.14.1 OS version Windows 10 Version 2009
Active Python plugins CityJSON-loader 0.8.1 StreetView 3.2 db_manager 0.1.20 grassprovider 2.12.99 MetaSearch 0.3.6 processing 2.12.99
Supported QGIS version
New profile
Additional context
No response