RE: Witango-Talk: MS-SQL Views

[Troy Sosamon]

Sounds like some type of issue with the datasourecetimeout. 

Try changing your datasourcetimeout to 24 hours.  The default is 30 min, and it is in seconds.

 

Troy Sosamon

 

-----Original Message-----
From: John Shaw [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 5:18 AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: MS-SQL Views

Hi all,

 

I'm using a view to get info from another MS-SQL db.  A vendor hits my taf each morning and it fails.  After it fails the first time, I can hit the taf and it doesn't fail.  Over the weekend I hit the taf first and got the following error.  The error is referring to a view.  Of course, it worked on the second try.  So the first time the view is hit each day it fails, but only the first time.

 

Anybody ever see this before?  Thanks.

John

 

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [Non-interface error: Schema version number changed from compile time (32810892093993399) to run time (32810892093993351) for ProviderName='SQLOLEDB' TableName='"AngelBase"."dbo"."TYPES"'
01000

 

 

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf