I'm working on creating a database using SQL server, and my code is written in VS.NET. I get the following error:

---------------------------
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.
---------------------------

Here is the function where the 1st error takes place:

------------------------
public static int ExecuteNonQuery (string procName, params object[] args) {

      SqlCommand cmnd = null;
        try
        {
            // Run the stored procedure to update the database
            cmnd = DbUtil.BuildCommand(procName, args);
            cmnd.Connection.Open();
            int iRowsAffected = cmnd.ExecuteNonQuery();

            // return the number of rows affected
            return iRowsAffected;
        }

        finally
        {
            // Close resources
            if (cmnd != null)
                if (cmnd.Connection.State != ConnectionState.Closed)
                    cmnd.Connection.Close();
        }

    }
----------------------

I think the problem has something to do with my connection string. I'm not sure if I wrote the connection string correctly. Here it is:
_DSN = "Data Source=132.47.120.194;User ID=sa;Password=par>05sql;Database=Jodiv;";

If anyone has any suggestions please reply back!!!

If the connection is wrong you should get a pretty obvious error message:
"SQL Server cannot be found."
"Login bad..."

Unfortunately, "System error" is vague and doesn't help much.

-Peter

Can you catch the expection text and past it here?

It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

Thanks for the response! It has been resolved.

Could you tell us what you did to resolve it?

-Peter

Um...I can't really remember exactly. I think the problem was something stupid like I was running my script file through the wrong database. :)