Author Topic: Build 1525 causes OLE Waring for MSSQL  (Read 4769 times)

PeterHeintz

  • EA User
  • **
  • Posts: 910
  • Karma: +55/-18
    • View Profile
Build 1525 causes OLE Waring for MSSQL
« on: January 09, 2020, 08:21:49 pm »
When using build 1525 with my MSSQL Repository I get frequently the following OLE Warning:

Microsoft OLE DB Provider for SQL Server [0x80040e14]
The data types nvarchar and ntext are incompatible in the equal to operator.
E.g. each time I click on an item of a diagram.
Best regards,

Peter Heintz

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11852
  • Karma: +460/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Build 1525 causes OLE Waring for MSSQL
« Reply #1 on: January 09, 2020, 08:43:28 pm »
Did you switch to the new DB Schema yet?

In this new schema all ntext fields have been replaced by nvarchar(max) fields.

But that doesn't mean that EA 1525 shouldn't still support the old schema. I've not seen anything like that in the release notes.

Geert

PeterHeintz

  • EA User
  • **
  • Posts: 910
  • Karma: +55/-18
    • View Profile
Re: Build 1525 causes OLE Waring for MSSQL
« Reply #2 on: January 14, 2020, 12:54:51 am »
No I did not switch! Todays 1514 build (V15.0) does not have the problem.
Best regards,

Peter Heintz

Graham_Moir

  • EA User
  • **
  • Posts: 746
  • Karma: +9/-15
    • View Profile
Re: Build 1525 causes OLE Waring for MSSQL
« Reply #3 on: January 23, 2020, 04:46:49 am »
So Peter,

- no problem with 15.0 build 1514
- there is a problem with 15.1 build 1525 (the release candidate)

the question is, is the problem still there with version 15.1 build 1526, the official release of 15.1?


Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7737
  • Karma: +103/-18
    • View Profile
Re: Build 1525 causes OLE Waring for MSSQL
« Reply #4 on: January 23, 2020, 09:42:15 am »
the question is, is the problem still there with version 15.1 build 1526, the official release of 15.1?
I didn't personally check, but it was meant to be corrected and the release notes say it was.
Eve

support@sparxsystems.com

PeterHeintz

  • EA User
  • **
  • Posts: 910
  • Karma: +55/-18
    • View Profile
Re: Build 1525 causes OLE Waring for MSSQL
« Reply #5 on: January 23, 2020, 08:46:04 pm »
It is gone in 1526, but I have some other problems with that build!
Best regards,

Peter Heintz