Title: ICEFLOR S.L.
I tried in the beginning and it worked fine to check that FB driver was correctly installed. The problem is that I need to use a SqlDataSource  component for technical questions. I am using a commercial component and it needs SqlDataSource  as a parameter.

In any case, thank  you




Eduardo Lima wrote:
Try This

FbConnection m_obConexionDB = null;
sConexion = @"ServerType=0;DataSource=xxx.xzz.xxx.xxx;Port=9999;user=SYSDBA;Password=masterkey;" +
                       "Charset=NONE;Packet Size=32767;Fetch Size=100; Database=DBName";
m_obConexionDB = new FbConnection(sConexion);
*****
DataTable datTable = new DataTable();
FbDataAdapter dataAdapter = null;
try
{
    if (obConexionDB.State == ConnectionState.Closed)
        obConexionDB.Open();
    dataAdapter = new FbDataAdapter(sOrdenSQL, m_obConexionDB);
    dataAdapter.Fill(datTable);

    obGrid.DataSource = datTable;
}
catch (FbException obError)
{
    m_iError = obError.Errors[0].Number;
    m_sError = obError.Errors[0].Message;
}

 

-------------------------------------------------------------------------
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

Reply via email to