connecting to sqlserver

altruist · Post by **altruist** » Wed May 21, 2008 7:27 am

Hi everyone,

Can you tell me, which stage do we need to use to connect to SQL server.

And is it possible that SQL Server 2005 will be installed on Unix or can it be only installed on windows.

Thanks

wesd · Post by **wesd** » Wed May 21, 2008 2:28 pm

Use ODBC Stage

SQL Server can ONLY be installed on Windows platforms.

ray.wurlod · Post by **ray.wurlod** » Wed May 21, 2008 4:11 pm

... but there is an ODBC driver for SQL Server that can be (is) installed on a UNIX system on which DataStage is installed. Hence wesd's advice to use an ODBC Enterprise stage.