sny23vpb
asked on
SQL 2008 (10) Not Supported vb.net Commands
I have a vb.net app designed to automaticlly deploy table/stored procedure scripts to a designated SQL Server 2000 database that worked great with SQL 2000 but now gives the following error message when trying to run on SQL Server 2008:
This SQL Server version (10 0) is not supported
The code is:
Imports Microsoft.SqlServer.Manage ment.Smo
Dim server As New Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection(c onnection)
Me.CurrentTask.Text = reader(0).ToString
strFileContents = My.Computer.FileSystem.Rea dAllText(r eader(0).T oString)
server.ExecuteNonQuery(str FileConten ts)
It gives the error on the line above at: server.ExecuteNonQuery(str FileConten ts)
I've tried to do searches; but haven't found any solution that seems to work - please let me know if I've overlooked the solution here.
Thanks for any help.
This SQL Server version (10 0) is not supported
The code is:
Imports Microsoft.SqlServer.Manage
Dim server As New Microsoft.SqlServer.Manage
Me.CurrentTask.Text = reader(0).ToString
strFileContents = My.Computer.FileSystem.Rea
server.ExecuteNonQuery(str
It gives the error on the line above at: server.ExecuteNonQuery(str
I've tried to do searches; but haven't found any solution that seems to work - please let me know if I've overlooked the solution here.
Thanks for any help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER