Samuel Pizarro
16-Sep-2018, 03:59 PM
Hi Vincent...
I decided to create a new thread for our discussion started in that other thread (https://support.dataaccess.com/Forums/showthread.php?63291-Another-ancient-request), as they are different in nature.
The answer for your question is "Yes and No" at same time.
I tried to provide a step by step over there, but it looks like I was not clear enough.. so here it goes again.
This was my original DFConn.id file
[connection1]
id=db2sample
driver=DB2_DRV
connection=DSN=SAMPLE
UID=samuel
1. Open dbExplorer, and open the target Workspace.
2. dbExplorer will prompt you the login dialog, as expected (so far so good).
3. Open, "Connection IDs" dialog, menu Database -> Connection IDs
The dialog will be shown
4. Click in the Edit button.
This is what I had in "Database Connections" dialog before clicking in Edit button.
12253
5. Do nothing inside "Edit a Connection" dialog. Just click in "OK" button.
6. When you get back to "Database Connections" dialog, you can see the connectionID was changed.
The connectino string was messed up. all info got duplicated.
The "Enabled" attribute was changed to "no"
The "Active" attribute was changed to "no"
The Save buton got enabled, (it recognized there was change made and save become enalbed)
12254
7. At this point, the real DFConn.id file it not changed yet. But if you click on Save button, it will be wrongly changed.
But , if you try to exit the dialog without saving, you receive a warning that you have changes that were not saved yet (this is good), and if you are like me,, I normally save ...
This is the final dfConn.id file after this exercise
[connection1]
id=db2sample
driver=DB2_DRV
connection=DSN=SAMPLE;DSN=SAMPLE;UID=samuel
UID=samuel
disabled=yes
I Posted this on 19.1 forun, but it happens on 19.0 as well.
I tested the same procedure on Studio "Connection IDs" dialog and the issue does not happens over there.
Actually, They are different each other, and behave differently...
Studio connection manger, has option for DSN or DSN-less connection strings. dbExplorer does not have this option.
Studio does not fill the connection-string in "Extra" field. But dbExplorer does.
12255
Thanks
I decided to create a new thread for our discussion started in that other thread (https://support.dataaccess.com/Forums/showthread.php?63291-Another-ancient-request), as they are different in nature.
The answer for your question is "Yes and No" at same time.
I tried to provide a step by step over there, but it looks like I was not clear enough.. so here it goes again.
This was my original DFConn.id file
[connection1]
id=db2sample
driver=DB2_DRV
connection=DSN=SAMPLE
UID=samuel
1. Open dbExplorer, and open the target Workspace.
2. dbExplorer will prompt you the login dialog, as expected (so far so good).
3. Open, "Connection IDs" dialog, menu Database -> Connection IDs
The dialog will be shown
4. Click in the Edit button.
This is what I had in "Database Connections" dialog before clicking in Edit button.
12253
5. Do nothing inside "Edit a Connection" dialog. Just click in "OK" button.
6. When you get back to "Database Connections" dialog, you can see the connectionID was changed.
The connectino string was messed up. all info got duplicated.
The "Enabled" attribute was changed to "no"
The "Active" attribute was changed to "no"
The Save buton got enabled, (it recognized there was change made and save become enalbed)
12254
7. At this point, the real DFConn.id file it not changed yet. But if you click on Save button, it will be wrongly changed.
But , if you try to exit the dialog without saving, you receive a warning that you have changes that were not saved yet (this is good), and if you are like me,, I normally save ...
This is the final dfConn.id file after this exercise
[connection1]
id=db2sample
driver=DB2_DRV
connection=DSN=SAMPLE;DSN=SAMPLE;UID=samuel
UID=samuel
disabled=yes
I Posted this on 19.1 forun, but it happens on 19.0 as well.
I tested the same procedure on Studio "Connection IDs" dialog and the issue does not happens over there.
Actually, They are different each other, and behave differently...
Studio connection manger, has option for DSN or DSN-less connection strings. dbExplorer does not have this option.
Studio does not fill the connection-string in "Extra" field. But dbExplorer does.
12255
Thanks