FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Costel,

Question: what is wrong??

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 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.  .'.@.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/ 
--------------------------------------------------------