40169 S1021HY021Inconsistent descriptor information
40170 S1094HY104Invalid precision or scale value
40171 S1096HY096Invalid information type
40172 S1104HY104Invalid precision value
40173 S1105HY105Invalid parameter type
40174 S1106HY106Fetch type out of range
40175 S1107HY107Row value out of range
40176 S1109HY109Invalid cursor position
40177 S1111HY111Invalid bookmark value
40178 S1C00HYC00Optional feature not implemented
40179 S1T00HYT00Login timeout expired
40180 0800308003Connection does not exist
40184 22003HY019Non-character and non-binary data sent in pieces
40185 S1108HY108First parameter in {rpc command represents stored procedure return value and has to be defined as output parameter
40186 S1109HY109{rpc command is automaticly prepared, prepare is not needed
40187 S1110HY110When executing {rpc command user is required to Set Parameter Information for all parameters
40188 S1111HY111{rpc commands can not use server side cursors
40190 2400007005Prepared statement is not a cursor-specification
40192 S1011HY020Attempt to concatenate to a null or default value
40193 HY000HY000Cannot insert or update columns from multiple tables.
40194 S1016HY016Cannot modify an implementation row descriptor
40195 S1004HY004Invalid SQL data type
40197 2201522015Interval field overflow
40198 S1007HY007Associated statement is not prepared
40199 S1009HY024Invalid attribute value
40200 S1009HY024Database is invalid or cannot be accessed
40201 S1000HY000Connection is not enabled for BCP
40202 S1000HY000Unable to derive parameter information for a temporary stored procedure.
40203 S1000HY000ODBCBCP.dll is not compatible with 'SQL Native Client' driver. Please configure 'SQL Server' driver for the DSN or connection string
40205 S1000HY000Unicode conversion failed
40206 S1000HY000Bad BCP direction. Must be either IN or OUT
40207 S1000HY000Unable to open BCP host data-file
40208 S1000HY000Unable to open BCP error-file
40209 S1000HY000Table has no text/image columns
40210 S1000HY000I/O error while writing BCP error-file
40211 S1000HY000Invalid option
40212 S1000HY000Attempt to bulk-copy a NULL value into a Server column which does not accept NULL values
40213 S1000HY000BCP host-files must contain at least one column
40214 S1000HY000I/O error while writing BCP data-file
40215 S1000HY000Host-file columns may be skipped only when copying into the Server
40216 S1000HY000Unexpected EOF encountered in BCP data-file
40217 S1000HY000Attempt to read unknown version of BCP format file
40218 S1000HY000Incorrect host-column number found in BCP format-file
40219 S1000HY000Bad terminator
40220 S1000HY000For BCP, all variable-length data must have either a length-prefix or a terminator specified
40221 S1000HY000I/O error while reading BCP format file
40222 S1000HY000Table contains less rows than first row count
40223 S1000HY000Table contains less rows than last row count
40224 S1000HY000Attempt to bulk-copy an oversized column to the SQL Server
40225 S1000HY000The BCP host-file contains less rows than first row count
40226 0800108001Neither DSN nor SERVER keyword supplied
40227 S1000HY000All bound columns are read-only
40228 S1000HY000Cannot initialize SSPI package
40229 S1000HY000Cannot generate SSPI context
40230 S1000HY000Text column data incomplete
40231 2200822008Datetime field overflow
40232 0700607006Conversions not allowed using bcp_moretext
40233 S1000HY000The row length exceeds SQL Server's maximum allowable size
40234 S1000HY000Unicode conversion failed. Code page of server not on client
40235 S1000HY000I/O error while reading/writing BCP data-file
40236 S1000HY000Not enough columns bound
40237 S1000HY000An old netlib (%s) has been detected. Please delete it and restart the application.
40238 S1000HY000Unable to resolve column level collations. Bulk-copy cannot continue.
40239 S1112HY112DBTYPE_IUNKNOWN or DBTYPE_XML bindings are only allowed for BLOB output parameters
40240 S1113HY113DBTYPE_IUNKNOWN or DBTYPE_XML bindings can only be followed by DBTYPE_IUNKNOWN or DBTYPE_XML bindings
40242 S1112HY112Conversion to sql_variant sub type not supported
40243 S1000HY000Incorrect format for native variant field
40244 S1112HY113Variant operation reqested on column that is not sql_variant
40245 S1000HY000Invalid buffer size for BCP column property
40246 S1000HY000Unknown BCP column property
40247 S1000HY000Text file mode selected. Character column types only expected.
40248 S1000HY000Field size undefined. Column type cannot be set until field size is defined.
40249 S1000HY000Server column undefined. Column type cannot be set until server column number is defined.
40250 S1000HY000Invalid field size for datatype
40251 S1000HY000Collation name [%s] could not be resolved for column [%s] by target server
40252 S1000HY000Server column order must match field order of file for BCP with QUERYOUT
40253 S1000HY000Column number invalid
40254 S1000HY000Invalid buffer
40255 S1000HY000Code page %d is not supported by SQL Server
40256 S1000HY000Unspecified error occurred on SQL Server. Connection may have been terminated by the server.
40257 S1000HY000Warning: Server data (%d bytes) exceeds host-file field length (%d bytes) for field (%d). Use prefix length, termination string, or a larger host-file field size. Truncation cannot occur for BCP output files.
40259 S1000HY000Format file could not be opened. Invalid name specified or access denied.
40261 S1000HY000Invalid table name provided for bcp operation.
40263 S1000HY000Variable length types of unlimited length should have 8 byte prefix.
40264 S1000HY000Format File : Invalid Version.
40265 S1000HY000Format File : Invalid Field count.
40266 S1000HY000Format File : Invalid Field index.
40272 S1000HY000Format File : Insufficient information provided for a field.
40273 S1000HY000Format File : Invalid Collation.
40274 S1000HY000XML Format File : XML syntax error occurred.
40275 S1000HY000XML Format File : Unexpected xml element found.
40276 S1000HY000XML Format File : Unexpected info item found.
40277 S1000HY000XML Format File : Unexpected attribute found.
40278 S1000HY000XML Format File : Incorrect attribute value found.
40279 S1000HY000XML Format File : The attributes for field are incompatible.
40280 S1000HY000XML Format File : Could not load xmlrw.dll
40281 S1000HY000XML Format File : GetProcAddress failed for CreateInfoSetReaderEx in xmlrw.dll
40282 S1000HY000XML Format File : Couldn't create an instance of InfoSet reader.
40283 S1000HY000Format File : Unknown error occurred while attempting to read.
40284 S1000HY000OServer does not support this attribute. Setting of this attribute is ignored.
40285 S1000HY000OSetting this attribute requires some others also to be set. Setting of this attribute is ignored.
40286 S1000HY000Unable to resolve column level collations. Bulk-copy cannot continue.
40287 S1000HY000Invalid format file version
40288 S1000HY000Unable to resolve column level collations
40289 S1000HY000Parameter information is missing from a user-defined type.
40350 25S1125S11Enlistment is not possible due to pending transaction
40351 25S1225S12Distributed transaction error
40352 2800028000Cannot specify old password when using trusted connection
40353 0800408004Server rejected the connection; Access to selected database has been denied
40354 0800408004Server rejected the connection; Language specified is not supported
40400 0100001000General warning
40401 0100001000Ongoing transaction has been committed
40402 0100001000The catalog stored procedures installed on server %s are version %s; version %02d.%02d.%4.4d or later is required to ensure proper operation. Please contact your system administrator and ask them to install latest Resource Database.
40403 0100001000Access to database configured in the DSN has been denied. Default used.
40404 0100001000Language configured in the DSN is not supported. Default used.
40405 0100001000Procedure executed with 'EXEC'. No output parameters returned.
40406 0100001000An error has occurred during an attempt to access the log file, logging disabled.
40407 0100001000Connected to backup server
40409 0100001000Translation options conflict with client/server character sets
40410 0100401004String data, right truncation
40412 0100001000%ld rows sent to SQL Server. Total sent: %ld
40413 0100401004String data, right truncation
40415 0100001000%ld rows successfully bulk-copied to host-file. Total received: %ld
40416 0100001000Zero length data forced to length 1
40417 0100001000Null bit data forced to zero
40418 0100001000Cursor was not closed
40419 0100001000Warning: Code page translation caused loss of data
40448 01S0001S00No database is specified for a failover partner server to mirror
40449 Invalid value specified for connection string attribute '%s'
40453 01S0201S02Packet size change not honored by server, server size used
40454 01S0201S02Packet size changed
40455 01S0201S02Cursor type changed
40456 01S0201S02Cursor concurrency changed
40457 01S0201S02Login timeout changed
40458 01S0301001Cursor operation conflict
40459 01S0501S05Cancel treated as FreeStmt/Close
40460 01S0601S06Attempt to fetch before the result returned the first rowset
40461 0100401S07Fractional truncation
40462 0700107002Unable to derive parameter information when parameter marker is a function argument
40463 01S0201S02Packet size requested by server is invalid
40464 08S0208S02Unable to open a logical session
40465 2200822007Invalid utcdatetime, date, or time serialization format
40466 S1000HY000The number of fields provided for bcp operation is less than the number of columns on the server.
40467 S1000HY000The code page specified for bcp operation is not supported on the machine.
40468 0800108001Client unable to establish connection due to prelogin failure
40470 S1000HY000Invalid table column name for bcp format file, conversion to MBCS failed.
40471 S1000HY000Data provided for user-defined type column exceeds the maximum length
40472 S1T00HYT00Query timeout expired
40473 S1000HY000The connection attempted to fail over to a server that does not have a failover partner.
40474 S1000HY000Catalog or schema name of XML schema collection can not be specified without specifying the name of XML schema collection.
40475 S1000HY000XML Format File : A required attribute is missing for the field.
40476 S1000HY000XML Format File : Duplicate Element IDs detected.
40477 S1000HY000XML Format File : Bad element reference detected.
40478 S1000HY000XML Format File : Duplicate element reference detected.
40479 0800108001Unable to complete login process due to delay in opening server connection
40480 0800108001Unable to complete login process due to delay in prelogin response
40481 0800108001Unable to complete login process due to delay in login response
40482 0800108001An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
40501 Data Source Name
40502 Data Source Name
40503 Data Source Description
40504 Driver
40505 Server
40506 Login ID
40507 Password
40508 Use Integrated Security
40509 AppName
40510 WorkStation ID
40511 Database
40512 Language
40515 Translate Character Data
40516 Log Long Running Queries
40517 Query Log File
40518 Query Log Time
40519 Log Driver Statistics
40520 Statistics File
40521 Use Regional Settings
40522 Use ANSI Quoted Identifiers
40523 Use ANSI Null, Paddings and Warnings
40524 Attach Database Filename
40525 Data Encryption
40526 Multiple Active Result Sets(MARS)
40527 Mirror Server
40529 Trust Server Certificate
40619 SQL Server requires Encryption On.
40620 Encryption not supported on SQL Server.
40621 Encryption not supported on the client.
40622 SQL Native Client does not support connections to SQL 6.5 or earlier versions.
40623 Failed to read prelogin response.
40624 Changing password during login is only supported for SQL 2005 and above.
40625 Connection to a pre-released SQL server with intermediate TDS version is not supported.
40701 HY000HY000The data source can not be used, because its DBMS version is less than 7.0.
40702 The requested properties cannot be supported.
40703 Operation Canceled
40704 Nested variants are not supported as parameters.
40705 At least one parameter contained a type that was not supported.
40706 Unable to determine parameter type for at least one variant parameter.
40707 Cannot start transaction because more than one connection is in use.
40708 Cannot create new connection because in manual or distributed transaction mode.
40709 Cannot start transaction while in firehose mode.
40710 HY000HY000The data source can not be used, because it is not a Microsoft SQL Server.
40711 The object is in a zombie state. An object may enter a zombie state when either ITransaction::Commit or ITransaction::Abort is called, or when a storage object was created and not yet released.
40712 Cannot start transaction while in fastload mode.
40713 IRowset interfaces are not supported on a fastload rowset.
40714 The precision is invalid.
40715 The scale is invalid.
40716 Deferred prepare could not be completed.
40717 4200042000Parameter Information cannot be derived from SQL statements with sub-select queries. Set parameter information before preparing command.
40718 Unable to read stream data because ACCESSORDER is sequential and the column has already been passed.
40719 Some columns could not be retrieved because ACCESSORDER is sequential and the columns have already been passed.
40720 HY000Unexpected server side behavior.
40721 Failed to load library sqlxmlx.dll. Please make sure it is properly installed and registered.
40722 Property IRowsetFastLoad cannot be set optional.
40723 0100001000Warning:Firehose rowsets cannot be preserved.
40724 4200042000Parameter Information cannot be derived from SQL statements. Set parameter information before preparing command.
40725 HY000HY000Invalid input parameter values. Check the status values for detail.
40726 At least one parameter can not be derived from the binding info. Set parameter information first.
40727 Sequential stream cannot be created for uncommitted text or image data.
40728 <Unable to display>
40729 An xml index can only be created on a single xml column.
40730 SetParameterProperties method cannot be called for the specified parameters without first calling SetParameterInfo method. The parameter information must be set before setting the parameter properties.
40731 4200042000Missing parameter properties. DBTYPE_UDT requires parameter properties to be set in addition to setting parameter info.
40732 4200042000Missing XML collection name. If XML schema or XML catalog properties are provided, XML collection name must be provided as well.
40733 Cannot start transaction because there are active results on the connection
40801 The database name specified is invalid
40802 Database name not specified in the provider string
40803 Could not find a property containing the database name
40804 A database with the provided name was created but could not be dropped when errors occurred
40810 File field number specified is out of range.
40811 BCPColumns should be called before calling BCPColFmt.
40812 The buffer size for the field attribute value is too small.
40813 Attribute for the field must have a non-null value.
40814 The column number attribute corresponding to the current field has invalid value.
40815 You can only skip fields for BCP in operation
40816 The column number for the field must be set before specifying its type.
40817 The type of the field must be SQLCHAR or SQLNCHAR for character mode operation.
40818 The specified size of the field is too large.
40819 The specified size of the field is invalid.
40820 An unknown field type was specified.
40821 Variable length field requires either a prefix or a terminator.
40822 Prefix length must be 0,1,2 or 4.
40823 Terminator must have a greater than 0 length.
40824 Conversion between the user specified field type and database column type is not possible.
40825 The buffer passed as parameter has a NULL pointer, must be non-NULL
40826 This function can not be called while using the BCP API
40827 At the time of call to BCPColumns, the number of columns must be 0. BCPColumns can be called only once during a BCP operation
40828 Bulk Copy must be initialized before calling this function.
40829 Version of file must be 60, 65, 70 or 80.
40830 Metadata request query failed
40831 BCPExec can not be called programatically
40832 Operation has already been aborted.
40833 Data file is not open for BCP operation.
40834 Input file is not present
40835 Read operation from data file failed, format of file might be invalid
40836 Write operation on data file failed
40837 Field format could not be specified
40838 Not enough information to continue execution
40839 Send/Receive Operation Failed
40840 Bulk Copy Rowsets are not Enabled
40841 Invalid direction for the BCP operation has been specified
40842 Table name is required for BCP in operation
40843 Data file must be specified for out operation
40844 File Could not be opened
40845 The format file name should be specified
40846 The version of format file is unknown
40847 The fields in the format file are not in order
40848 Data type for field in the format file is unknown
40849 The prefix length for a field is invalid
40850 The field length for a field in invalid
40851 The format of a terminator is invalid
40852 Table column number specified in format file is invalid
40853 There should be not hints for BCP out with out of order columns
40854 The field data has not been intialized
40855 Write operation on format file failed
40856 Could not convert data type token to its corresponding name
40857 BCPInit should be called before calling any other BCP API function
40858 S1000HY000I/O error while writing BCP data-file
40901 Bad file path
40902 File already open
40903 File not open
40904 End of file reached, terminator missing or field data incomplete
40905 memory mapped file read failed
40906 memory mapped file write failed
40907 invalid seek position
40908 Seek failed
40909 Bad bcp direction
40910 Bad table name
40911 need table name for bcp in
40912 need file name for out
40913 metadata query generation failed
40914 metadata query failed
40915 collations could not be resolved
40916 invalid api call for programmatic transfer
40917 at least one field should be provided
40918 This api can be called only once per bcp operation
40919 Field information need be initialized first
40920 Field no. invalid
40921 Column no. invalid
40922 Skipped fields only allowed for bcp in
40923 Term len invalid
40924 Attrib should be non-null
40925 Prefix len invalid
40926 Field len invalid
40927 Field type must be char
40928 Field size too large
40929 invalid field size
40930 Field type invalid
40931 Prefix size invalid
40932 Term size invalid
40933 Field conversion not possible
40934 data file is not open
40935 Query for data failed
40936 End reached before first row
40937 Failed to read from server
40938 Could not read till last row
40939 Bad collation name
40940 Invalid combo of prefix and length
40941 Failed to read column length
40942 Failed to read column data
40943 Failed to read BLOB column
40944 Data conversion failed
40945 Failed to send batch after max errors
40946 Failed to send batch
40947 Format file version invalid
40948 Invalid table name
40949 Invalid option specified
40950 Insert bulk failed because all the columns requested to be inserted into are either read-only or identity columns and KeepIdentity is off
40951 Insert bulk failed
40952 Insert bulk metadata send failed
40953 Batch send failed
40954 End reached before first row
40955 End reached before last row
40956 Not all rows could be copied
40957 Invalid format file
40958 Fields are out of order in format file
40959 Invalid field type
40960 Invalid field term
40961 Invalid table column
40962 No hints allowed in out of order column case
40963 Invalid format file version
40964 Invalid numeric format of data
40965 Reac char failed in format file
40966 Fields are not initialized
40967 Incorrect format for native variant field
40968 Query provided for bcp out does not give a result set
40969 One or more BLOB columns could not be sent to the server, attempt to recover from the problem failed.
40970 XML Format File : Invalid Version.
40971 XML Format File : Invalid Field count.
40972 XML Format File : Invalid Field index.
40973 XML Format File : Invalid Data type.
40974 XML Format File : Invalid Prefix length.
40975 XML Format File : Invalid Field size.
40976 XML Format File : Invalid Terminator.
40977 XML Format File : Invalid Column ordinal.
40978 XML Format File : Insufficient information provided for a field.
40979 XML Format File : Invalid Collation.
40980 XML Format File : XML syntax error occurred.
40981 XML Format File : Unexpected xml element found.
40982 XML Format File : Unexpected info item found.
40983 XML Format File : Unexpected attribute found.
40984 XML Format File : A required attribute is missing for the field.
40985 XML Format File : Incorrect attribute value found.
40986 XML Format File : Duplicate Element IDs detected.
40987 XML Format File : Bad element reference detected.
40988 XML Format File : Duplicate element reference detected.
40989 XML Format File : Could not load xmlrw.dll
40990 XML Format File : GetProcAddress failed for CreateInfoSetReaderEx in xmlrw.dll
40991 XML Format File : Couldn't create an instance of InfoSet reader.
40992 BCP Operation was aborted by the user.
40993 The number of fields provided for bcp operation is less than the number of columns on the server.
40994 The code page specified for bcp operation is not supported on the machine.
40995 Invalid table column name specified in the format file, read operation failed.
40996 Invalid table column name for bcp format file, conversion to MBCS failed.
40997 Data provided for user-defined type column exceeds the maximum length
41001 Warning: Server data exceeds host-file field length for a field. Use prefix length, termination string, or a larger host-file field size. Truncation cannot occur for BCP output files.
41002 0100001000%ld rows sent to SQL Server. Total sent: %ld
41003 0100001000%ld rows successfully bulk-copied to host-file. Total received: %ld
50000 HTTP Provider:
50001 Named Pipes Provider:
50002 Session Provider:
50003 Sign Provider:
50004 Shared Memory Provider:
50005 SMux Provider:
50006 SSL Provider:
50007 TCP Provider:
50008 VIA Provider:
50009 MAX_PROVS:
50010 SQL Network Interfaces:
50101 I/O Error detected in read/write operation
50102 Connection was terminated
50103 Asynchronous operations not supported
50105 Invalid parameter(s) found
50106 Unsupported protocol specified
50107 Invalid connection found when setting up new session protocol
50108 Protocol not supported
50109 Associating port with I/O completion mechanism failed
50111 Timeout error
50112 No server name supplied
50113 TerminateListener() has been called
50114 Win9x not supported
50115 Function not supported
50116 Shared-Memory heap error
50117 Cannot find an ip/ipv6 type address to connect
50118 Connection has been closed by peer
50119 Physical connection is not usable
50120 Connection has been closed
50121 Encryption is enforced but there is no valid certificate
50122 Couldn't load library
50123 Cannot open a new thread in server process
50124 Cannot post event to completion port
50125 Connection string is not valid
50126 Error Locating Server/Instance Specified
50127 Error getting enabled protocols list from registry
50128 Server doesn't support requested protocol
50129 Shared Memory is not supported for clustered server connectivity
50130 Invalid attempt bind to shared memory segment
50131 Encryption(ssl/tls) handshake failed
50132 Packet size too large for SSL Encrypt/Decrypt operations
50133 SSRP error
50134 Could not connect to the Shared Memory pipe
50135 An internal exception was caught
50136 The Shared Memory dll used to connect to SQL Server 2000 was not found
50137 The SQL Server 2000 Shared Memory client dll appears to be invalid/corrupted
50138 Cannot open a Shared Memory connection to SQL Server 2000
50139 Shared memory connectivity to SQL Server 2000 is either disabled or not available on this machine
50140 Could not open a connection to SQL Server
50141 Cannot open a Shared Memory connection to a remote SQL server
50142 Could not establish dedicated administrator connection (DAC) on default port. Make sure that DAC is enabled
50143 An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number