Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL 4 CDS is installed BUT not working in SSMS #263

Open
SaidElnaffar opened this issue Dec 2, 2022 · 3 comments
Open

SQL 4 CDS is installed BUT not working in SSMS #263

SaidElnaffar opened this issue Dec 2, 2022 · 3 comments

Comments

@SaidElnaffar
Copy link

SaidElnaffar commented Dec 2, 2022

I initially installed SSMS v.19.0 (Preview) then installed the MSI from this Github. I went to Tools/Options and found no section for "SQL 4 CDS". In other words, the plugin did not install.

I uninstalled all of the above and re-started over. I installed SSMS v.18.12.1 (the latest) and then the MSI. The "SQL 4 CDS" appeared under Tools/Options as expected, however, when I execute any of the DML statements, it fails.

For example, when I tried to execute the following:
"
update account
set fax = 'Faxes'
where fax = 'Fax01';
"

I got the following error:

"
Msg 40000, Level 16, State 1, Line 1
'UPDATE' statement​ is not supported. Line:5, Position:1
RequestId: TDS;c735b16c-a148-499c-9562-8d939bf869fc;6
Time: 2022-12-02T04:41:08.0025342Z

Completion time: 2022-12-02T08:41:09.4223239+04:00

"

NOTE: I should mention that all DML commands work perfectly using XrmToolBox and that TDS points are enabled. The SQL 4 CDS fails/doesn't work only in SSMS.

Advise, please.

@MarkMpn
Copy link
Owner

MarkMpn commented Dec 2, 2022

Could you generate a log file from SSMS (see #141 for instructions) and post it here please?

@SaidElnaffar
Copy link
Author

ssms.xml.txt

I am attaching the XML generated from the SSMS's logging system.

I noticed something else. The FetchXML button which I commonly see in your screenshots is NOT there in the SSMS toolbars.

Summary: the only trace of SQL 4 CDS that I can see is under Tools/Options. Nothing else appears or works.

@MarkMpn
Copy link
Owner

MarkMpn commented Dec 4, 2022

This looks like the same error as #232 - could you please take a look at the details at the end of that thread for some further debugging information?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants