|
|
Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services 
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? |
|
|
|
Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services
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.
|
|
|
|
Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services
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! |
|
|
|
Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services
Posted: 23 Oct 09 2:55 PM
|
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. |
|
|
| |
|
Re: Need Help connecting to SLX 7.5 OLE DB Provider from Sql Server Reporting Services
Posted: 26 Jan 10 12:50 PM
|
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! |
|
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. |
|
|
|