Progress and CFMX 7

[tjforce]

I have a question about Progress and CFMX 7. When we were using CFMX 6 we
basically setup the datasource information in CF administrator and created a
application.cfm variable to store the information. The CF datasource was of
type odbc socket. In order to get information from progress the CF code was
this:
<cfquery name="myQry" datasource="#Application.dataSourceProgress#">
SELECT field1, field2
FROM OPENQUERY(SERVERNAME,
'SELECT field1, field2
FROM myTable
WHERE field1 = ''TEST''')
</cfquery>

Since I upgraded to CFMX 7 this does not work. I did find out that you do not
need to use the OPENQUERY in CFMX 7. The strange thing is if you use SELECT
field1, field2...etc the recordset is empty, however, if you use SELECT *...etc
then you get the record back. Does anybody know what is going on? And how do
you do a query without using the wildcard?

[John-Norway]

I don't quite understand the problem:
are you saying that you can't make a working datasource connection since
switching to CF7?
or is it that you don't get the results you expected for this specific query?

If the problem is this specific query then something must be wrong with the
syntax of your WHERE clause - what is following = "Test ??