Page 1 of 1

connecting to sqlserver

Posted: Wed May 21, 2008 7:27 am
by altruist
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

Posted: Wed May 21, 2008 2:28 pm
by wesd
Use ODBC Stage

SQL Server can ONLY be installed on Windows platforms.

Posted: Wed May 21, 2008 4:11 pm
by ray.wurlod
... 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.