Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: PeterHeintz on October 10, 2018, 07:12:11 pm

Title: MSSQL Connection Warning [-2147217900]
Post by: PeterHeintz 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?
Title: Re: MSSQL Connection Warning [-2147217900]
Post by: qwerty on October 10, 2018, 09:53:01 pm
Look into dberror.txt and eventually contact Sparx support.

q.
Title: Re: MSSQL Connection Warning [-2147217900]
Post by: Eve 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.
Title: Re: MSSQL Connection Warning [-2147217900]
Post by: PeterHeintz on October 11, 2018, 09:53:48 pm
Thank you Simon!
Great guess!
Yes, the root cause was an add-in.