FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Pascal Miquet
> Sent: venerdì 26 novembre 2004 11.28
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] Inserting data into tables[Ce message 
> a ete verifie]
> 
> 
> Thanks for your reply.
> But I wonder why this request seems to work fine with IIS and 
> a "direct" ODBC on a Windows System.
> 
> Regards
> 
> -----Message d'origine-----
> De : freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org]De la part de 
> Thompson, Bill D
> (London)
> Envoyé : vendredi 26 novembre 2004 11:16
> À : FreeTDS Development Group
> Objet : RE: [freetds] Inserting data into tables[Ce message a ete
> verifie]
> 
> 
> pascal,
> 
> The problem appears to the incorrect formation of the 
> following SQL that
> is being submitted.
> 
> SELECT lbl.LabelMultiLg_Id, lbl.LabelMultiLg_Txt   
> FROM LabelMultiLg lbl,LoginParam l  
> WHERE l.loginId              = :  
> AND   l.UserParamID          = 'f3_langue'  
> AND   lbl.LabelMultiLg_Lg    = l.LoginParamValue  
> AND   isnull(lbl.LabelMultiLg_Include,0) = 1 
> 
> SQL server is objecting (quite rightly) to the first line of the where
> clause....
> I'd check the SQL you are sending...
> 
> Bill

SQL Query Analyzer say

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ':'.

So the error seems ':'. I don't understand where this come... perhaps it's a 
problem preparing statement?

freddy77