i have a complex problem. i basically have 3 databases. one access, one
sql 6.5 and one sql 7.0.
i do most of my connecting and querying in the access database. my problem
is that i wrote a query in access that is using linked tables to the sql6.5
database and also to the 7.0.
my query runs perfectly inside my access database...no errors.
but in cf when i try to run this query using:
<cfquery name="qryWork" datasource="ITDATA"> ''''this ITDATA is my access
datasource'''
SELECT * FROM qryWO
</cfquery>
i get an error that says:
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL
ServerBALTMGMT01' failed.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (10:2) to (10:45) in the template
file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM.
the error seems to be in connecting to the sql7.0 dbase.
has anyone run into this problem before? is there an easier way to do a
connection to tables from 2 seperate databases???
thanks for your help.
bec.
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
