Problem with MX7 and SQL Express

[bobh22]

I have installed SQL 2005 Express and CF MX7 on XP pro.

SQL 2005 works through SQL Mgt Studio.
I can create a datasource though admin and the datasource verifies OK.
When I try to query this datasource,

<cfquery datasource="myTest" name="mydata">
Select * from myTable
</cfquery>

I get an error that says:

The incoming tabular data stream (TDS) remote procedure call (RPC) protocol
stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown.

I have another datasource defined for a db that is on a remote server (older
version of MSSQL) and this datasourse works (query returns data).

Any one seen this problem with MX7 <-> SQLEXPRESS?

bob

[bobh22]

Nevermind. The "Select Method" had been set to Cursor (fat fingers, I guess). Works fine when I changed it to Direct.