Case-sensitivity of connection string parameters
От | Mateusz Loskot |
---|---|
Тема | Case-sensitivity of connection string parameters |
Дата | |
Msg-id | CABUeae-LLQXiR2dwir+qYPn-SDHM+h4h7DT8HVzrBpe+nJzyug@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Case-sensitivity of connection string parameters
|
Список | pgsql-odbc |
Hi, I use the psqlODBC 9.2.1 with unixODBC 2.2.14 on Ubuntu 14.04. Should I expect names of connection string parameters to be case-sensitive? For instance, if I try DSN-less connection with the following connection string passed to the ODBC API call SQLDriverConnect: "Driver={PostgreSQL ANSI};Server=127.0.0.1;Database=test;UID=test;PWD=test;" I get this error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified whereas if I try this one, with the upper-case DRIVER: "DRIVER={PostgreSQL ANSI};Server=127.0.0.1;Database=test;UID=test;PWD=test;" I get successfully connected. I've couldn't find any details on the case sensitivity in the FAQ, release notes or https://odbc.postgresql.org/docs/config-opt.html The only cue might be the connection string in the VB example at the bottom of this page, where DRIVER is specified in upper-case: https://odbc.postgresql.org/docs/config.html Another cue that suggests case-sensitivity might be important is from the connection strings database: https://www.connectionstrings.com/postgresql-odbc-driver-psqlodbc/ and it says: "Please note that sslmode=require is case sensitive, it should be written in lower case letters." But, it is confusing since the https://odbc.postgresql.org/docs/config-opt.html lists this parameter as "SSLmode", but not asd "sslmode". Finally, I have tried psqlODBC 9.3.4 on Windows and there parameters work regardless of their case. Could anyone explain what case of each of the parameters is required useon Unix? Best regards, -- Mateusz Loskot, http://mateusz.loskot.net
В списке pgsql-odbc по дате отправления: