DSN Empty: list returned from host xxx

Triton46 · Post by **Triton46** » Mon Feb 28, 2005 8:40 am

I've added an entry to uvodbc.config and .odbc.ini. This works on our other servers but I can't find what is different here. Am I missing something?

richdhan · Post by **richdhan** » Mon Feb 28, 2005 8:47 am

Hi,

You can have different uvodbc.config for different projects. Are you checking the right project directory?

Moreover, whatever is defined at project level overrides that given at dshome level.

HTH
--Rich

Triton46 · Post by **Triton46** » Mon Feb 28, 2005 8:54 am

I found it. I had the uvodbc.config in DSEngine but not in the Project (been a while since I set one up).

ray.wurlod · Post by **ray.wurlod** » Mon Feb 28, 2005 3:17 pm

Having uvodbc.config in the $DSHOME directory and not in the projects is a perfectly valid approach, though you lost the ability to have different sets of DSNs per project.

When a BCI call to connect to a DSN is made, DataStage searches first in the project directory for uvodbc.config, next in the $DSHOME directory, and finally in /etc (or its Windows equivalent %WINNT_ROOT%\System32\drivers\etc)