One of our applications the FoxPro-based has a problem inserting data when tested with SQL Server 2005. The production version works with SQL Server 2000 without problems. The error message from ODBC SQL Server Driver is:
"INITCOLVS is not a recognized built-in function name"
This problem is the same as in one of the posts on another forum here:
I did do a search, on the web it looks like related to the replication (?) but no solutions were provided. There are very few posts on the subject and BOL does not contain any reference on this function.
The production database does participate in the merge replication, but the database in 2005 is not replicating, it is just an individual copy of the database moved to the test 2005 environment. Also, the insert problem happens only on one table. Other tables in 2005 do allow insert through the application.
Please, let me know if anybody else has experience with this error message.