Does MS OLEDB stage support 64-bit SQL server OS

[chitravallivenkat]

Hi,

We have DS application running fine in the 32-Bit Datastage and 32-bit Database servers. Now we want to change 32-bit DB server to 64-bit server. But Datastage server remains the same.

Application uses MS OLEDB stage to connect to SQL server.

Now my question is:
Will MS OLEDB stage support 64-bit SQL server?

if not, what is the solution for this to support?

Thanks in advance.

Venkat