hb2638
hb2638
There are a few ways of solving that Allow the caller to pass in a flag on whether or not to check the diagnostics based on Microsoft’s documentation or Expose...
> And perhaps FreeTDS ODBC implemented the ODBC spec incorrectly... See the **Comments** section of [SQLExecDirect Function](https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlexecdirect-function?view=sql-server-ver16) ``` If SQLExecDirect executes a searched update, insert, or delete statement that does...
> > perhaps FreeTDS ODBC implemented the ODBC spec incorrectly > > Could be, but FWIW the SAP ASE ODBC driver (libsybdrvodb-sqllen8.so on Linux) also returns SQL_SUCCESS_WITH_INFO, like FreeTDS: >...
> > If SQLExecDirect executes a searched update, insert, or delete statement that does not affect any rows at the data source, the call to SQLExecDirect returns SQL_NO_DATA > >...
I'll just quote MSDN from [Trigger Limitations](https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver16#trigger-limitations) on why you would use SET NOCOUNT inside a trigger. > When a trigger fires, results are returned to the calling application, just...
> Hi @keitherskine . I'm still concerned about @v-chojas 's comment, particularly > > > Note that other drivers may even crash if you try to retrieve nonexistent diag recs...
> How about only getting the diag recs when the .messages is retrieved? That should satisfy you while not unnecessarily causing breakage for others whose drivers will crash or end...
I think I can get away with recreating.
I ran this again with the SQL Trace and I see the ODBC driver is sending back the PRINT message on line 438 but for some reason, pyodbc is not...
Is there a reason why the below function can't be added to the WaiterError class? ``` def __reduce__(self): return _exception_from_packed_args, ( self.__class__, (self.kwargs["name"], self.kwargs["reason"], self.last_response), {}, ) ``` becaue my...