Re: [Firebird-net-provider] Connection in a different TCP port

[Jiri C. <di...@ci...>]

On 1/14/08, Adilson Garcia <adi...@ya...> wrote:
> [Database server]
>  - Install firebird 1.5.4 on an machine running windows 2000 or above
>  - Edit file "C:\Windows\System32\Drivers\Etc\Services" and change the po=
rt
> to 7001 of "gds_db"
>  - Open file "Aliases.conf" located on Firebird folder and add an alias f=
or
> an existing database
>  - start Firebird server as Service
>
> [Client - tested on Windows XP]
>  - Edit file "C:\Windows\System32\Drivers\Etc\Services" and change the po=
rt
> to 7001 of "gds_db"
>  - using Visual Studio 2005 import to yout toolbox the Firebird .net Data
> Provider Version 1.7.1 for .NET 1.1
>     - create a new WindowsForms solution and add to your form an button a=
nd
> an fbconnection
>     - Set the connection string property for FBConnection: (don=B4t forge=
t to
> cgange the server ip and database to your alias)
>          "User=3DSYSDBA;Password=3Dmasterkey;Database=3Dyourdatabasealias=
;DataSource=3D192.168.0.1;Dialect=3D3;Charset=3DNONE;Role=3D;Connection
> timeout=3D15;Pooling=3DTrue;Packet Size=3D8192;Server Type=3D0;Port Numbe=
r=3D7001"
>     - Put this line on button click:
>             fbConnection1.Open();
>
>     - Put an breakpoint in this line, run, and click on button, it will s=
top
> right on the Open method, press F10 to move to next line, it will connect=
 to
> the database and move to the next line
>
>     - Now delete the fbConnection form your form,
>     - import to yout toolbox the Firebird .net Data Provider Version
> 2.1..NET 2.0
>     - put an fbconnection, set the connectionstring property to the same
> used last time and run
>     - it will stop right on the Open method, press F10 to move to next li=
ne,
> it will raise an FbException with message "Unable to complete network
> request to host "192.168.0.1"."
>
> Same code, only different provider's version
>
>

I'vetested this, with 2.0.1 version and works perfect. Server was
Win2k3 Std., I've changed services file and using isql and/or small
application from VS works fine. Are you sure, that the problem is in
port?

When you setup FB in default are you able to connect? If not, the
problem is on other site (firewall etc.). If so, you have to specify
more detailed, reproducible test-case and you can report it to the
tracker.

>
>
> ""Jiri Cincura"" <di...@ci...> escreveu na mensagem
> news:d2f...@ma......
> > On 1/14/08, Adilson Garcia <adi...@ya...> wrote:
> >> Yes, I am able!
> >>
> >> Even IBExpert connects
> >
> > Weird. Can you create some (general) test case? Or is this only on
> > your machine (network)?
> >
> > Is this problem still there wheny ou use build from sources (or weekly)=
?
> >
> > --
> > Jiri {x2} Cincura (Microsoft Student Partner)
> > http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
> >
> > -----------------------------------------------------------------------=
--
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/market=
place
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
>
>
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpl=
ace
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


--=20
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com