You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have tried importing data into my SSMS through python and for a start I successfully connect to the database and a table is being created but I keep getting the below error.
I initially thought its a problem with the data type but when I used a different excel file which I had uploaded manually on SSMS it still gave thesame error.
An error occurred: (42000',
'[42000] [Microsoft][ODBC Driver 17 for SQL Server] [SQL Server] The incoming tabular data stream
(TDS) remote procedure call (RPC)
protocol stream is incorrect.
Parameter 16 ("'"): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. (8023)
(SQLExecDirectW)')
09:42
The text was updated successfully, but these errors were encountered:
It seems actually an issue with datatype that is being uploaded to table. We can always get from datatype of lower precision to higher precision but the other way round it won't be valid.
You may provide what actual data you are passing to the table for us to be able to debug better.
I have tried importing data into my SSMS through python and for a start I successfully connect to the database and a table is being created but I keep getting the below error.
I initially thought its a problem with the data type but when I used a different excel file which I had uploaded manually on SSMS it still gave thesame error.
An error occurred: (42000',
'[42000] [Microsoft][ODBC Driver 17 for SQL Server] [SQL Server] The incoming tabular data stream
(TDS) remote procedure call (RPC)
protocol stream is incorrect.
Parameter 16 ("'"): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. (8023)
(SQLExecDirectW)')
09:42
The text was updated successfully, but these errors were encountered: