viernes, 21 de octubre de 2011 16:07
Does SMO expect .Netframework 4.0 to talk to SQL server Denali or 3.5 is enough?
I'm trying to migrate my C#, .Net application to support SQL Server Denali. The application currently supports SQL Sever 2008 and uses .Net Framework 3.5. I'm just wondering if just replacing SMO assemblies (as per http://msdn.microsoft.com/en-us/library/dd206977%28v=sql.110%29.aspx) are enough or do I need to migrate to .Net framework 4.0 too. SQL server Denali expects 4.0 to work but SMO library does not talk about the framework to be used. When I try to remotely connect to the Denali server using framework 3.5 I get the following error.
"System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
Thanks for the help,
Todas las respuestas
sábado, 22 de octubre de 2011 7:00Can someone reply this please?
miércoles, 16 de mayo de 2012 21:27Moderador
You can take a look at blog entry http://blogs.msdn.com/b/sqlagent/archive/2012/05/11/create-sql-agent-job-using-c-and-smo.aspx
and a Visual studio sample http://code.msdn.microsoft.com/Create-SQL-Agent-job-using-b95584e7
Sethu Srinivasan [MSFT]
- Marcado como respuesta Sethu SrinivasanMicrosoft Employee, Moderator jueves, 01 de noviembre de 2012 23:20