Hello:
> I have some remarks & questions concerning the use of Fb .NET Provider.
>
> 1) I have installed both Provider and DDEX, so I can browse FB
> databases through the Server Explorer in Visual Studio 2005. When
> registering an FB database in the Server Explorer I specify either
> 'localhost' or the network name of my computer as Data Source; in both
> cases when I press Test Connection I see 'Test connection succeeded'.
> That's fine.
>
> But when I add an FbConnection component to my project and try to
> configure it the situation is quite different: pressing Test
> Connection always leads to 'Unable to complete network request to
> 'localhost'/[my computer network name]'. Anyway, if I accept the given
> parameters and run the application, FbConnection.Open works properly.
Huummm i will try to check it today.
Hace you checked if the new .NET 2.0 TableAdapters can fit your needs ??
> this.fbCommand1.CommandText = "\"Category_I\"";
> this.fbCommand1.CommandType = System.Data.CommandType.StoredProcedure;
> this.fbCommand1.Connection = this.fbConnection1 ;
> this.fbCommand1.Parameters.Add(new
> FirebirdSql.Data.Firebird.FbParameter("Name",
> FirebirdSql.Data.Firebird.FbDbType.VarChar, 50));
> this.fbCommand1.Parameters.Add(new
> FirebirdSql.Data.Firebird.FbParameter ("Sign",
> FirebirdSql.Data.Firebird.FbDbType.SmallInt));
>
> fbCommand1.Parameters["Name"].Value = "some text";
> fbCommand1.Parameters["Sign"].Value = -1;
>
> fbCommand1.ExecuteNonQuery ();
>
> but I get this exception:
>
Try using:
this.fbCommand1.Parameters.Add(new
FirebirdSql.Data.Firebird.FbParameter("@Name",
FirebirdSql.Data.Firebird.FbDbType.VarChar, 50));
this.fbCommand1.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter
("@Sign", FirebirdSql.Data.Firebird.FbDbType.SmallInt));
--
Carlos Guzmán Álvarez
Vigo-Spain
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
