Problems using Microsoft OLEDB Provider for Oracle

All:

        I managed to get this C# program working under Windows 98SE; but now that I have installed Windows 2000 Pro onto my PC, this C# program doesn't work. It gives me a "System.Data.OleDB.OleDBException" error even though the same driver works fine in an ASP script.

        The error message states: "Oracle error occurred but error message couldn't be retrieved from Oracle".

        Here is the code (with my password blanked out):

using System;
using System.Data;
using System.Data.OleDb;

class MainClass
{

	public static void Main(string[] args)
	{

		OleDbConnection cnOra = new OleDbConnection(
				"Provider=MSDAORA;Data Source=Bookbiz;"
                  				 + "user id=cmarvel;password=xxxxxxxxxxxxx;"
                   			+ "persist security info=true;");



		// open the connection to the database.

		cnOra.Open();
		
	


		// close the connection.

		cnOra.Close();
	}

        Any ideas out there what is going on? Is there anyway to get a .udl file to work with a C# program like an ASP script? That works fine in my ASP script.

Keith Lee Received on Thu Oct 17 2002 - 11:46:03 CDT