FreeTDS Development Group

[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
10:13:50.541630 46051 (log.c:480):type varchar has value "{xxxxxx/orp_insert};
 {0:4153} Artikel är markerad som utgående, enligt aktuell planering finns 
registrerat antal EJ DISPONIBELT !
Artikelnr = 84062-10
Lagerställe = 1
Lagersaldo = 2.000000
Reserv ant (behov) = 1.000000
Disp lagersaldo = 1.000000
Beställt antal = 0.000000
Beord ant hos prod = 0.000000
TotLagerSaldo = 1.000000
Orderradantal = 3.000000

Orderrader, artiklar (produkter) =
        Ordernummer = 28387
        Restordernr = 0
        Orderradnr = 60
        Ord.radnr f paket = 0
        Artikelnr = 84062-10

orp_insert - Info : 
10:13:52.030<#>52.030<1>52.030<2>52.030<2>52.030<7>52.030<8>52.030<9>52.030<9>52.033<10>52.033<10>52.033<11>52.033<12>52.033<13>52.033<14>52.033<16>52.033<20>52.$


++++++++++++++++++++++++++++++++++++
Called from: ic_spr_Excel_PlaceOrder
ic_spr_Excel_PlaceOrder - Info : @@NestLevel=1"
10:13:50.541640 46051 (token.c:555):processing result tokens.  marker is  
fe(DONEPROC)
10:13:50.541647 46051 (token.c:2339):tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
10:13:50.541654 46051 (token.c:2370):                rows_affected = 0
10:13:50.542019 46051 (net.c:555):Received header
0000 04 01 00 11 00 39 01 00-                        |.....9..|

10:13:50.542056 46051 (net.c:609):Received packet
0000 04 01 00 11 00 39 01 00-fd 20 00 fd 00 00 00 00 |.....9.. . ......|
0010 00                     -                        |.|

10:13:50.542072 46051 (token.c:555):processing result tokens.  marker is  
fd(DONE)
10:13:50.542081 46051 (token.c:2339):tds_process_end: more_results = 0
                was_cancelled = 1
                error = 0
                done_count_valid = 0
10:13:50.542088 46051 (token.c:2355):tds_process_end() state set to TDS_IDLE
10:13:50.542096 46051 (util.c:156):Changed query state from READING to IDLE
10:13:50.542103 46051 (token.c:2370):                rows_affected = 0
10:13:50.542126 46051 (dblib.c:5854):dbcanquery(0x7f9b0e496110)
10:13:50.542135 46051 (token.c:540):tds_process_tokens(0x7f9b0e496ad0, 
0x7fff97865fec, (nil), 0x108)
10:13:50.542143 46051 (token.c:543):tds_process_tokens() state is COMPLETED
10:13:50.542158 46051 (dblib.c:1668):dbresults(0x7f9b0e496110)
10:13:50.542166 46051 (dblib.c:1674):dbresults: dbresults_state is 3 
(_DB_RES_NEXT_RESULT)
10:13:50.542173 46051 (token.c:540):tds_process_tokens(0x7f9b0e496ad0, 
0x7fff97865fb8, 0x7fff97865fbc, 0x6914)
10:13:50.542180 46051 (token.c:543):tds_process_tokens() state is COMPLETED
10:13:50.542186 46051 (dblib.c:1695):dbresults() tds_process_tokens returned 
2 (TDS_NO_MORE_RESULTS),
                        result_type TDS_DONE_RESULT
10:13:50.542194 46051 (dblib.c:1657):dbresults returning 2 (NO_MORE_RESULTS)
10:13:50.542562 46051 (dblib.c:1443):dbclose(0x7f9b0e496110)
10:13:50.542579 46051 (dblib.c:258):dblib_del_connection(0x7f9b0471c760, 
0x7f9b0e496ad0)
10:13:50.542586 46051 (mem.c:615):tds_free_all_results()
10:13:50.542621 46051 (util.c:156):Changed query state from IDLE to DEAD