[ODBC-387] Connection string superseded by default settings Created: 2023-03-24 Updated: 2023-03-24 Resolved: 2023-03-24 |
|
| Status: | Closed |
| Project: | MariaDB Connector/ODBC |
| Component/s: | General |
| Affects Version/s: | 3.1.17 |
| Fix Version/s: | 3.2.0, 3.1.18 |
| Type: | Bug | Priority: | Major |
| Reporter: | David Gausmann | Assignee: | Lawrin Novitsky |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows Server |
||
| Attachments: |
|
| Description |
|
I installed now my application, which connects via the ODBC driver with named pipe to mariadb, to the customer's server.
There was no connection possible. The response was always that the username or password is wrong. But both were correct. After some attempts the customer told me that he has an additionally installed MySQL server running on the same machine (installed as service via xampp; listening only on port 3306). I've tried much combinations with the connection string. On the customer's server the following settings were completely ignored:
This is a bug from my point of view, that settings from my connection string are ignored. I explicitely said via NAMEDPIPE=1 that no networking should be used, but it is ignored. We installed the same MariaDB driver like on my computer (same MSI file). On my computer everything works fine. I have absolutely no idea why this happens. What could this be? Is there something like a TNSNAMES.ORA on Oracle systems which takes precedence over connection strings? |
| Comments |
| Comment by David Gausmann [ 2023-03-24 ] |
|
One more information: PHP and MySQL Workbench are able to connect to MariaDB via Named Pipe. |
| Comment by Lawrin Novitsky [ 2023-03-24 ] |
|
Thank you for your report. I agree that is a bug. I think this has been sorted out in the scope of your |
| Comment by David Gausmann [ 2023-03-24 ] |
|
If you attach an archive with the DLLs I need to replace on the customer's server, then I can test it. |
| Comment by Lawrin Novitsky [ 2023-03-24 ] |
|
Well, not |
| Comment by Lawrin Novitsky [ 2023-03-24 ] |
|
Not on the server, but on the machine where you or he/she connecting from. If you want to try, please tell me 32b or 64b you need |
| Comment by David Gausmann [ 2023-03-24 ] |
|
In this case client and server are the same machine. I need 64 bit. |
| Comment by Lawrin Novitsky [ 2023-03-24 ] |
|
Well, I've attached the debug dll built from current 3.1 repo state. |