Hi all
I am choose between SQL Server Enterprise and DRS connector (with wire protocol) to connect our SQL Server database.
Any suggestion on which one we should use?
Thanks
SQL Server Enterprise OR DRS connector?
Moderators: chulett, rschirm, roy
thanks asorrell
i did some further research on it:
The Microsoft SQL Server Client cannot be installed on UNIX. Because of this, The DRS plug-in stage on Windows uses the Microsoft OLE DB API for Bulk Load operations and the API is not available on UNIX.
The DRS Connector stage does not support Informix, Sybase and Microsoft SQL Server database types.
When a Dynamic RDBMS stage configured for one of these database types is migrated to a DRS Connector stage, the Database type property in the DRS Connector stage is set to value ODBC.
And SQL Server Enterprise stage use native SS connectors, as our engine tire installed on window server.
referencee read:
https://www.ibm.com/support/knowledgece ... RS060.html
https://www.ibm.com/support/knowledgece ... erver.html
https://www.ibm.com/support/knowledgece ... RS057.html
and asorrell :
do you use Wire protocol to connect to sql server?
thanks
abyss
i did some further research on it:
The Microsoft SQL Server Client cannot be installed on UNIX. Because of this, The DRS plug-in stage on Windows uses the Microsoft OLE DB API for Bulk Load operations and the API is not available on UNIX.
The DRS Connector stage does not support Informix, Sybase and Microsoft SQL Server database types.
When a Dynamic RDBMS stage configured for one of these database types is migrated to a DRS Connector stage, the Database type property in the DRS Connector stage is set to value ODBC.
And SQL Server Enterprise stage use native SS connectors, as our engine tire installed on window server.
referencee read:
https://www.ibm.com/support/knowledgece ... RS060.html
https://www.ibm.com/support/knowledgece ... erver.html
https://www.ibm.com/support/knowledgece ... RS057.html
and asorrell :
do you use Wire protocol to connect to sql server?
thanks
abyss