Skip to Content.
Sympa Menu

freetds - Re: [freetds] variable problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Costel Cotae <costel.cotae AT dobrogeagrup.ro>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] variable problem
  • Date: Mon, 10 Jan 2005 12:45:17 +0200

ZIGLIO, Frediano, VF-IT wrote:

I have a procedure witch have the the following parameters


startTime nvchar(22)

i define in php like this
$startTime = "01/10/2005 00:00:00";

mssql_bind($proc, "@startTime", $startTime, SQLVARCHAR);

mssql_execute($proc);
mssql_free_statement ($proc);
mssql_close($s);


and when i try to execute the function is giving me

.PHP Warning: mssql_execute(): message: Procedure 'reportLastAccess' expects parameter '@startTime', which was not supplied. (severity 16) in /var/www/html/intranet.dobrogeagrup.org/personal/access/lastac
cess.php on line 64



Hi Coti.

Which FreeTDS version are you using? Can you enable logging and post it
?

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

i'm using version freetds-0.62.1-1 of FreeTDS


Starting log file for FreeTDS 0.62.1
on 2005-01-10 12:38:09 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "ISO-8859-1" character set
12:38:09.002536 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
12:38:09.002592 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
12:38:09.002622 Connecting to 192.168.100.14 port 1433, TDS 7.0.
12:38:09.002926 tds_put_string converting 8 bytes of "Srvlin02"
12:38:09.002982 tds_put_string wrote 16 bytes
12:38:09.002999 tds_put_string converting 2 bytes of "sa"
12:38:09.003016 tds_put_string wrote 4 bytes
12:38:09.003032 tds_put_string converting 7 bytes of "PHP 4.0"
12:38:09.003050 tds_put_string wrote 14 bytes
12:38:09.003065 tds_put_string converting 7 bytes of "centaur"
12:38:09.003082 tds_put_string wrote 14 bytes
12:38:09.003154 tds_put_string converting 10 bytes of "DB-Library"
12:38:09.003171 tds_put_string wrote 20 bytes
12:38:09.003186 tds_put_string converting 7 bytes of "english"
12:38:09.003203 tds_put_string wrote 14 bytes
12:38:09.003219 tds_put_string wrote 0 bytes
12:38:09.003266 tds_process_login_tokens()
Received header @ 12:38:09.003621
0000 04 01 01 9c 00 00 00 00- |........|


Received packet @ 12:38:09.003660
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |\uffff....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 64 |..m.a.s. t.e.r.\uffffd|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 07 43 00 45 00-4e 00 54 00 41 00 55 00 |....C.E. N.T.A.U.|
0080 52 00 00 00 00 e3 17 00-02 0a 75 00 73 00 5f 00 |R....\uffff.. ..u.s._.|
0090 65 00 6e 00 67 00 6c 00-69 00 73 00 68 00 00 ab |e.n.g.l. i.s.h..\uffff|
00a0 68 00 47 16 00 00 01 00-27 00 43 00 68 00 61 00 |h.G..... '.C.h.a.|
00b0 6e 00 67 00 65 00 64 00-20 00 6c 00 61 00 6e 00 |n.g.e.d. .l.a.n.|
00c0 67 00 75 00 61 00 67 00-65 00 20 00 73 00 65 00 |g.u.a.g. e. .s.e.|
00d0 74 00 74 00 69 00 6e 00-67 00 20 00 74 00 6f 00 |t.t.i.n. g. .t.o.|
00e0 20 00 75 00 73 00 5f 00-65 00 6e 00 67 00 6c 00 | .u.s._. e.n.g.l.|
00f0 69 00 73 00 68 00 2e 00-07 43 00 45 00 4e 00 54 |i.s.h... .C.E.N.T|
0100 00 41 00 55 00 52 00 00-00 00 e3 0f 00 03 05 69 |.A.U.R.. ..\uffff....i|
0110 00 73 00 6f 00 5f 00 31-00 01 00 00 e3 0b 00 05 |.s.o._.1 ....\uffff...|
0120 04 31 00 30 00 33 00 33-00 00 e3 0f 00 06 06 31 |.1.0.3.3 ..\uffff....1|
0130 00 39 00 36 00 36 00 30-00 39 00 00 ad 36 00 01 |.9.6.6.0 .9..\uffff6..|
0140 07 00 00 00 16 4d 00 69-00 63 00 72 00 6f 00 73 |.....M.i .c.r.o.s|
0150 00 6f 00 66 00 74 00 20-00 53 00 51 00 4c 00 20 |.o.f.t. .S.Q.L. |
0160 00 53 00 65 00 72 00 76-00 65 00 72 00 00 00 00 |.S.e.r.v .e.r....|
0170 00 07 00 02 6f e3 13 00-04 04 34 00 30 00 39 00 |....o\uffff.. ..4.0.9.|
0180 36 00 04 34 00 30 00 39-00 36 00 fd 00 00 00 00 |6..4.0.9 .6.\uffff....|
0190 00 00 00 00 - |....|


12:38:09.003853 looking for login token, got e3(ENVCHANGE)
12:38:09.003876 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 12 from wire to give 6 to client.
12:38:09.003935 looking for login token, got ab(INFO)
:12:38:09.003951 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 74 from wire to give 37 to client.
tds_get_string: reading 14 from wire to give 7 to client.
12:38:09.004007 looking for login token, got e3(ENVCHANGE)
12:38:09.004024 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
12:38:09.004054 looking for login token, got ab(INFO)
12:38:09.004069 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 14 from wire to give 7 to client.
12:38:09.004181 looking for login token, got e3(ENVCHANGE)
12:38:09.004198 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 10 from wire to give 5 to client.
tds_get_string: reading 2 from wire to give 1 to client.
12:38:09.004256 looking for login token, got e3(ENVCHANGE)
12:38:09.004272 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
12:38:09.004301 looking for login token, got e3(ENVCHANGE)
12:38:09.004317 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
12:38:09.004347 looking for login token, got ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
12:38:09.004377 looking for login token, got e3(ENVCHANGE)
12:38:09.004393 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 8 from wire to give 4 to client.
12:38:09.004434 increasing block size from 4096 to 4096
12:38:09.004461 looking for login token, got fd(DONE)
12:38:09.004478 tds_process_default_tokens() marker is fd(DONE)
12:38:09.004496 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
12:38:09.004514 tds_process_end() state set to TDS_IDLE
12:38:09.004530 leaving tds_process_login_tokens() returning 1
12:38:09.004558 tds_put_string converting 19 bytes of "set textsize 64512 "
12:38:09.004576 tds_put_string wrote 38 bytes
Sending packet @ 12:38:09.004592
0000 01 01 00 2e 00 00 01 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .|


Received header @ 12:38:09.004837
0000 04 01 00 11 00 00 00 00- |........|


Received packet @ 12:38:09.004871
0000 fd 00 00 be 00 00 00 00-00 |\uffff..\uffff.... .|


12:38:09.004892 processing result tokens. marker is fd(DONE)
12:38:09.004909 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
12:38:09.004927 tds_process_end() state set to TDS_IDLE
12:38:09.004943 tds_process_result_tokens() state is COMPLETED
12:38:09.005196 dbuse()
12:38:09.005221 dbcmd() bufsz = 0
12:38:09.005237 in dbsqlexec()
12:38:0912:38:09.005292 tds_put_string converting 16 bytes of "use [Pro-Report]"
12:38:09.005313 tds_put_string wrote 32 bytes
Sending packet @ 12:38:09.005329
0000 01 01 00 28 00 00 01 00-75 00 73 00 65 00 20 00 |...(.... u.s.e. .|
0010 5b 00 50 00 72 00 6f 00-2d 00 52 00 65 00 70 00 |[.P.r.o. -.R.e.p.|
0020 6f 00 72 00 74 00 5d 00- |o.r.t.].|


12:38:09.005389 in dbsqlok()
Received header @ 12:38:09.005593
0000 04 01 00 a6 00 00 00 00- |...\uffff....|


Received packet @ 12:38:09.005626
0000 e3 23 00 01 0a 50 00 72-00 6f 00 2d 00 52 00 65 |\uffff#...P.r .o.-.R.e|
0010 00 70 00 6f 00 72 00 74-00 06 6d 00 61 00 73 00 |.p.o.r.t ..m.a.s.|
0020 74 00 65 00 72 00 ab 6c-00 45 16 00 00 01 00 29 |t.e.r.\uffffl .E.....)|
0030 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d. |
0040 00 64 00 61 00 74 00 61-00 62 00 61 00 73 00 65 |.d.a.t.a .b.a.s.e|
0050 00 20 00 63 00 6f 00 6e-00 74 00 65 00 78 00 74 |. .c.o.n .t.e.x.t|
0060 00 20 00 74 00 6f 00 20-00 27 00 50 00 72 00 6f |. .t.o. .'.P.r.o|
0070 00 2d 00 52 00 65 00 70-00 6f 00 72 00 74 00 27 |.-.R.e.p .o.r.t.'|
0080 00 2e 00 07 43 00 45 00-4e 00 54 00 41 00 55 00 |....C.E. N.T.A.U.|
0090 52 00 00 01 00 fd 00 00-e2 00 00 00 00 00 |R....\uffff.. \uffff.....|


12:38:09.005710 dbsqlok() marker is e3
12:38:09.005726 processing result tokens. marker is e3(ENVCHANGE)
12:38:09.005742 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
tds_get_string: reading 12 from wire to give 6 to client.
12:38:09.005788 processing result tokens. marker is ab(INFO)
12:38:09.005804 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 82 from wire to give 41 to client.
tds_get_string: reading 14 from wire to give 7 to client.
12:38:09.005872 processing result tokens. marker is fd(DONE)
12:38:09.005889 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
12:38:09.005908 tds_process_end() state set to TDS_IDLE
12:38:09.005924 dbsqlok() end status was success
12:38:09.005940 dbresults()
12:38:09.005954 dbresults_r()
12:38:09.005968 tds_process_result_tokens() state is COMPLETED
12:38:09.005984 leaving dbresults() returning 1
12:38:09.006000 tds_process_row_tokens() state is COMPLETED
12:38:09.006030 dbrpcinit() added rpcname "reportLastAccess"
12:38:09.006398 dbrpcparam() added parameter "@startTime"
12:38:09.006428 dbrpcparam() added parameter "@endTime"
12:38:09.006481 dbrpcparam() added parameter "@siteID"
12:38:09.006502 dbrpcparam() added parameter "@reportID"
12:38:09.006523 dbrpcparam() added parameter "@nameStyle"
12:38:09.006556 dbrpcparam() added parameter "@langID"
12:38:09.006577 dbrpcparam() added parameter "@tableID"
12:38:09.006598 dbrpcparam() added parameter "@evSiteID"
12:38:09.006620 dbrpcparam() added parameter "@reportType"
12:38:09.006639 dbrpcsend()
Sending packet @ 12:38:09.006672
0000 03 01 00 2c 00 00 01 00-10 00 72 00 65 00 70 00 |...,.... ..r.e.p.|
0010 6f 00 72 00 74 00 4c 00-61 00 73 00 74 00 41 00 |o.r.t.L. a.s.t.A.|
0020 63 00 63 00 65 00 73 00-73 00 00 00 |c.c.e.s. s...|
:
.005256 in dbsqlse

12:38:09.006737 in dbsqlok()
Received header @ 12:38:09.007162
0000 04 01 00 f6 00 00 00 00- |...\uffff....|


Received packet @ 12:38:09.007196
0000 aa e2 00 c9 00 00 00 01-10 54 00 50 00 72 00 6f |\uffff\uffff.\uffff.... .T.P.r.o|
0010 00 63 00 65 00 64 00 75-00 72 00 65 00 20 00 27 |.c.e.d.u .r.e. .'|
0020 00 72 00 65 00 70 00 6f-00 72 00 74 00 4c 00 61 |.r.e.p.o .r.t.L.a|
0030 00 73 00 74 00 41 00 63-00 63 00 65 00 73 00 73 |.s.t.A.c .c.e.s.s|
0040 00 27 00 20 00 65 00 78-00 70 00 65 00 63 00 74 |.'. .e.x .p.e.c.t|
0050 00 73 00 20 00 70 00 61-00 72 00 61 00 6d 00 65 |.s. .p.a .r.a.m.e|
0060 00 74 00 65 00 72 00 20-00 27 00 40 00 73 00 74 |.t.e.r. .'.@.s.t|
0070 00 61 00 72 00 74 00 54-00 69 00 6d 00 65 00 27 |.a.r.t.T .i.m.e.'|
0080 00 2c 00 20 00 77 00 68-00 69 00 63 00 68 00 20 |.,. .w.h .i.c.h. |
0090 00 77 00 61 00 73 00 20-00 6e 00 6f 00 74 00 20 |.w.a.s. .n.o.t. |
00a0 00 73 00 75 00 70 00 70-00 6c 00 69 00 65 00 64 |.s.u.p.p .l.i.e.d|
00b0 00 2e 00 07 43 00 45 00-4e 00 54 00 41 00 55 00 |....C.E. N.T.A.U.|
00c0 52 00 10 72 00 65 00 70-00 6f 00 72 00 74 00 4c |R..r.e.p .o.r.t.L|
00d0 00 61 00 73 00 74 00 41-00 63 00 63 00 65 00 73 |.a.s.t.A .c.c.e.s|
00e0 00 73 00 00 00 fe 02 00-e0 00 00 00 00 00 |.s...\uffff.. \uffff.....|


12:38:09.007328 dbsqlok() marker is aa
12:38:09.007343 processing result tokens. marker is aa(ERROR)
12:38:09.007360 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 168 from wire to give 84 to client.
tds_get_string: reading 14 from wire to give 7 to client.
tds_get_string: reading 32 from wire to give 16 to client.
12:38:09.007561 tds_client_msg: #20018: "General SQL Server error: Check messages from the SQL Server.". Connection state is now 0.
12:38:09.007585 processing result tokens. marker is fe(DONEPROC)
12:38:09.007602 tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
12:38:09.007621 tds_process_end() state set to TDS_IDLE
12:38:09.007636 dbsqlok() end status was error
12:38:09.007766 tds_process_row_tokens() state is COMPLETED
12:38:09.007785 dbresults()
12:38:09.007799 dbresults_r()
12:38:09.007814 tds_process_result_tokens() state is COMPLETED
12:38:09.007829 leaving dbresults() returning 1
12:38:09.007845 tds_process_row_tokens() state is COMPLETED
12:38:09.007872 dbresults()
12:38:09.007886 dbresults_r()
12:38:09.007901 tds_process_result_tokens() state is COMPLETED
12:38:09.007916 leaving dbresults() returning 2
12:38:09.008267 in dbfreebuf()
nd()









Archive powered by MHonArc 2.6.24.

Top of Page