Can you clearly describe your problem?
So far I have this much...
1) You have an Access DB that has a bunch of linked Tables from other DBs.
[Which version of Access?]
2) You have a SQL 2000 DB.
[What is this doing?]
3) You set a request.dsn="GradesSQL" on your application_server page.
[What is an application_server page?]
4) In CF Administrator you have verified that you have created DataSource
named GradesSQL to your SQL server.
5) The application only access the GradesAccess (which I assume is the
Access DB), not the SQL 2000 DB.
Is this correct?
-----Original Message-----
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 2:34 PM
To: CF-Talk
Subject: Repost: Data-sources-please help-I'm at a loss
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
