slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

External Development Forums - SalesLogix OLEDB Provider
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: SLXOLEDB.1 Provider does not work in a web app

Shawn Lawsure
Posts: 18

SLXOLEDB.1 Provider does not work in a web app Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Sep 10 3:29 PM

I get the "Unable to initialize data dictionary" error in my web app when trying to connect to a SalesLogix database (on another machine) with a connection string that uses the SLXOLEDB.1 Provider. Using the exact same connection string and same code I don't get the error from a plain Windows Forms (test) app. This is on Windows Server 2003.

On my Windows 7 machine I am able to successfully run the same web app (the database I'm connecting to is on the same machine).

Anyone have any ideas?

[Reply][Quote]

James Jury
Posts: 23

Re: SLXOLEDB.1 Provider does not work in a web app Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 4:08 AM

Shawn,

It's a long shot, but is the Web App using a different user to that you are executing the Windows Form Test app with? If so, machine sure that the Web App user has rights, and test with the Windows Form Test App.

Also try Ending the Process in Task Manager for SLXSystem.exe.

James

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: SLXOLEDB.1 Provider does not work in a web app Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 12:04 PM

Quote:

Originally posted by Shawn Lawsure

I get the "Unable to initialize data dictionary" error in my web app when trying to connect to a SalesLogix database

Here is some insight on how I have noticed SLX System works:
- It opens a connection to the SLX Server
And
- It opens a connection to the SQL server

When it cannot communicate with the SQL server, then it gives this error: Unable to Initialize Data Dictionary.

So, I would suggest you start with the basics:
- Make sure that you have the correct SQL client installed (has to match the one that you have on the Server where you defined the SLX Connection within Connection Manager).
- Name resolution. Many times I have seen that a given machine is able to resolve the SLX server's name but not the SQL Server
- Blocked Ports. Although SLX uses Port 1706, SQL Server uses a different port (1433 by default, but may be adjusted). If you have adjusted the port, you may need to define an alias if the new machine is not able to connect to it.

Along the same lines, what SQL Protocol are you using? If you are using any protocol other than TCPIP, there may be other ports that need to be open, as well as other Security requirements to connect to it.

Best of lucks...

[Reply][Quote]

Shawn Lawsure
Posts: 18

Re: SLXOLEDB.1 Provider does not work in a web app Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 12:56 PM

Thanks for the response James.

Security was one of the first things I checked. The web app is running under the Network Service account and I made sure the machine has the appropriate rights to the SalesLogix database. Now that I think about it though I wonder if the machine I'm running from needs to have permissions to the SalesLogix server that it's going through. For example, when I run the Windows app it is probably running under my account which has access to all the machines. I'll look into that.

Also, there is no SLXSystem.exe process running on the machine (and there shouldn't be as the SalesLogix server is on another machine).

[Reply][Quote]

Shawn Lawsure
Posts: 18

Re: SLXOLEDB.1 Provider does not work in a web app Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 12:59 PM

Thanks for the response Raul.

I don't think any of those ideas are applicable given the fact that my test Windows app runs fine and I can run the SalesLogix client from that machine using the same server/database connection.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: SLXOLEDB.1 Provider does not work in a web app Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 10 2:16 PM

The basic point of my reply stands though:
- Failure to initialize data dictionary typically means that it cannot talk to SQL, even though it does talk to SLX Server.

Given that it works for applications ran under your profile, but not for a Web App I would still look into permissions (maybe run the Web App under your credentials....)

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/18/2024 9:12:20 PM