On 06/01/2012 09:19 AM, leeand00 wrote: > 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. > In Ubuntu (and I assume Debian) there is a LO-MySQL specific connector package available via Synaptic. The error, from what I am able to find out, is problem with the odbc connector.
-- Jay Lozier [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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
