connect via system DSN?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
bayesian
Posts: 1
Joined: Tue 24 May 2022 00:23

connect via system DSN?

Post by bayesian » Tue 24 May 2022 00:27

When we connect to a database, we have to supply connection credentials (username, password, etc). This means that all users connecting to a database need to have, in plaintext, a username and password. I'd prefer to distribute a system DSN to all users' computers via a GPO, and use that connection. Can dbForge MySQL connect via a system DSN rather than with a username/password?

michabbb
Posts: 217
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

Re: connect via system DSN?

Post by michabbb » Wed 31 Aug 2022 16:20

i assume the answer is no.

https://stackoverflow.com/a/4519946

tfrancois
Posts: 44
Joined: Mon 11 Jun 2018 23:58

Re: connect via system DSN?

Post by tfrancois » Wed 31 Aug 2022 23:21

Not sure if this is helpful to you, but did you not explore this:

From Devart:
https://www.devart.com/odbc/mysql/compatibility.html

From MySQL: (8.0 version but I believe there are versions for MySQL 5.7 as well)
https://dev.mysql.com/downloads/connector/odbc/

Respectfully, Google is your friend.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: connect via system DSN?

Post by dzhanhira » Thu 08 Sep 2022 13:42

dbForge for MySQL allows you to use ODBC drivers as data sources and work with them through a pre-created System DSN. As such a source we suggest: https://www.devart.com/odbc/mysql/compatibility.html

paanjii2
Posts: 1
Joined: Tue 13 Sep 2022 05:46

Re: connect via system DSN?

Post by paanjii2 » Wed 21 Sep 2022 09:46

If a system DSN has already been configured that you want to use, select the Use System DSN option. Enter the System DSN or choose it from the dropdown that appears. Enter a Password if necessary. Optionally click Test connection above.

myfiosgateway.one
mobdro

valentinkohler
Posts: 1
Joined: Tue 25 Oct 2022 07:23

Re: connect via system DSN?

Post by valentinkohler » Tue 25 Oct 2022 07:27

I am also experiencing the same issue. fnf mods
But because of your conversation, I was able to find a solution to my issue.

Post Reply