Could you show the code that execute this sql query?
> -----Original Message----- > From: Zento [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 02, 2008 12:02 > To: firebird-net-provider@lists.sourceforge.net > Subject: [Firebird-net-provider] Problems with parametrized queries (DDEX > VS2008) > > > 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 ------------------------------------------------------------------------- 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
