Author Topic: MSSQL Connection Warning [-2147217900]  (Read 718 times)

PeterHeintz

  • EA User
  • **
  • Posts: 817
  • Karma: +49/-17
    • View Profile
MSSQL Connection Warning [-2147217900]
« on: October 10, 2018, 07:12:11 pm »
Hi,
a college of mine gets the following waring when connecting to MSSQL DBs:

Microsoft OLE DB Provider for SQL Server [-2147217900]
Incorrect syntax near the keyword ‘RowCount’

He gets this warning for both SQL repositories he connects too, but other users do not see this warning.
Further on, the warning seem not to have impacts on the work within EA.

Any ideas?
Best regards,

Peter Heintz

qwerty

  • EA Guru
  • *****
  • Posts: 10624
  • Karma: +233/-194
  • I'm no guru at all
    • View Profile
Re: MSSQL Connection Warning [-2147217900]
« Reply #1 on: October 10, 2018, 09:53:01 pm »
Look into dberror.txt and eventually contact Sparx support.

q.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 6841
  • Karma: +66/-7
    • View Profile
Re: MSSQL Connection Warning [-2147217900]
« Reply #2 on: October 11, 2018, 08:43:06 am »
I'm guessing that he has defined a model view, or an add-in is running sql etc.
Eve

support@sparxsystems.com

PeterHeintz

  • EA User
  • **
  • Posts: 817
  • Karma: +49/-17
    • View Profile
Re: MSSQL Connection Warning [-2147217900]
« Reply #3 on: October 11, 2018, 09:53:48 pm »
Thank you Simon!
Great guess!
Yes, the root cause was an add-in.
Best regards,

Peter Heintz