I am using Cold Fusion MX 7 on Windows 2003 and attempting to connect to an
ODBC data source. The data source (a thoroughbred business basic database on a
linux box) using thoroughbreds ODBC data client and server connects fine and I
can pull the data into excel and into a sql server on the windows 2003 using a
linked server. I can pull the data into coldfusion by selecting the sql server
as a data source and using a linked server in sql server to connect to
thoroughbred but for performance issues I would like to connect directly to the
odbc datasource without sql server in the middle. When I do this the cold
fusion administrator says the odbc data source checks out ok. Once I run a
query in cold fusion on the datasource it pulls all the table names in fine but
the record count is always 0. A simple select * from table_name will pull the
table names in to the cold fusion table names variable but 0 records every
time. I don't understand why excel would pull the data in fine on the same data
source but not a thing in cold fusion. Any tips would be greatly appreciated.