I have a good installation with ZH Openstreetmap on a public webserver. I'm now trying to install it on IIS with SQL server in my company.
Joomla installation OK;
Installation of ZH Openstreetmap OK;
In global admin I can make changes to the configuration of ZH Openstreetmap. But in Components>ZH openstreetmap I get errors for most menu topic's. About, Utilities, works. But all other menu items like Maps, Placemarks gives a SQL error message. See screenshots below.
It seams the sql script is not compatible with SQL-server. It is designed for MySQL. On the SQL server I get a lot of errors. (back quote not accepted, auto_increment not accepted, engine= not accepted). I tried to solve the errors, but that's a lot of work.
Yes, joomla has different installation forders for databases (sql, postgreesql, sqlazure). With different syntax.
I have only sql, that means MySQL. I haven't any installation of SQL-server, therefore I can't check how it works (or not). Sorry, I will think of it for furure
Yes, I'm running in more issues. I created all necessary tables manually and got some ZH OSM working. But run in problems when I add a custom map style. See screenshots below. Same kind of error when uploading a csv file.