ODBC is not installed on the system

chulett · Post by **chulett** » Mon Jun 22, 2009 1:19 pm

I've never had to change or add anthing to that 'header' area.

sjfearnside · Post by **sjfearnside** » Mon Jun 22, 2009 2:06 pm

This is one of the first problem the onsite vendor consultants experienced when developing using V8.0.1. It could be totally wrong or something new with V8X. Try it and we will know if it is wrong. If it is wrong I will scratch that from my notes, just let me know the information was wrong.

thanks

chulett · Post by **chulett** » Mon Jun 22, 2009 2:18 pm

Interesting... I should have added that my reply was strictly referencing pre-8 installations and could very well have changed in the new release. I'll need to test that when I get some time on our 8.1 server.

shareeman · Post by **shareeman** » Mon Jun 22, 2009 2:38 pm

I didn't think that was required but i've tried your suggestion anyways and it has not worked.

Any other checks and balances that i may have missed?

sjfearnside · Post by **sjfearnside** » Mon Jun 22, 2009 3:03 pm

So do you have other odbc connections working in V8x that do not have a header file? If so then that would be a strong indication that the header file is not needed and I can eliminate that from my notes on the requirements for setting up the odbc.ini file. I have not worked with Oracle and DataStage together but I see you do not have a HostName value either.

Sorry if I have provided bad information.

shareeman · Post by **shareeman** » Mon Jun 22, 2009 5:12 pm

I've resolved this issue.

The inclusion of the DSN in the header of the .odbc.ini file is not required (IMHO). I reckon you can safely preclude that from your notes.

My issue pertained to a specific library file that was missing.

Thank you all for your sincere attempts to crack this one.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 22, 2009 5:22 pm

Beware that wired and non-wired ODBC drivers operate differently.

chulett · Post by **chulett** » Mon Jun 22, 2009 6:39 pm

shareeman wrote:I've resolved this issue.

My issue pertained to a specific library file that was missing.

Could you please share the library file's name and what you needed to do to bring it back from the missing? It would help future searchers who come here with the same issue.

Thanks!

shareeman · Post by **shareeman** » Thu Jun 25, 2009 5:44 am

The libodbc library file needed to be brought under the purview of the LD_LIBRARY_PATH variable.

Would have shared that information earlier but needed to unit test to ensure it works across the board. It does.