Posted by Erland Sommarskog on 10/22/62 11:34

(lovkeshanand@gmail.com) writes:
> Now,I made a table in oracle adjacent to sqlserver View and Inserted
> data as:
>...
>
> This insert Satement worked fine,but when I inserted from the view
> already created in SQLSERVER as

Do I understand it correctly that the query for the first INSERT
was a simplified version of the view? The real view appears to use
more tables.

> trace File of tg4msql folder following error comes:-
>
> (0)
> (0) [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL State:
> S1T00; SQL
> (0) Code: 0)
> (0)

The ODBC SQL Server Driver has a default timeout of 30 seconds, as have
several other client APIs. (Don't ask me why; I think it's stupid.) I
have no idea whether you can control it from Oracle.

If you run a SELECT * from the view, on SQL Server how long time does
it take? You may have to look into tuning the query.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]