Re: Problem with nvarchar output
Ola Karlsson <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <21475157eed847edb7043a81ea7eb893@DBXPR03MB061.eurprd03.prod.outlook.com> |
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:[email protected]] 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 <[email protected]>: > 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 > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
freetds.txt
(text/plain, 3.1 KB)
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