I have some customers with Sage 300 2022 and they have and use to setup ODBs for companies/sytem SQL Server Native Client 11.0.
But with a customer we are upgrading to that same Sage 300 2022 version, and we dont found it. We download ODBC Microsoft match but when installing it tells ODBC Driver 11 for SQL Server. We use it to create those ODBCs and not a problem. We run Sage and no issues. Is it the same? What ODBC we must use?
I found Sage install automatically when running Workstation setup (all programs at server) and entry with name of our server but it is ODBC Driver 18 for SQL Server...but we never use to create ODBC for our companies. We use SQL Server Native Client 11.0. Is it a good practice? Or whats your recommendation?
That ODBC Driver 18 for SQL Server that Sage install by itself we only setup without any database. If we don't do it, fails to connect databases when login to Sage 300 companies. Could anyone clarify?
Thank you very much