[libreoffice-users] Invalid descriptor Index 07009 when using a query parameter?

Good day all, 

I'm trying to query a MySQL Database (Ver 14.14 Distrib 5.5.22 for
debian-linux-gnu (i686) using readline 6.2) for purposes of generating a
report in OpenOffice Base (3.5.3.2 Build ID 350m1 (Build:2)). 

I am connecting via ODBC, and my /etc/odbc.ini looks like this:

[DESP]
Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so
Description = MyODBC 3.51 Driver DSN
SERVER = localhost
PORT =
USER = root
Password = XXXXX
Database = DigitalEditionsSolution
OPTION = 3
SOCKET =

My query has one parameter, and it ends up giving me an error unrelated to
the syntax:

SELECT dfw.fk_desp_id, dfw.fk_dfws_id, dfw.Features_f_id, desp.name AS
DESP_Name, f.name AS FeatureName, dfws.name As ResponseState 
FROM 
DESP_Feature_Weak_State dfws RIGHT OUTER JOIN
(DigitalEditionsSolutionProvider desp INNER JOIN (Features f INNER JOIN
DESP_Features_Weak dfw ON f.f_id = dfw.Features_f_id) ON desp.desp_id =
dfw.fk_desp_id) ON dfws.dfws_id = dfw.fk_dfws_id
WHERE desp.desp_id=:despnum AND
(f.name="auto-linking-of-email-addresses:yes" OR
f.name="auto-linking-of-urls:yes" OR f.name="newsstandsupport:yes")
ORDER BY fk_desp_id;

When I run the above query, and enter my named parameter, it returns with
three errors:
- The data content could not be loaded
- SQL Status: 07009  

   Invalid descriptor index

- You tried to set a parameter at position '1' but there is/are only '0'
parameter(s) allowed. One reason may be that the property
"ParameterNameSubstitution" is not set to TRUE in the data source.

I found a thread on google concerning this same error in which someone said
checking off all of the Edit->Database->Advanced Settings options would
cause it to work, but I tried that, and even restarted Base, with out any
success, leading to the same error.

Thank you,
   Andrew J. Leer

--
View this message in context: 
http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted