Re: Witango-Talk: MS-SQL Views

[John Shaw]

Are you thinking that Witango looks at views as separate datasources?  ----- Original Message ----- From: Troy Sosamon To: [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 9:22 AM Subject: RE: Witango-Talk: MS-SQL Views 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf