Subject | Re: [firebird-support] Using Firebird With C# |
---|---|
Author | Fabio Gomes |
Post date | 2006-03-15T17:22:06Z |
Thanx for the quick reply, but i tested this example too:
private void Form1_Load(object sender, EventArgs e) {
string connectionString =
"User=SYSDBA;" +
"Password=masterkey;" +
"Database=/home/trab/SiadPHP/testes/siad.gdb;" +
"DataSource=192.168.15.101;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=ISO8859_1;" +
"Role=;" +
"Connection lifetime=15;" +
"Pooling=true;" +
"MinPoolSize=0;" +
"MaxPoolSize=50;" +
"Packet Size=8192;" +
"ServerType=0";
FbConnection myConnection1 = new FbConnection(connectionString);
myConnection1.Open();
}
But i get the same error.
private void Form1_Load(object sender, EventArgs e) {
string connectionString =
"User=SYSDBA;" +
"Password=masterkey;" +
"Database=/home/trab/SiadPHP/testes/siad.gdb;" +
"DataSource=192.168.15.101;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=ISO8859_1;" +
"Role=;" +
"Connection lifetime=15;" +
"Pooling=true;" +
"MinPoolSize=0;" +
"MaxPoolSize=50;" +
"Packet Size=8192;" +
"ServerType=0";
FbConnection myConnection1 = new FbConnection(connectionString);
myConnection1.Open();
}
But i get the same error.
On 3/15/06, Si Carter <mail.lists@...> wrote:
>
>
>
> > -----Original Message-----
> > Hi guys, i just started using C# and Visual Studio, i use
> > firebird with php and its very simple to work with, but i m
> > having some trouble to make it work with C#.
> >
> > I tried this:
> >
> > private void Form1_Load(object sender, EventArgs e) {
> > string connectionString = "Database=
> > 192.168.15.101:/home/trab/SiadPHP/testes/siad.gdb
> > ;User=SYSDBA;Password=masterkey;Dialect=3;";
> > FbConnection cnn = new FbConnection(connectionString);
> > FbDataAdapter da = new FbDataAdapter("SELECT *
> > FROM RDB$RELATIONS", cnn);
> > DataTable dt = new DataTable("RELATIONS");
> > da.Fill(dt);
> > da.Dispose();
> >
> > dataGrid1.DataSource = dt;
> > }
> >
> > But it gives me this error:
> >
> > "Unable to complete network request to host 192.168.15.101"
>
> Visit (http://www.fbtalk.net/viewtopic.php?id=257)<http://www.fbtalk.net/viewtopic.php?id=257%29>for a base class for use
> with FB.net/C#.
>
> FYI, this is one of my connection strings
>
> User=DNFDB_USER;Password=h6tr3sc7;Database=dnfdb;DataSource=127.0.0.1
> ;Dialec
> t=3;Pooling=false;Connection Lifetime=600;Packet Size=8192
>
> You will notice that the Datasource (server) is an entry by its self.
>
> Hih
>
> Si Carter
> http://www.fbtalk.net/ - Web Based Firebird Forum
> http://sourceforge.net/projects/fbutils - FBUtils
> http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered Forum
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw> Computer
> technical support<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA> Compaq
> computer technical support<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g> Compaq
> technical support<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w> Hewlett
> packard technical support<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA> Microsoft
> technical support<http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "firebird-support<http://groups.yahoo.com/group/firebird-support>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com<firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>
[Non-text portions of this message have been removed]