I have some C# code that I have used in an ASP.NET app to open an OleDbConnection to SalesLogix, and it connects just fine.  When I copied this code to a console application I am building, it doesn't work.  I get the error:

The 'SLXOLEDB.1' provider is not registered on the local machine.

The provider obviously is installed, because when I run the ASP.NET code in DevStudio with the same connection string, it connects with no problem at all.  I have included the code below.

...

        private string _connectionString;

        private OleDbConnection _conn;

        public SLX_DB()

        {

            _connectionString = ConfigurationManager.ConnectionStrings["SlxConnection"].ToString();

            _conn = new OleDbConnection(_connectionString);

            _conn.Open();

        }

I think I might have figured it out... when it writes to the error log, I noticed that the user is "N/A" - the console app is not running as a user, even though I am the one launching it, and since it isn't a user it can't see the driver.  At least, that's my guess.

Anyone know how I can either (a) get a console app to run with specific credentials, or (b) make the oledb provider available even when there isn't a user?

Patrick:

Have you checked your Target CPU for the Console App?

If your target is x64 it won't find the provider, make sure that you set the Target for x86.

Yup that was it, thanks Raul.

It was set to "AnyCPU", but since I'm on a 64-bit it wasn't finding it.  Changed to x86 and works fine!