[freetds] problem
Costel Cotae
costel.cotae at dobrogeagrup.ro
Fri Feb 4 05:42:36 EST 2005
Thompson, Bill D (London) wrote:
>Costel,
>
>Question: what is wrong??
>
>
>
the problem is that i pass all parameter to the procedure but is
returning me :
mssql_execute(): message: Procedure 'reportLastAccess' expects parameter
'@startTime', which...
i'll try the latest version off freetds
tnx
>Answer: i`m using freetds-0.62.1-1
>
>the stored procedure API's in dblibrary were not that well developed in
>your freetds version.
>
>If possible, please build and test on the latest release candidate:
>
>freetds-0.63RC9.tar.gz ftp://ftp.ibiblio.org/pub/linux/ALPHA/freetds/stable/in
>ftp://ftp.ibiblio.org/pub/linux/ALPHA/freetds/stable/
>
>Bill
>
>
>
>-----Original Message-----
>From: freetds-bounces at lists.ibiblio.org
>[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Costel Cotae
>Sent: 04 February 2005 09:56
>To: FreeTDS Development Group
>Subject: [freetds] problem
>
>
>hi when i try u pass parameters to $proc is returning me
>
>mssql_execute(): message: Procedure 'reportLastAccess' expects parameter
>
>'@startTime', which...
>
>
>
>there is the code
>--
>$msconnect = mssql_connect("MyServer70","sa","");
>mssql_select_db("[Pro-Report]", $msconnect);
>
>$proc = mssql_init("reportLastAccess",$msconnect);
>
>$startTime = "02/04/2005 00:00:00";
>$endTime = "02/04/2005 23:59:59";
>$siteID = 0;
>$reportID = 0;
>$nameStyle = 0;
>$langID = 0;
>$tableID = 0;
>$evSiteID = 2;
>$reportType = 0;
>
>mssql_bind($proc,"@startTime",$startTime,SQLVARCHAR,TRUE);
>mssql_bind($proc,"@endTime",$endTime,SQLVARCHAR,TRUE);
>mssql_bind($proc,"@siteID",$siteID,SQLVARCHAR);
>mssql_bind($proc,"@reportID",$reportID,SQLVARCHAR);
>mssql_bind($proc,"@nameStyle",$nameStyle,SQLVARCHAR);
>mssql_bind($proc,"@langID",$langID,SQLVARCHAR);
>mssql_bind($proc,"@tableID",$tableID,SQLVARCHAR);
>mssql_bind($proc,"@evSiteID",$evSiteID,SQLVARCHAR);
>mssql_bind($proc,"@reportType",$reportType,SQLVARCHAR);
>
>mssql_execute($proc);
>mssql_free_statement($proc);
>--
>
>what is wrong??
>
>i`m using
>freetds-0.62.1-1
>
>there is a dump from .log
>
>11:50:21.494570 tds_process_end() state set to TDS_IDLE
>11:50:21.494586 dbsqlok() end status was success
>11:50:21.494601 dbresults()
>11:50:21.494614 dbresults_r()
>11:50:21.494629 tds_process_result_tokens() state is COMPLETED
>11:50:21.494644 leaving dbresults() returning 1
>11:50:21.494660 tds_process_row_tokens() state is COMPLETED
>11:50:21.494687 dbrpcinit() added rpcname "reportLastAccess"
>11:50:21.494735 dbrpcparam() added parameter "@startTime"
>11:50:21.494758 dbrpcparam() added parameter "@endTime"
>11:50:21.494782 dbrpcparam() added parameter "@siteID"
>11:50:21.494805 dbrpcparam() added parameter "@reportID"
>11:50:21.494828 dbrpcparam() added parameter "@nameStyle"
>11:50:21.494850 dbrpcparam() added parameter "@langID"
>11:50:21.494873 dbrpcparam() added parameter "@tableID"
>11:50:21.494896 dbrpcparam() added parameter "@evSiteID"
>11:50:21.494919 dbrpcparam() added parameter "@reportType"
>11:50:21.494937 dbrpcsend()
>Sending packet @ 11:50:21.494964
>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...|
>
>
>11:50:21.495039 in dbsqlok()
>Received header @ 11:50:21.495500
>0000 04 01 00 f6 00 00 00 00- |...\uffff....|
>
>
>Received packet @ 11:50:21.495550
>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. .'. at .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.....|
>
>
>11:50:21.495684 dbsqlok() marker is aa
>11:50:21.495700 processing result tokens. marker is aa(ERROR)
>11:50:21.495716 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.
>11:50:21.495880 tds_client_msg: #20018: "General SQL Server error: Check
>
>messages from the SQL Server.". Connection state is now 0.
>11:50:21.495905 processing result tokens. marker is fe(DONEPROC)
>
>
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>--------------------------------------------------------
>
>If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
>--------------------------------------------------------
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
More information about the FreeTDS
mailing list