Skip to main content
Solved

Additional connection properties - new TX version(s)


vw-victa
Contributor

Hello,

for one of our customers we are using the “Odbc Data Provider” so that we can a local ODBC with a specific driver called "Progress OpendeEdge” (Source: ProFashionALL). We need to add Additional Connection Properties for this datasource. In the older TX versions (< v20) we could add these Additional Properties. This is missing in the new TX version so we can't connect to this source at the moment. This is the main source and crucial in this project. Anyone ran into this issue or has a workaround?

There is a workaround but this must done at the source where they store the credentials in the “_user table". I hoped there would be a solution at our (TX) side.

 

Hope to hear.

Best answer by Christian Hauggaard

Hi @vw-victa it should work if you specify the user ID and Password in the registry editor 

 

View original
Did this topic help you find an answer to your question?

12 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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?


vw-victa
Contributor
  • Author
  • Contributor
  • 17 replies
  • June 19, 2023

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.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @vw-victa it should work if you specify the user ID and Password in the registry editor 

 


vw-victa
Contributor
  • Author
  • Contributor
  • 17 replies
  • June 19, 2023

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?

 

 


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

 


vw-victa
Contributor
  • Author
  • Contributor
  • 17 replies
  • June 19, 2023

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.


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 649 replies
  • June 20, 2023

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.


vw-victa
Contributor
  • Author
  • Contributor
  • 17 replies
  • June 20, 2023

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.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


vw-victa
Contributor
  • Author
  • Contributor
  • 17 replies
  • June 26, 2023

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!


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


vw-victa
Contributor
  • Author
  • Contributor
  • 17 replies
  • July 12, 2023

@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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings