J
jws
I have an Access 2000 database with a table linked to Sql 2005 EE
using the Sql Native Client.
Row insertion works correctly, but updates or deletes fail with the
message-
"[Microsoft][SQL Native Client][SQL Server]The data types text and
varchar are incompatible in the equal to operator."
I find it odd that these types could not be compared. Secondarily, If
my table has an integer primary key/Identity column why does the
delete statement reference any other column? Tracing the ODBC
connection shows that the statement being prepared is as follows-
"DELETE FROM "dbo"."Customer_Addresses" WHERE "RowID" = ? AND
"Company" = ? AND "ShortName" = ? AND "Street1" = ? AND "Street2" = ?
AND "City" = ? AND "State" = ? AND "Zip" = ?\ 0"
What madness is this?
using the Sql Native Client.
Row insertion works correctly, but updates or deletes fail with the
message-
"[Microsoft][SQL Native Client][SQL Server]The data types text and
varchar are incompatible in the equal to operator."
I find it odd that these types could not be compared. Secondarily, If
my table has an integer primary key/Identity column why does the
delete statement reference any other column? Tracing the ODBC
connection shows that the statement being prepared is as follows-
"DELETE FROM "dbo"."Customer_Addresses" WHERE "RowID" = ? AND
"Company" = ? AND "ShortName" = ? AND "Street1" = ? AND "Street2" = ?
AND "City" = ? AND "State" = ? AND "Zip" = ?\ 0"
What madness is this?