<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] A97 to A2K conversion issues</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Some thoughts:</FONT>
<BR><FONT SIZE=2>1) You might try deleting the linked table and relinking. This has often solved mystery ODBC problems for me.</FONT>
<BR><FONT SIZE=2>2) The ODBC driver may be timing out. Increase the timeout value in the query.</FONT>
<BR><FONT SIZE=2>3) In many instances setting up multiple key indexes to linked tables dramatically slows downs queries to where they timeout.</FONT></P>
<P><FONT SIZE=2>HTH</FONT>
<BR><FONT SIZE=2>Jim Hale</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Paul M. Jones [<A HREF="mailto:pjones@btl.net">mailto:pjones@btl.net</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, June 04, 2003 11:30 AM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: [AccessD] A97 to A2K conversion issues</FONT>
</P>
<BR>
<P><FONT SIZE=2>I have an A97 application that connects to SQL Server 2000 via ODBC that </FONT>
<BR><FONT SIZE=2>has been running for the last couple of years. I recently converted it to </FONT>
<BR><FONT SIZE=2>A2K. I have since found a lot of quirky things that has led me to rewrite </FONT>
<BR><FONT SIZE=2>certain parts of my code that functions perfectly well under A97. My latest </FONT>
<BR><FONT SIZE=2>problem is that I have a fairly complex query that selects information from </FONT>
<BR><FONT SIZE=2>several other queries. This query now gives me an 'ODBC--called' failed </FONT>
<BR><FONT SIZE=2>error under A2k even though all the smaller queries that it selects from </FONT>
<BR><FONT SIZE=2>work ok. I am now thinking I might need to create temporary tables rather </FONT>
<BR><FONT SIZE=2>than using queries as the source of the final query. Without getting into </FONT>
<BR><FONT SIZE=2>the details of the various queries, anyone has any ideas on parameters or </FONT>
<BR><FONT SIZE=2>configurations that can be made with A2K before I take the route of redoing </FONT>
<BR><FONT SIZE=2>a ton of work?</FONT>
</P>
<P><FONT SIZE=2>On another note, for anyone planning to do this type of upgrade on Windows </FONT>
<BR><FONT SIZE=2>2000 systems, please be sure that they all have SP3 installed. A2K did not </FONT>
<BR><FONT SIZE=2>work properly on any of the Win2K systems that had SP1 or SP2. Only with </FONT>
<BR><FONT SIZE=2>SP3 did I get consistency I expected from what was supposed to be a simple </FONT>
<BR><FONT SIZE=2>upgrade.</FONT>
</P>
<P><FONT SIZE=2>Paul M. Jones</FONT>
<BR><FONT SIZE=2>Spire Services Ltd.</FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>