I'm really stuck here! Ive got something funky happening and I'm not sure where to look next. I'm using SQL 2000 and use an Access Front end that holds linked tables from different types of databases. (db4/sql7/etc). (Basically the Access db is for storage or all of the links to other sources but not used in the actual application) On my application_server page I state <CFSET Request.dsn=GradesSQL> In my datasource page in cf admin I have GradesSQL as hitting the SQL database.
However, my application keeps hitting the GradesAccess database. That also is defined in the datasource page but I don't have it listed in any of my global pages- and it's definitely not on the application_server page. I'm wondering if there's somewhere else that I forgot to look? And the weirdest part is I ran an update query- on one of the sql tables. The changes are shown in SQL but in the Access table that is linked to SQL only 1/2 the update ran. (That's how I realized this issue in the first place.) I'm at a complete loss. I feel like I keep staring at the same pages. And I'm a bit afraid of just dropping the GradesAccess datasource in that it'll bring everything to a screeching halt. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
