> -----Original Message-----
> From: Jones, Becky
> Sent: Monday, September 17, 2001 11:19 AM
> To: '[EMAIL PROTECTED]'
> Subject: database connections
>
> 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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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
