Hello everybody.
I'm trying to use Firebird as RDBMS for a new ASP.NET web project to test,
as I'm totally new to this technology. I've installed Firebird 2.1.1,
Firebird Client 2.1.0.0 and DDEX 2.0.4.0 and using SqlDataSource with
Firebird bindings. Everything works perfectly for queries like SELECT * FROM
Table, but when I try to use a parametrized query with a join, SqlDataSource
can't retrieve schema:
When using this query:
SELECT UsuDisp.Dispositivos, Usu.IDUsuario, Usu.Usuario, Usu.Nombre
FROM UsuariosDispositivos UsuDisp
LEFT OUTER JOIN Usuarios Usu ON (Usu.IDUsuario = UsuDisp.Usuario)
WHERE UsuDisp.Dispositivos = ?
The "Test Query" button show this error: "SQLDA missing or incorrect
version, or incorrect number/type of variables".
Then tryed through Query Builder, and parameter changed:
SELECT UsuDisp.Dispositivos, Usu.IDUsuario, Usu.Usuario, Usu.Nombre
FROM UsuariosDispositivos UsuDisp LEFT OUTER JOIN
Usuarios Usu ON Usu.IDUsuario = UsuDisp.Usuario
WHERE (UsuDisp.Dispositivos = @Param1)
"Execute Query" button worked correctly, but "Test Query" button show this
error: "Must declare command parameters". Tryed also to fill SelectQuery
property directly, adding a named and typed parameter manually, but same
error showed again.
Same query using Microsoft ODBC provider + Firebird ODBC driver worked
correctly, but I think this is not the better way...
Any thought? Thank you in advance.
--
View this message in context:
http://www.nabble.com/Problems-with-parametrized-queries-%28DDEX-VS2008%29-tp19775726p19775726.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
