I used to excute the below SQL Statement with SQL 2000 and when i removed the 2000 and Installed the SQL 2008 not all the data appeared in the report, Is there anything else should I do?
The SQL Statement is :
If conn.State = ConnectionState.Closed Then
conn.ConnectionString = "Provider=SQLOLEDB;server=" & Srvrname & ";database=Att;user id=sa;pwd="
Catch ex As OleDb.OleDbException
MsgBox("Server is not Responding", MsgBoxStyle.Critical, "ATS")
View Complete Post