SQL Server 2005/ VS 2003 Issues

johnalp · July 10th, 2006, 12:54 PM

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.

jondavidson · August 3rd, 2006, 02:44 AM

I'm still using VS 2003 and SQL Server 2000 but have recently been thinking about upgrading to SQL Server 2005. Have you had any luck with your problem and have you had any other problems using VS 2003 and SQL Server 2005 together?

Kind Regards,
Jon

Quote:

quote:Originally posted by johnalp
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.