Page 1 of 1
How to configure DSN in ODBC on unix for sql server 2000
Posted: Tue Jul 03, 2007 11:41 pm
by priyadarshikunal
Hi all,
we have installed DataStage 8.0.1 on AIX 5.2 but we are not able to see SQL Server Enterprise Stage.
An any one tell me what are the possible causes for that?
one more thing is that
we want to create DSN to use ODBC connector on unix.
can any one tell me how to configure a DSN to use ODBC connector Stage?
Posted: Wed Jul 04, 2007 4:01 am
by CLOPES
Hello,
for dsn ODBC, you have to declarate them in the DSEngine/ODBC.ini AND in the uvodbc.config for each projects.
Good luck
Re: How to configure DSN in ODBC on unix for sql server 2000
Posted: Fri Aug 10, 2007 8:30 am
by rv_kumar
[quote="priyadarshikunal"]Hi all,
we have installed DataStage 8.0.1 on AIX 5.2 but we are not able to see SQL Server Enterprise Stage.
An any one tell me what are the possible causes for that?
[b]one more thing is that[/b]
we want to create [b]DSN[/b] to use ODBC connector on [b]unix[/b].
can any one tell me how to configure a DSN to use ODBC connector Stage?[/quote]
Hi,
Can you tell the procedure to get the SQL Server enterprise stage on the palette?
Thanks
Vijay R
Posted: Fri Aug 10, 2007 9:08 am
by gbusson
hi, this is ODBC, no SQL Server stage.
But as it is DS 8.0, you have the Generic Database stage (i've never worked with 80, i've only seen demos)
I'm not sure.
You also may need a license to get the stage on the palette.
Posted: Fri Aug 10, 2007 9:29 am
by Ed Purcell
CLOPES wrote:Hello,
for dsn ODBC, you have to declarate them in the DSEngine/ODBC.ini AND in the uvodbc.config for each projects.
Good luck
That odbc.ini has a dot / period in front of it. .odbc.ini
It's a hidden file.
Posted: Fri Aug 10, 2007 3:52 pm
by ray.wurlod
You only get SQL Server Enterprise stage if DataStage server is installed on a Windows platform. You are on AIX.