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: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services

Bailey1
Posts: 57

Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Oct 09 2:10 PM

We have a bunch of Reporting Services rpts that used to run against SLX 6.1 using MS SQL Server. Now that we have upgraded to SLX 7.5 we need to use the SLX provider so that dates will display correctly due to the GMT changes in SLX 7.5. I have had no luck connecting to SLX OLE Db Provider - I get error message(SLXOLEDB.1 failed no error message available). Has anyone done this and could give me some ideas on what to try or what the connection string should look like?

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Oct 09 2:21 PM

First thing first: Did you install the SLX OLEDB Provider on the SQL Server?
Second: Does the account that you are running with have access to the SLX Server/Logging shares?
You may want to consider running SLXSystem as a Service, thus allowing you to set the credentials under which it executes.

Have you tried testing by creating a UDL file?
If not, create a UDL file, then see if the SLX OLEDB PRovider is installed, if it is, choose it and enter your SLX Server info and test the connection. If it works, you have proven that the Provider is installed properly and that you have access to the server. You can then open up the UDL file on Notepad and extract your connection string.

[Reply][Quote]

Bailey1
Posts: 57

Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Oct 09 10:55 AM

Thanks for the reply. I think we know what the problem is, and we are currently waiting to do more testing. I have another question - lots of our reports use temp tables, as the queries are very involved. It looks like the SLX provider does not recognize these temp tables. How do we get around this problem??
Thanks!

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Oct 09 2:55 PM

Quote:

Originally posted by Bailey1

Thanks for the reply. I think we know what the problem is, and we are currently waiting to do more testing. I have another question - lots of our reports use temp tables, as the queries are very involved. It looks like the SLX provider does not recognize these temp tables. How do we get around this problem??
Thanks!

Not easily, I would think.

I would be tempted to write a UDF to get round your GMT problem and then revert to your native SQL connections.

[Reply][Quote]

Ken Pinard
Posts: 5

Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jan 10 4:39 PM

Please post what the porblem was that you found,

Thank you
Ken

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Jan 10 12:50 PM

Quote:

One of the Ways to force SLX to recognize external tables, is to wrap your results with a View that you can then load into SLX.

Also, regarding Temp Tables and Reports, unless these reports are being ran on Remote Users (or Remote Offices), you might want to consider hosting the Temp tables on a Separate Database. Thus keeping the SLX DB Clean.

[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): 11/22/2024 5:20:57 PM