I am trying to setup a connection from our DS Server (7.5.1) to SQL Server 2000 db. Since we do not have a direct driver, I am using ODBC to set up the connection.
I have gone through the documentation provided with DS. Can anyone please list down any information or problems they encountered which I need to take care of to make the connection ?
Hi,
SQL Server 2005 is not certified with DS 7.5.1A and especially you are going to have problems with ODBC Enterprise Stage and DRS Stage. However, I was told by IBM/Ascential technical support to upgrade the DataDirect ODBC drivers to version 5.2 as a workaround.