I have a website runing on IIS 7.5 / .NET 4. I am trying to connect to SalesLogix through an OLEDB connection.

OleDbConnection slxConnection = new OleDbConnection("Provider=SLXOLEDB.1;User ID=website; Password=XXXXXX;Initial Catalog=SALESLOGIX;Data Source=ssdata; Persist Security Info=True;");

slxConnection.Open();

This throws an uncatchable error and puts this in the event log:

Faulting application name: w3wp.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd2b

Faulting module name: SLXDBEngine.DLL, version: 7.2.0.1501, time stamp: 0x46930ac2

Exception code: 0xc0000005

Fault offset: 0x000b087d

Faulting process id: 0x1f34

Faulting application start time: 0x01cdff3ae8131bbf

Faulting application path: C:\Windows\SysWOW64\inetsrv\w3wp.exe

Faulting module path: C:\Program Files (x86)\SalesLogix\SLXDBEngine.DLL

Report Id: 3f262c1b-6b2e-11e2-b494-005056c00008

Now, from what I understand from my reading, this is due to the fact that SalesLogix needs write permission to a "user" directory i.e. (C:\Users\username). IIS is running as "Network User" and doesn't have a user directory. Network user is a limited user for security reasons.

I am at my wits end trying to get this to work. I even tried installing SLXSystem.exe as a service and running the service as an elevated user, me. 

And yes, I was able to get this running without any problem running a console application, unfortunately I really need the website to be able to play nice with SalesLogix.

Any help would be greatly appreciated!!!

Hi Christian,

as long as the information in your connection string are right, there is no issue in the two lines of code. I suppose, the user "website" is a SalesLogix user, isn't he?

So, it has to be a configuration issue. To clearify the environment, it would be helpful, if you describe the environment more detailed.

Do you have set up the SalesLogix Web Host on that IIS server and is the SalesLogix web host running fine? Or do you use a standalone IIS without SalesLogix installed?
Have you tried to switch your application to .Net 3.5 as target framework? I am not sure, if SLX 7.2 (and it's depedencies) supports) .Net 4.
Is your IIS running in 32bit mode?

Cheers,

Thomas

Make sure the application pool for your website is 32-bit. The SLX OLEDB Provider won't work in a 64-bit environment. Open the App Pool's Advanced Settings and look for the setting called "Enable 32-bit applications" and set it to True.