FreeTDS Development Group

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

Hi,
I was wrong with my affirmation. Using the isql stuff data are correctly
inserted.
But using PHP with ODBC connection, the stuff isn't correct and I've got a
warning.
According many reading, I thought that the error reported should be on a 6
digit code, but the PHP error log give me a warning with a state of 00000,
and the insert command is not done.

Any Idea to make tests ?
Regards

-----Message d'origine-----
De : freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]De la part de James K. Lowden
Envoye : mercredi 24 novembre 2004 07:18
A : FreeTDS Development Group
Objet : Re: [freetds] Inserting data into tables[Ce message a ete
verifie]


"Pascal Miquet" <p.miquet AT hafiba.fr> wrote:
> Thanks for your reply, but the insert command is issued into the isql
> interface.
> The command is something like
> INSERT LOG(EventId,loginID) VALUES ('1','155')
>
> I've also validate the dump of freeTDS into a log file, and see nothing
> special.

Please post the TDSDUMP log.  I don't see how it could be anything except
server-side, but the log should show evidence of the rejection, and why.

I would be good if the SQL were something like:

INSERT LOG(EventId,loginID) VALUES ('1','155')
SELECT EventId,loginID from LOG where EventID = 1

--jkl



> -----Message d'origine-----
> De : freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org]De la part de Lowden, James K
> Envoye : mardi 23 novembre 2004 16:13
> A : FreeTDS Development Group
> Objet : RE: [freetds] Inserting data into tables[Ce message a ete
> verifie]
>
>
> > From: Pascal Miquet
> > Sent: Tuesday, November 23, 2004 10:05 AM
> >
> > I've configured freeTDS to be used with the unixODBC to connect to an
> MS SQL
> > server.
> > If I use the isql interface to issue some SELECT commands, all return
> are
> > correct.
> > BUT I can't issue an ISNERT command.
> > The result is "SQLRowCount returns -1"
> > Is there some flags to allow freeTDS to issue such INSERT commands ?
>
> If you're issuing SQL text like "insert T values ('a', 'b')", FreeTDS is
> only conveying the SQL to the server (there's nothing special about
> INSERT).  If the row isn't inserted, there's a problem with permissions
> or the data, or you've violated the "process all results" rule in your
> application.
>
> I suggest you try the command with isql or tsql to see if you get a more
> useful error message.
>
> HTH.
>
> --jkl
>
> -----------------------------------------
> The information contained in this transmission may contain privileged
> and confidential information and is intended only for the use of the
> person(s) named above. If you are not the intended recipient, or an
> employee or agent responsible for delivering this message to the
> intended recipient, any review, dissemination, distribution or
> duplication of this communication is strictly prohibited. If you are not
> the intended recipient, please contact the sender immediately by reply
> e-mail and destroy all copies of the original message. Please note that
> we do not accept account orders and/or instructions by e-mail, and
> therefore will not be responsible for carrying out such orders and/or
> instructions. If you, as the intended recipient of this message, the
> purpose of which is to inform and update our clients, prospects and
> consultants of developments relating to our services and products, would
> not like to receive further e-mail correspondence from the sender,
> please "reply" to the sender indicating your wishes.  In the U.S.: 1345
> Avenue of the Americas, New York, NY 10105.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds