Additional connection properties - new TX version(s)

Hi @vw-victa can you please specify the additional property that you are trying to change? Can you please share a screenshot of the settings for the Odbc data source in the legacy version?

Hi Christian,

I would like to add the User ID and Password. The Windows ODBC data source comes with a popup for the password. Testing it will give a “connection succefull” result. Using the old version of TimeXtender we can add the additional opties to the ODBC data source, see image. This feature isn't support in the new version using de portal.

If you need more information please let me know.

Hi @Christian Hauggaard ,

for a standard SQL this could be a solution but for our (specific) ODBC connector (Progress OpenEdge) I can't set the password (see image). Don't know if we can add it manually?

Can you please try adding the properties by right-clicking and selecting new string value?

Hi @Christian Hauggaard ,

I added the string to the register but still no luck. It is waiting for the password (through popup) and after x seconds the time-out will occur.

In this context the following link may be useful: https://community.progress.com/s/article/2987 . So it depends on the exact driver being used.

Hi @rory.smith , thanks for your answer but unfortunately is your topic about DataDirect. If the additional connection properties aren't available within TimeXtender (or on the roadmap) I need to ask the administrator of the database if he can add these credentials to the _User table.

Thanks so far and I will give a reply to the topic if there is any news or it can be closed.

Hi @vw-victa did you get a chance to test adding the credentials to the _User table?

Hi @Christian Hauggaard , the credentials were already added to the _User table. Adding the credentials to the register did the trick. I thought it didn't but I need to be patient I guess.

I've marked the “best anwser” and for now it is solved.

Thanks!

@vw-victa Great! what were the final names for the credential string values in the registry editor - “User Id” and “Password”? 

@Christian Hauggaard, sorry for the late response.

• Regedit > HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
• “Add String” within the ODBC connection you need (LogonID is already filled)
• Name = Password
• Value = **yourpassword**

Within TimeXtender add the source and add all the table. Using “Let me select tables” didn't work for me. Also using this source I needed to change the SCHEMA to "TABLE_SCHEM” without the "A”. There are two fields with TABLE_SCHEMA.

Thank you all for the help.