Page 1 of 1
DSN Empty: list returned from host xxx
Posted: Mon Feb 28, 2005 8:40 am
by Triton46
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?
Posted: Mon Feb 28, 2005 8:47 am
by richdhan
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
Posted: Mon Feb 28, 2005 8:54 am
by Triton46
I found it. I had the uvodbc.config in DSEngine but not in the Project (been a while since I set one up).
Posted: Mon Feb 28, 2005 3:17 pm
by ray.wurlod
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)