This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Receiving this error when running an iterative macro: Error opening "SELECT SERVERPROPERTY('EngineEdition')": No Columns Returned. This doesn't always happen, but usually happens once we have completed a couple hundred iterations. We are attempting to write to SQL Server using an ODBC Connection. Help is greatly appreciated on this! Thanks.
How fast are the iterations? I am assuming inside the macro is a set of input tool(s) containing a SQL Server DB ODBC connection? Is anything being modified on that connection through the iterations, such as table name or the select statement?