Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
147
<1776-940>: Column 1 (CustomerID) type is nchar(5) [DBTYPE_WSTR].
<1776-940>: Column 2 (CompanyName) type is nvarchar(40) [DBTYPE_WSTR].
<1776-940>: Column 3 (ContactName) type is nvarchar(30) [DBTYPE_WSTR].
<1776-940>: Column 4 (ContactTitle) type is nvarchar(30) [DBTYPE_WSTR].
<1776-940>: Column 5 (Address) type is nvarchar(60) [DBTYPE_WSTR].
<1776-940>: Column 6 (City) type is nvarchar(15) [DBTYPE_WSTR].
<1776-940>: Column 7 (Region) type is nvarchar(15) [DBTYPE_WSTR].
<1776-940>: Column 8 (PostalCode) type is nvarchar(10) [DBTYPE_WSTR].
<1776-940>: Column 9 (Country) type is nvarchar(15) [DBTYPE_WSTR].
<1776-940>: Column 10 (Phone) type is nvarchar(24) [DBTYPE_WSTR].
<1776-940>: Column 11 (Fax) type is nvarchar(24) [DBTYPE_WSTR].
The following example was received when attempting to run a map to retrieve data
from a table in an SQL Server 7.0 database.
<1324-3020>: Validating the adapter command...
<1324-3020>: Database type is MS SQL Server 7
<1324-472>: Connecting...
<1324-472>: Datalink: MY_NT_SERVER\\test
<1324-472>: UserId : test
<1324-472>: Password:****
<1324-472>: OLE DB Error code: 0x80004005
<1324-472>: [DBNMPNTW]Specified SQL server not found.
<1324-472>: Returned status: (-3) No error text found
In this example, the following lines:
<1324-472>: OLE DB Error code: 0x80004005
<1324-472>: [DBNMPNTW]Specified SQL server not found.
indicate the OLE DB provider-specific error code and the corresponding error
description. The last line (beginning with Returned status:) indicates the error
code returned by the adapter that caused the map to fail.
This information can be used, along with the SQL Server documentation, to resolve
the problem. In this particular example, the error was caused by typing the
incorrect server name in the SQL Server 7.0 Server settings in the Database
Definition dialog box, rather than by selecting the name from the list of servers.
In this example, the server name was incorrectly entered as
MY_NT_SERVER,
instead of its actual name (
MY_NT_SRVR).