Troubleshooting
Problem
Which Microsoft SQL Server data types are supported in iBridge?
Symptom
BigInt data types are not supported in IBM i2 iBridge.
Resolving The Problem
Microsoft SQL Server data type mappings
The table below shows the list of supported Microsoft SQL Server field data types and how they are mapped via ActiveX Data Object (ADO) types through iBridge to Analyst’s Notebook.
Note: Microsoft SQL Server field data types not listed in the table are unsupported in iBridge
| Microsoft SQL Server Data Type * | ADO Data Type # | iBridge Data Type | Analyst’s Notebook Data Type |
| bit | adBoolean (11) | Boolean | Flag |
| datetime (8) | adDBTimeStamp (135) | Date | Time |
| smalldatetime (4) | adDBTimeStamp (135) | Date | Time |
| tinyint | adUnsignedTinyInt (17) | Byte | Number |
| smallint | adSmallInt (2) | Integer | Number |
| int | adInteger (3) | Long | Number |
| real | adSingle (4) | Single | Number |
| float | adDouble (5) | Double | Number |
| numeric (9) | adNumeric (131) | Double | Number |
| decimal (9) | adNumeric (131) | Double | Number |
| money (8) | adCurrency (6) | Currency | Number |
| smallmoney (4) | adCurrency (6) | Currency | Number |
| char | adChar (129) | String | Text |
| varchar | adVarChar (200) | String | Text |
| nchar | adWChar (130 | String | Text |
| nvarchar | adVarWChar (202) | String | Text |
| binary (1-8000) | adBinary (128) | Binary | Binary |
| varbinary (1-8000) | adVarBinary (204) | Binary | Binary |
| image (>8000) | adLongVarBinary (205) | Binary | Binary |
| timestamp (8) | adBinary (128) | Binary | Binary |
| uniqueidentifier(16) | adGUID (72) | GUID | Binary |
| bigint | adBigInt (20) | Unknown | Unknown |
| sql_variant | adVariant (12) | Unknown | Unknown |
| ^text | adLongVarChar(201) | Memo | Text |
| ^nText | asLongVarWChar(203) | Memo | Text |
Notes:
- * - Numbers in parentheses denote the field size in bytes.
- # - Numbers in parentheses denote the numeric value of the ADO data type enumerations.
- ^ - These are SQL Server 2000 and 2005 data types, and are no longer available in SQL Server 2008.
[{"Product":{"code":"SSXUXD","label":"i2 Analyst's Notebook"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"iBridge","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.9.1","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
More support for:
i2 Analyst's Notebook
Software version:
8.9.1
Operating system(s):
Windows
Document number:
510313
Modified date:
16 June 2018
UID
swg21673431