Grid Row preview not working
Release 1.4 - ...
When you encounter the following problem when editing Grid Rows:
{Error: Incorrect syntax near the keyword 'WITH'.}
... update your CMS connectionstring to use SQLNCLI10.1 instead of SQLOLEDB.1:
Copy Code | |
---|---|
Provider=SQLOLEDB.1;Data Source=HAWKING;Persist Security Info=True;Password=********;User ID=iXperionAdmin;Initial Catalog=EmptySix |
Simply change the provider part:
Copy Code | |
---|---|
Provider=SQLNCLI10.1;Data Source=HAWKING;Persist Security Info=True;Password=********;User ID=iXperionAdmin;Initial Catalog=EmptySix |