Working with SQL Server

mydsworld · Post by **mydsworld** » Tue May 27, 2008 1:07 pm

As we don't have any Database stage for 'SQL Server', would 'ODBC Enterprise' be fine for it.

Thanks

chulett · Post by **chulett** » Tue May 27, 2008 1:11 pm

Only if you've purchased UNIX ODBC drivers that support SQL Server, which is Windows only. Which is also why you don't have a stage for it.

ray.wurlod · Post by **ray.wurlod** » Tue May 27, 2008 3:09 pm

Nah. The DataDirect drivers that ship with DataStage include one for SQL Server.

chulett · Post by **chulett** » Tue May 27, 2008 4:28 pm

Okay... could have sworn that was the standard advice we've seen here in the past. Is this new with 8.x or has that always been the case?

nm, just checked and even I have a wire driver for SQL Server here in our 7.x non-Enterprise version. Sheesh, I wonder what I was mixing this up with... or if I was just mixed up?

So, bottom line, yes - 'ODBC Enterprise' be fine for it.

ray.wurlod · Post by **ray.wurlod** » Tue May 27, 2008 8:02 pm

I only remembered it because of all the "s" characters in the driver library name.