Hi all
I want to use the SqlDatasource to connect a SQL Server 2008, but it says it only support the sql server 2005. Is there any method to solve it? I use the Visual Studio 2008.
Best Regards,
What do you mean "will"? You mean it can not for mow?
Yongwei Xing
2010-01-07 02:17:17
Have you _tried_ it? SqlDatasource works just fine with sql server 2008 right now, and it only takes a moment to test this and see for yourself.
Joel Coehoorn
2010-01-07 02:19:48
I have tried yet, it seems do not work for me
Yongwei Xing
2010-01-07 02:26:16
Then you configured something wrong. It _does_ work for sql server 2008.
Joel Coehoorn
2010-01-07 02:37:27
Ok, I will try to install the VS 2008 SP1 first to see what would be like after installation.
Yongwei Xing
2010-01-07 03:27:34
+1
A:
For design time connectivity (ie. Server Explorer) from Visual Studio 2005 you need to install this patch: Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support.
For design time connectivity from Visual Studio 2008 you need to install VS 2008 SP1, if I remember correctly.
Remus Rusanu
2010-01-07 02:21:52