search

zillow / ctds

Python DB-API 2.0 library for MS SQL Server
MIT License
83 stars 12 forks source link

Bulk Insert - Date issue #99

Open samitshah78 opened 1 year ago

samitshah78 commented 1 year ago

Hi,

I am trying to do bulk insert into Azure SQL Server and having date field in the dataset. Both source and target have date datatype, but it fails with error "_tds.ProgrammingError: Conversion failed when converting date and/or time from character string." When I change datatype on target to datetime, it works fine. I am using CTDS - 1.10. In my connection string, I am passing tds_version as 7.1 else it does not even try to connect with higher version of tds_version.

Please advise

joshuahlang commented 1 year ago

What version of FreeTDS are you using?