Consider the following scenario:
Additionally, you may find that the Test Connection and Sample Query options in the Data Access Tool (DAT) that is included with OLE DB Provider for DB2 return errors when OLE DB Provider for DB2 tries to connect to the IBM DB2 database.
- You create a linked server in Microsoft SQL Server by using Microsoft OLE DB Provider for DB2 to connect to an IBM DB2 database.
- The IBM DB2 database is configured to use code page 923 (ISO 8859-15 ASCII).
- A query is issued from the linked server.
OLE DB provider "DB2OLEDB" for linked server "linked_server_name" returned message "One or more errors occurred during processing of command.".
OLE DB provider "DB2OLEDB" for linked server " linked_server_name " returned message "".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "DB2OLEDB" for linked server " linked_server_name"
OLE DB provider "DB2OLEDB" for linked server " linked_server_name " returned message "".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "DB2OLEDB" for linked server " linked_server_name"
Additionally, you may find that the Test Connection and Sample Query options in the Data Access Tool (DAT) that is included with OLE DB Provider for DB2 return errors when OLE DB Provider for DB2 tries to connect to the IBM DB2 database.