CFusion: SQL root table not found err

by "Steve Ball" <sball99(at)mindspring.com>

 Date:  Wed, 30 Aug 2000 12:04:51 -0700
 To:  <hwg-languages(at)hwg.org>
  todo: View Thread, Original
List,
I have a ColdFusion application on Access backend which runs great, but
needs to be scaled up.  I installed SQLServer7 under NT4&NT2000.  I had no
problem using a SQL "wizard" to import the Access tables.  I had no problem
registering the database with CF Administrator.  HOWEVER, when I run a query
the first hit to the CF Server returns "root table not found".  I think it
has something to do with the OWNER attribute in SQLServer (default:dbo) but
I don't know if/how to script for this in ColdFusion.  Any thoughts?
TIA
Steve Ball

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA