FreeTDS: cannot execute with params about turbodbc

[MathMagique]

The default parameter type mentioned in the commit message is automatically replaced by more appropriate types once non-Null values are passed.

[dirkjonker]

Awesome, just tested the master branch and it works great!

[MathMagique]

Hi Dirk! Thanks for the report. I have not yet played with FreeTDS, but I know that Microsoft's official ODBC driver has no problems with parameters. Unfortunately, it seems to be available for Linux and Windows only.

If FreeTDS does not support parameters, performance of inserts will be pretty slow. But I'll have to check in more detail.

[dirkjonker]

Hi Michael, thanks for the quick reply! Parameterization works fine if I use pyodbc + FreeTDS, so turbodbc must be calling some kind of ODBC function that FreeTDS does not support. I'll see if I can find something.

[MathMagique]

That would be great. As far as I know, pyodbc does not transfer parameters in batches, so any calls required to enable batches might be harmful.

Btw: @keitherskine does not seem to have the issue you report with MSSQL, but he uses Microsoft's driver to connect (see his comments in the otherwise unrelated #39).

[dirkjonker]

@MathMagique the problem seems to be that FreeTDS has not implemented SQLDescribeParam: https://github.com/FreeTDS/freetds/blob/Branch-1_00/doc/api_status.txt

I updated the title and initial post with some more information.

[MathMagique]

Then there may be some hope left ;-). I use SQLDescribeParam for the initial guess of what a parameter is supposed to be. Many databases don't know that anyway and I have a mechanism in place that can handle differing parameter types.

It should be easy to implement a fallback to something like an integer type when SQLDescribeParam is not available. The remaining code should already be able to handle Python parameters that deviate from this integer type, then.

[MathMagique]

Thanks for helping identifying the issue!