uvodbc.config file

m_mani87 · Post by **m_mani87** » Mon Sep 02, 2013 5:10 am

Hi all,

I know that uvodbc.config is used to connect to remote database.
But the file is present in two places

1) $DSHOME
2) In each Project Path

But the one that is present in thr Project Path has only localuv like below

[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

If i want to connect to a new database is it enough to add in the file in DSHOME path?
If so what is the significance of the file in project path?

chulett · Post by **chulett** » Mon Sep 02, 2013 7:15 am

You need to update the information in $DSHOME as well as in every project that you want to use the ODBC connection.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Sep 03, 2013 8:07 am

And as to the other point (significance), the file can be used to limit access to ODBC connections on a project level (by excluding them from the specific project config file).

m_mani87 · Post by **m_mani87** » Wed Sep 04, 2013 8:57 am

Thanks all
Some what it answers my questions. So i am marking it as resolved

chulett · Post by **chulett** » Wed Sep 04, 2013 10:21 am

"Some what"? Give us a shot at clarifying whatever remains unanswered or unclear...