Read Timeout

Hi Friends,

I have the text file in my server which is 21 MB size.

i want to insert that text file into temporary table and then based on the conditions will insert the original table.
But before inserting all the records in temporary table, i got the below error message but the backend process still running(inserting into temp table)

The following error was encountered:Read Timeout

The system returned:

 [No Error]

A Timeout occurred while waiting to read data from the network. The network or server may be down or congested. Please retry your request.

I am using the following code configuration section

<

sessionStatetimeout="600" />

<

httpRuntime

executionTimeout="110"

maxRequestLength="21504"

requestLengthDiskThreshold="80"

useFullyQualifiedRedirectUrl="false"

minFreeThreads="8"

minLocalRequestFreeThreads="4"

appRequestQueueLimit="5000"

enableKernelOutputCache="true"

enableVersionHeader="true"

requireRootedSaveAsPath="true"

enable="true"

shutdownTimeout="90"

delayNotificationTimeout="5"

waitChangeNotification="0"

maxWaitChangeNotification="0"

enableHeaderChecking="true"

sendCacheControlHeader="true"

apartmentThreading="false" />

How to implement the page keep active while all the records are inserted into DB?

If you are using AJAX, you could add an AJAX Timer to show the progress

read from a temporary table

Hi,
How can I reed a value from a temporary table from within a function?

Quote:

Originally Posted by tess1

Hi,
How can I reed a value from a temporary table from within a function?

Can you explain what you mean for temporary table?
Because for all tables same Query will acceptable.|||

Quote:

Originally Posted by hariharanmca

Can you explain what you mean for temporary table?
Because for all tables same Query will acceptable.

I have this function :
CREATE FUNCTION [DBO].[f1]
( )
RETURNS BIT AS
BEGIN
SELECT c1 FROM #xTemp
END

#xTemp has creeted before execute this function f1 and I cannot creat it within the function|||

Quote:

Originally Posted by tess1

I have this function :
CREATE FUNCTION [DBO].[f1]
( )
RETURNS BIT AS
BEGIN
SELECT c1 FROM #xTemp
END

#xTemp has creeted before execute this function f1 and I cannot creat it within the function

i think if you use them in the same transaction.you have no problem.of course if you must use two transaction then set the 'transaction isolation level' to ''dirtyread".|||No you cant access the temporary tables in functions

RDA pull - from a temporary table

Hi

I am doing a RDA Pull with tracking off, getting the data via a stored procedure.

Ideally I want the proc to return the data from a temporary table, so I can do some fancy formatting of the data before we pull it down to the PDA. It's not updateable, so with tracking off, I would have thought this would be possible - but sadly it doesn't work. No error messages, but the table doesn't get created.

I'm using SQL 2005 June CTP if that helps.

Any ideas ?

thanks
Bruce

Here are the details we want:
1) Where is this Store Proc executed and how?

Note: SQL Mobile does not support stored procs in its Database. However you can use RDA.SubmitSql to execute a stored proc, available in SQL Server DB, on SQL Server remotely from SQL Mobile device.

2) SQL Statement in "RDA.Pull" command can only be some thing like
"SELECT col1, col2, col3 from testTable where col4 = 'TEST'".

It CANNOT be some thing like
"Execute sp_createformattedtemptable testTable".

If you want to acheive the functionality you are mentionig, you can do this way:
Before you do RDA Pull, do a RDA Submit SQL and execute store proc. This store proc should create a table with the expected data in expected format. Then use RDA Pull to pull the table down to SQL Mobile device. And, then do RDA Submit SQL to delete the just created temp table.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile