Viewing 15 posts - 166 through 180 (of 3,366 total)
mick L (9/6/2010)
You can use Enterprise Library for your data access layer that will separate your application from the database layer. It also makes your data access simple.
Use enterprise...
September 6, 2010 at 3:25 pm
mick L (9/6/2010)
So you would recommend only using the presentation layer (report manager and WS) and the DB layer. Problem is the infrastructure folks are unhappy about direct connections...
September 6, 2010 at 2:32 pm
Presentation Layer
Reports Manager for admin reporting
ReportViewer (in MVC Controller) for Business Clients authenticated via membership.
Middle Tier
Reporting Services WebService
Data Tier
ReportServer DB's
I don't see an issue with it but the middle tier...
September 5, 2010 at 4:17 pm
Steve-3_5_7_9 (9/2/2010)
I regularly deal with flat files because we interface with a mainframe. I use this approach.
Use a sql query, or stored...
September 5, 2010 at 4:06 pm
MaricopaJoe (9/5/2010)
The original post was made in the hope that there is some 'recommended practices' from Microsoft. Has anyone see any such white paper?
I am not doing SSRS now...
September 5, 2010 at 4:00 pm
We have been asked to write an SSRS report which displays data from Oracle (32-bit, may be version 10g?) and SQL Server. My plan was to use OPENROWSET and pass...
August 15, 2010 at 4:21 pm
Jenny Richardson (6/30/2010)
Once this was done, I was able to access a new linked server provider in SQL Server, namely OraOLEDB.Oracle, which I...
June 30, 2010 at 7:02 pm
Here is the Refcursor implememtation for VS2008 using the Microsoft provider with restrictions.
http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracledatareader(VS.90).aspx
June 30, 2010 at 4:56 pm
I am not sure if you can do it with OPENQUERY but SSIS 2008 comes with ADO.NET source and destination Refcursors are used in ADO.NET using either the Microsoft connector...
June 30, 2010 at 12:55 pm
I had the client install the 64-bit Oracle OLEDB drivers on the server and tried an OPENROWSET query. It was a simple SELECT query which should have returned only 32...
June 30, 2010 at 9:00 am
but what if it is user subscription, that chan change minute to minute, that generates the recipient list so each new user has the email address as part of the...
May 27, 2010 at 6:24 pm
This works fine on all items except 3 very simple “Execute SQL Task” items. They only contain a simple delete statement:
The above may be the reason for your problem because...
May 27, 2010 at 6:01 pm
This then runs at a particular interval as a scheduled task and I keep our Exchange Admin from breathing down my neck.
This relates to what I was saying about Enterprise...
May 27, 2010 at 5:39 pm
Lynn Pettis (5/27/2010)
Gift Peddie (5/27/2010)
Lynn Pettis (5/27/2010)
Gift Peddie (5/27/2010)
May 27, 2010 at 4:24 pm
Lynn Pettis (5/27/2010)
Gift Peddie (5/27/2010)
May 27, 2010 at 4:12 pm
Viewing 15 posts - 166 through 180 (of 3,366 total)