SQL Server Enterprise stage

Nagin · Post by **Nagin** » Thu Aug 06, 2009 11:26 am

Hey All,

I am not able to see SQL server connectivity stages in the Database Pallette. Isn't it supposed to installed by default? Is there any specific process I have to go through to get these stage?

Thanks for the help

chulett · Post by **chulett** » Thu Aug 06, 2009 12:58 pm

You only get those stages on a Windows server, as far as I know.

cppwiz · Post by **cppwiz** » Fri Aug 07, 2009 8:24 am

You have to use the ODBC Connector stage. Don't use the ODBC Enterprise stage because it has big, nasty bugs with handling date/time fields.

Sreenivasulu · Post by **Sreenivasulu** » Fri Aug 07, 2009 9:46 am

Hi All

ODBC Connector stage has been introduced first in 8.0 and ODBC Enterprise has been there since early days of datastage.

I found the ODBC Enterprise stage pretty robust. I found less locking issues with this stage compared to ODBC Connector

Only advance of ODBC Connector is it has isolation settings

Regards
Sreeni