I am using C# to connect to Oracle. The Admin gave me the Database name, Host, Service Name, and IP address, yet I cannot get connected.

Here's what I have:

string sProvider = "msdaora";
string sServer = "CIS-SERVER";
string sDatabase = "ORA92SID";
string sUserName = "kevin";
string sPassword = "abcdefg";


string sConnStr = 
    "Provider= " + sProvider +
    ";Data Source=" + sDatabase +
    ";User Id=" + sUserName +
    ";Password=" + sPassword + ";";


OleDbConnection oConn = new OleDbConnection();
oConn.ConnectionString = sConnStr;

try
{
	oConn.Open();
}
catch (OleDbException e)
{
	Console.WriteLine(e.Message);
	bConnected = false;
}

I'm getting "ORA-12154: TNS:could not resolve service name"

Anyone know what's wrong here?