Hi there:

We have an ASP.NET 3.5 application built using the ReportViewer 2008. Our web app is in a web server A and the reportServer is in the DataBase Server B....

Yep, Visio is great, but the diagrams are UML diagrams and those are not exactly ER models. In the company I work for they require the diagrams to be ER...

Re-installing did not work, I even installed the SP4 after reinstalling it and it did not work either.

Then I tried to re-register the sqlOleDb.dll and that did not work (even...

Hi there:

I have the same problem, I see the "there was a problem retrieving the list of OLE DB Providers", but I am not connecting to Oracle, just SQL Server...

Thanks Sergyi, Matt and Jeffrey, so there is no way to achieve this in T-SQL for SQL Server 2000?

Seems like trying to cover all the failure scenarios is the only...

Thanks for the reply, even it did not answer my original question it help me somehow.

Good way to solve the problem.

Ok, I just changed some columns and table names for secutiry reasons:

DECLARE CURSOR_TEMP CURSOR FOR

SELECT Key1, Key2, Data1

FROM INT_Table

OPEN CURSOR_TEMP

FETCH NEXT FROM CURSOR_TEMP

INTO @Key1, @Key2, @Data1

WHILE @@FETCH_STATUS = 0

BEGIN

SET @ERROR...

Hi:

I am doing it row by row, but if inserting in a batch is better I would give it a try.

Thanks

Thanks for the reply Jeff.

Reading the article helped me to get somethings clear, but I still found the "significant volume of data" in the "In general, you use table variables...

Why would 8k be a trouble?

Hi Lester:

thanks for the reply.

Yes, we already tried using the network path (i.e: \\Server2\SharedFolder) but the error I mentioned above, showed up when trying this. So what I really need...