How to configure DSN in ODBC on unix for sql server 2000

[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?

[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

[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

[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.

[Ed Purcell]

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.

[ray.wurlod]

You only get SQL Server Enterprise stage if DataStage server is installed on a Windows platform. You are on AIX.