Am facut cu SMO, si am stat 3 zile investigand eroarea "Could not connect to server"
. Pentru a elimina problema asta, trebuie folosita clasa ServerConnection.
Asa da:
1 2 | ServerConnection sqlConnection = new ServerConnection(connection_string); Server sqlServer = new Server( sqlConnection); |
Asa nu:
1 | Server sqlServer = new Server(connection_string); |
, desi, in subtirica documentatie a SMO din MSDN, se zice ca nu e obligatoriu folosirea clasei ServerConnection. N-o fi obligatoriu, insa e foarte necesar :)