So I'm switching a SQL script from RODBC to odbc that uses the NEWID() function. In RODBC the script runs without error but when I run it with odbc, I get this error:
nanodbc/nanodbc.cpp:1587: 42000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'NEWID' is not a recognized built-in function name.
This error is happening for my team and isn't isolated to one computer. Is this a known issue?
This type of errors means it comes from the database driver where it says that the NEWID() function is not one recognized by the driver as an available function.
Are you using the same driver ? only the connection change between RODBC and odbc ?
I can't test anything on SQL server, so I am just trying to help dig into this.