No subject


Fri May 2 19:13:14 EDT 2003


description is not strictly necessary.  All is really needed
is to retrieve the parameter types from the bound variables,
which means that you have to actually prepare the statement
not at the SQLPrepare call, but at the first SQLExecute.

This is what I understand (by packet sniffing) the MS SQL Server
'official' driver is doing.

Moreover, using the MS driver, if you do not explicitly
bind variables with a type in a DBD::ODBC statement,
[using bind_param], the default type is used, which is,
apparently, varchar(80).  

What I am trying to say is that if we limit ourselves to DBD:ODBC
"compliance", there are relatively little problems.

If, on the other hand,
we want to fully implement SQLDescribeParam, we have to completely
parse the SQL statement, or to accept some limitation on the syntax
which is handled.  In the first hypotesis, I would like to
use an existing SQL parser, because I'm afraid that writing one
from scratch is unreasonable.  In the latter hypotesis,
a consensus must be reached on what the limitations are.

Just some thoughts,
   a.




More information about the FreeTDS mailing list