it does. i can connect to all the databases alone just fine. it is when i
try to join them is where i get the error.
-----Original Message-----
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 5:03 PM
To: CF-Talk
Subject: RE: database connections
Check to make sure the Cold Fusion service account has access to the SQL
database. Or maybe use the User and Password attributes of the CFQuery tag.
Good luck.
Shawn Grover
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 1:58 PM
To: CF-Talk
Subject: database connections
> -----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
