1) You have an Access DB that has a bunch of linked Tables from other DBs.
[Which version of Access?]
Access2000. Yes like I mentioned it's a storage place for other databases.
(ie: one of the linked databases changes table names each year so I keep it
in access with an alias name so that I only need to relink once-through link
manager)
2) You have a SQL 2000 DB.
[What is this doing?]
This is the database that I am dumping to/updating/etc. It has all
my info for my application and is what the user hits.
3) You set a request.dsn="GradesSQL" on your application_server page.
[What is an application_server page?]
I use a server page to list out all the global type things. ie: any
time I use a query in any page I use #Request.dsn# instead of the actual
name of my database source as listed in cfadmin. That way if I ever need to
change databases I only have to make the change in one place- the server
application page.
4) In CF Administrator you have verified that you have created DataSource
named GradesSQL to your SQL server.
Yes I checked that is actually linked to the SQL database and verified it as
a good connection.
5) The application only access the GradesAccess (which I assume is the
Access DB), not the SQL 2000 DB.
Yes, when I was doing some testing I made a connection to the access
database. It is still in cfadmin but I don't have anything pointing to it
(or at least I didn't think I did!) However, my pages bring up the info in
the Access database.
The Access database table that is the issue is linked to my sql database.
Like I mentioned the update query shows all the changes on my sql table but
not on my access table! So there's something weird about all of this. I
looked at the linked manager and it is linking to the right tables. (ie: I
made a simple change on my sql table and ran the link manager and the table
changes appeared on my Access database- but the actual data isn't showing
the changes!)
This is all very strange but I have a feeling that it must be something
simple...
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
