Hmm, I do this all the time and just verified it works from both CF 4.01 using ODBC and CFMX using the native SQL driver.
Does the user/pass used in your "inforequests" DSN have sufficient rights to the "content" db? Jay At 02:20 PM 2/5/2003, you wrote: >Is this possible from Cold Fusion? If I could do this it would be the best >although I tested it and it didn't work. > >this query: > ><cfquery name="qGetRequestsByAffiliate" datasource="inforequests"> > SELECT contacts.date, contacts.firstname, contacts.mi, >contacts.lastname, contacts.address1, contacts.address2, contacts.city, >contacts.state, contacts.zip, contacts.country, contacts.email, >contacts.homephone, contacts.workphone, contacts.age, names.company, >contacts.usersmessage > FROM dbo.contacts, content.dbo.I_aff_names AS names, >content.dbo.I_zipcodes AS zips > WHERE contacts.ZIP = zips.zip AND zips.chapter = names.id AND >contacts.date > (getDate() - 7) > ORDER BY company, lastname, firstname ></cfquery> > >throws this error: > >ODBC Error Code = S0002 (Base table not found) > >[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name >'content.dbo.I_aff_names'. > > >BTW, I appreciate everyone's help! > >John > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
