FreeTDS Development Group

["Pascal Miquet" <p.miquet AT hafiba.fr>]

Hi,

I've started from scratch..
Using a new Database on MS SQL
Defining a new DSN into freetds and odbc(inst).ini

Test were done using tsql isql and an very small php script.

And insertion where successfull.
I'll take a look to the other stuff.

Thanks for your help.
Regards

-----Message d'origine-----
De : freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]De la part de ZIGLIO,
Frediano, VF-IT
Envoyé : vendredi 26 novembre 2004 11:37
À : FreeTDS Development Group
Objet : RE: [freetds] Inserting data into tables[Ce message a ete
verifie]




> -----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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

<<attachment: winmail.dat>>