Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to open the ODBC.INI data sources root

Dmitrii DunaevAug 13 2018 — edited Aug 15 2018

Hello everyone.

I get "Unable to open the ODBC.INI data sources root " in the log file (srv\info\tterrors.log) every time Oracle tries to start the server.

Documentation describes this error by saying "Windows platform only. TimesTen Server could not open HKEY_LOCAL_MACHINE\SOFTWARE \ODBC\ODBC.INI\ODBC Data Sources key from registry. Contact customer support for assistance."

Does anybody know how to fix the issue?

Thank you in advance

Comments

SH_INT
Answer

Why won't your finance team accept the approach of logic accounts? This is the obvious solution to your problem. In FDM or FDMEE you can only load on piece of data to one target intersection. If you want to load the same piece of data to multiple target intersections then you need to have that piece of data repeated in the source data nad then you will still need something in the source that could uniquely identify each of those copies so you could map appropriately. As mentioned that is one of the primary functions of logic accounts, other approaches are likely to be messy, more prone to error and a lot more difficult to audit.

Marked as Answer by MarkSmithHFM · Sep 27 2020
1 person found this helpful
MarkSmithHFM

Hi SH,

Thanks for your reply.

I agree with you 100% that logic accounts are the way to go here.  I was just trying to find out if there were any other approaches that would be relatively straightforward and easy to implement.

Other approaches would definitely not be elegant and would involve scripting and probably rewriting file or copying data records via scripts which to me are non-starters.

You reinforced my opinion.   I'll develop my solution using logic accounts.

Thanks,
Mark

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 12 2018
Added on Aug 13 2018
#database-key-features, #timesten-in-memory-database
9 comments
684 views