I have an application developed using VS 2003 and talking to a SQL Server 2000. We upgraded to SQL Server 2005. I tried configuring my dataadapter using the wizard with the options "Use SQl Statements" or "Create New Stored Procedures". The select statement and table mappings are generated. There are errors on the insert, update and delete statements. I have googled extensively but no one seems to be having this problem.
Is there an issue with VS 2003 and SQL 2005. Is it an issue with ADO that comes with VS 2003. My guess is that the automated queries that the dataadapter wizard generates doesnt work with SQL 2005.
If this is the case, then is there a fix. Has anyone had a similar experience.
Thanks.