System DSN for excel

saprebv · Post by **saprebv** » Wed Feb 23, 2005 3:34 pm

I found few posts on how to read excel in DS. Everybody told create system DSN and use ODBC stage. How do I create system DSN in UNIX ?

Regards,
Balkrishna Sapre

ray.wurlod · Post by **ray.wurlod** » Wed Feb 23, 2005 8:21 pm

User/system/file DSNs are only relevant in the Windows environment.

In a UNIX environment you simply create DSNs. You do so by editing the .odbc.ini file in $DSHOME directory. You also edit uvodbc.config file in any project needing to use that DSN, or use a central uvodbc.config file in the $DSHOME directory.

roy · Post by **roy** » Thu Feb 24, 2005 8:32 am

Hi,
All fair and square but do you have an ODBC driver for excell files on unix ???

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Feb 24, 2005 10:11 am

Yep. Even though I have not tried them, I have seen adverts that claim to do so.