October 29, 2003 at 9:24 am
Any help on this problem will be greatly appreciated.
I transferred a database from one server to another server that is not in the same Windows domain. I used the backup and restore database utility in the enterprise manager. The database on the original is a replication/publication database. The new database is not published.
I can view the data, however I cannot make any modifications.
When I try to delete a record the following error message appears:
[Microsoft][odbc sql server driver][sql server]The update lineagefunction requires 2 arguments.
[Microsoft][odbc sql server driver][sql server]Incorrect syntax near the keyword 'as'.
When I try to add a record the following error message appears:
[Microsoft][odbc sql server driver][sql server]The update lineagefunction requires 2 arguments.
[Microsoft][odbc sql server driver][sql server]GETMAXVERSION is not a recognized function name.
October 29, 2003 at 9:44 am
Which version both SQL Server run? Do they have same MDAC version?
October 29, 2003 at 10:01 am
Both are SQL 2000 on 2000 servers. I don't know what a MDAC is.
October 29, 2003 at 10:10 am
It is Microsoft Data Access Component. Go to http://www.microsoft.com/data to have a look and you can download MDAC checker to verify the version of MDAC in both machine.
October 29, 2003 at 10:41 am
The origin server uses MDAC 2.6 SP2 and the destination server uses MDAC 2.6 RTM
October 29, 2003 at 11:30 am
Can you apply the sp2 to the destination server ?
October 29, 2003 at 11:45 am
I'll give it a try. Thanks.
October 29, 2003 at 2:16 pm
Thank you Allen, your suggestion did the trick! I ended up blowing out SQL 2000, reinstalling it, loading sp 3a and restoring the database. It seems to work fine.
Your help was really appreciated.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply