When trying to connect to a Sybase server using SQL Server Migration Assistant for Sybase, you may get the following error message.
Error collecting data. See the inner exception for details.
Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
When trying to connect to a Sybase server using SQL Server Migration Assistant for Sybase, you may get the following error message.
Error collecting data. See the inner exception for details.
SQL Server Migration Assistant (SSMA) uses Sybase’s OLEDB provider to connect to Sybase. The error generally occurs when the Sybase's OLEDB provider is not installed on the system where SSMA is running.
Install Sybase OLEDB provider on the system that you are using to launch SSMA. You can install the providers from the Sybase product media. Note: The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
Keywords: vkball, kb