Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with nvarchar output

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem with nvarchar output
  • Date: Mon, 4 Aug 2014 17:27:12 +0100

Hi,
sorry for late reply.

I looked at PHP code to try to understand the sequence. It seems to me that
you called mssql_execute (which is ok) and the procedure got the right
result but then instead of calling mssql_next_result you just freed the
statement which cause the store procedure parameters to be discarded. Is it
right?

Frediano


Frediano


2014-08-01 18:32 GMT+01:00 Frediano Ziglio <freddy77 AT gmail.com>:

> I just realised you posted most of information in the first mail you sent
>
> Frediano
>
>
> 2014-08-01 17:06 GMT+01:00 Frediano Ziglio <freddy77 AT gmail.com>:
>
> Looks like something upset PHP code. Are you using mssql module, right?
>> Which PHP version? Which PHP function are you calling, mssql_query ?
>>
>>
>> Frediano
>>
>>
>> 2014-07-31 15:01 GMT+01:00 Ola Karlsson <olka AT bagheera.se>:
>>
>> I´ve attached a bigger log but I find it difficult to see what is exactly
>>> related to this query so perhaps I´ve still missed something.
>>> Will adding logg details for a specific instance in freetds.conf cause
>>> only logging for that instance, in my case [ap1Dev], or will it still logg
>>> for all instances?
>>>
>>> If it’s the encoding is it a PHP problem or FreeTDS setting that needs
>>> to change?
>>>
>>> BR
>>> Ola
>>>
>>> -----Ursprungligt meddelande-----
>>> Från: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] För Frediano
>>> Ziglio
>>> Skickat: den 31 juli 2014 15:41
>>> Till: FreeTDS Development Group
>>> Ämne: Re: [freetds] Problem with nvarchar output
>>>
>>> The upper layer decided to cancel the query. The reason could be
>>> previously in the log.
>>> Looks like you are using an encoding which cannot support your charset
>>> (there are some question marks in the output string possibly result of a
>>> wrong conversion).
>>>
>>> Frediano
>>>
>>>
>>> 2014-07-31 9:44 GMT+01:00 Ola Karlsson <olka AT bagheera.se>:
>>>
>>> > Hi,
>>> > Sorry for the delay. Went on hollidays for a few weeks :)
>>> >
>>> > As far as I can see my error message is stated in the log exactly as
>>> > it should be and it also states two returned results.
>>> > The integer value is returned correctly but not the nvarchar.
>>> >
>>> > I have attached a portion of the log containing the procedure call and
>>> > my error message.
>>> > I don't notice any error messages or so but then again theres a lot of
>>> > information in the logs.
>>> >
>>> > No errors in the php logs either.
>>> >
>>> > Any ideas?
>>> >
>>> >
>>> > BR
>>> > Ola
>>> >
>>> > -----Ursprungligt meddelande-----
>>> > Från: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] För Frediano
>>> > Ziglio
>>> > Skickat: den 12 juli 2014 09:06
>>> > Till: FreeTDS Development Group
>>> > Ämne: Re: [freetds] Problem with nvarchar output
>>> >
>>> > Hi,
>>> > did you check TDSDUMP ?
>>> >
>>> > Frediano
>>> >
>>> >
>>> > 2014-07-06 14:32 GMT+01:00 Ola Karlsson <olka AT bagheera.se>:
>>> >
>>> > > Hi
>>> > > I'm using Freetds with PHP5 to access a SQL server but I'm having
>>> > > trouble with the output parameters.
>>> > > I have two parameters, one SQLINT4 and one SQLVARCHAR. The int is
>>> > > working but I don't get any returns from the varchar.
>>> > >
>>> > > Is there anything special that needs to be done when outputting
>>> nvarchar?
>>> > >
>>> > > PHP binds,
>>> > > mssql_bind($stmt, '@ErrorMsg',$ErrorMsg,SQLVARCHAR,true,false,4000);
>>> > > mssql_bind($stmt, '@OrderNr',$OrderNr,SQLINT4,true,true,8);
>>> > >
>>> > > SQL parameters,
>>> > > @ErrorMsg nvarchar(4000) output
>>> > > @OrderNr Jeeves_OrderNo output
>>> > >
>>> > >
>>> > > Sql server,
>>> > > SQL Server 2008 R2
>>> > >
>>> > > Freetds server,
>>> > > Ubuntu 12.04 3.5.0-51-generic
>>> > >
>>> > > Tsql -C
>>> > > Version: freetds v0.91
>>> > > freetds.conf directory: /etc/freetds MS db-lib source compatibility:
>>> > > no Sybase binary compatibility: yes Thread safety: yes iconv
>>> > > library: yes TDS version: 4.2
>>> > > iODBC: no
>>> > > unixodbc: yes
>>> > > SSPI "trusted" logins: no
>>> > > Kerberos: no
>>> > >
>>> > > Freetds conf,
>>> > > [global]
>>> > > text size = 64512
>>> > > [Sqlserver]
>>> > > host = xxx.xxx.xxx.xxx
>>> > > port = xxxx
>>> > > tds version = 8.0
>>> > >
>>> > > PHP5
>>> > > PHP 5.3.10-1ubuntu3.12
>>> > >
>>> > >
>>> > > BR
>>> > > Ola
>>> > > _______________________________________________
>>> > > 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
>>> >
>>> > _______________________________________________
>>> > 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
>>>
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS AT lists.ibiblio.org
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>>
>>
>




Archive powered by MHonArc 2.6.24.

Top of Page