Skip to main content

SQL Server Conversion failed

  • May 31, 2021
  • 2 replies
  • 0 views

With uniface 10 and the Uniface 10.3 IDE Utilities, i have errors when i try to create table script.

22018 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'T' to data type bit.

Why are thoses errors only when i try to create table script.

P.s Entities was imported from 9.7

2 replies

Ingo Stiller
Forum|alt.badge.img+3
  • Participating Frequently
  • June 1, 2021

With uniface 10 and the Uniface 10.3 IDE Utilities, i have errors when i try to create table script.

22018 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'T' to data type bit.

Why are thoses errors only when i try to create table script.

P.s Entities was imported from 9.7

Hi Jonathan

Check which mapping is defined in USYS$MSS_PARAMS

Ingo

Uniface to MS SQL Storage Formats
Uniface Packing Code

MS SQL Storage Format
(mapping 2)

MS SQL Storage Format
(mapping 1)

B1-B3CharBit
B4BitBit

With uniface 10 and the Uniface 10.3 IDE Utilities, i have errors when i try to create table script.

22018 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'T' to data type bit.

Why are thoses errors only when i try to create table script.

P.s Entities was imported from 9.7

[DRIVER_SETTINGS]
MSS    U5.3
Usys$MSS_Params        procs:off