Search results for query: *

I'm having the exact same problem. Could you geto your IIS to work fine? Thanks, Andre Almeida

Some times IIS stops responding after logging some warnings --- with event ID 37, source - w3svc Out of process application '/LM/W3SVC/1/Root' terminated unexpectedly. For additional information specific to this message please visit the Microsoft Online Support site located at...

The problem was with the SaveRecord sub called from the end of the sub above. Thank you very much.

That's correct. Thanks.

I have this sub and this SP. SOMETIMES I get the message: "THE OPERATION IS NOT ALLOWED WHEN THE OBJECT IS CLOSED" I'm using SQL Server 7 and IIS on a Windows 2000 Server. I can't understand why it happens only sometimes. And when it fails I just refresh the page and it works with...

It worked! Using OPENQUERY forced the Oracle Server to run a controlled SELECT. I only had to change the WHERE clause to match the PK Index, so the query would have the least cost as possible. With the original SELECT I had a cost of 5886. With the SELECT suggested by you it lowered to 307, and...

I checked OpenQuery on Books OnLine and it seems to work on Oracle providers. I'll try it and let you know. Andre.

I tried using OLE DB provider for Oracle when I did the insert through Linked Servers using the code above. The Oracle dba told me that doing the insert this way generated a even worse select on his server. I'm not familiar with OpenQuery. What does it do? Thanks in advance. André

it looks to me like you are inserting the entire contents of the table every time since there is no where clause. Is this what you intended to do? Yes, that´s correct. Before I insert the data I truncate the table on SQL and populate it again with new data. I´ve already tried to talk to the...

I have a DTS created to insert data from a table on SQL Server 7 in a table on an Oracle Server. The DTS runs fine and inserts the data correctly. The Oracle DBA has complained to me that my DTS is running a SELECT * FROM tablename on the Oracle Server every time it runs. The table has more than...