Failed to locate host machine

[Daniele Barzotti]

Hi,

I don't know why but after I have installed Apache, Php and Ruby on my
PC, when I try to connect to Firebird database from my VB6 application
the driver return me the error:

[ODBC Firebird Driver]
Unable to complete network request to host "127.0.0.1".
Failed to locate host machine.
Undefined service 3050/tcp.

I'm using FB v2.0.3 and ODBC v2.00.00.144

Where is the mistake?

Thanks in advance.
Daniele.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Andrea Chiado Piat]

Daniele Barzotti ha scritto:

> Hi,
>
> I don't know why but after I have installed Apache, Php and Ruby on my
> PC, when I try to connect to Firebird database from my VB6 application
> the driver return me the error:
>
> [ODBC Firebird Driver]
> Unable to complete network request to host "127.0.0.1".
> Failed to locate host machine.
> Undefined service 3050/tcp.
>
> I'm using FB v2.0.3 and ODBC v2.00.00.144
>
> Where is the mistake?
>
> Thanks in advance.
> Daniele.

Try to check for a modified value in
C:\WINDOWS\system32\drivers\etc\services file.
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Jorge Andrés Brugger]

Test from control panel dsn dialog is ok?

Daniele Barzotti escribió:

> Hi,
>
> I don't know why but after I have installed Apache, Php and Ruby on my
> PC, when I try to connect to Firebird database from my VB6 application
> the driver return me the error:
>
> [ODBC Firebird Driver]
> Unable to complete network request to host "127.0.0.1".
> Failed to locate host machine.
> Undefined service 3050/tcp.
>
> I'm using FB v2.0.3 and ODBC v2.00.00.144
>
> Where is the mistake?
>
> Thanks in advance.
> Daniele.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Firebird-odbc-devel@...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
>  

--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono [phone] int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Daniele Barzotti]

Andrea Chiado Piat ha scritto:

>>
>> [ODBC Firebird Driver]
>> Unable to complete network request to host "127.0.0.1".
>> Failed to locate host machine.
>> Undefined service 3050/tcp.
>>
>> I'm using FB v2.0.3 and ODBC v2.00.00.144
>
> Try to check for a modified value in
> C:\WINDOWS\system32\drivers\etc\services file.
> Andrea
>

Dear Andrea..

I've added the following line into my services file:

gds_db  3050/tcp  fb  #Firebird

But the problem persist!
Any suggestion?

Thanks in advance!
Daniele.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Paul Reeves-2]

On Friday 15 February 2008, Daniele Barzotti wrote:
>
> But the problem persist!
> Any suggestion?
>

I'd see if you can get a connection from the command line using the isql
tool. If isql can't connect what error does it give?


Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Daniele Barzotti]

Paul Reeves ha scritto:

> On Friday 15 February 2008, Daniele Barzotti wrote:
>> But the problem persist!
>> Any suggestion?
>>
>
> I'd see if you can get a connection from the command line using the isql
> tool. If isql can't connect what error does it give?
>
>
> Paul

Dear Paul,

I've added this line to my services file:

gds_db   3050/tcp   fbserver   #Firebird

Then, if I use this connection string (without specify a port number) it
work:

"DRIVER=Firebird/InterBase(r) driver;UID=MyUser;UID=MyPwd;
DBNAME=127.0.0.1:C:\path\to\my\database\MyDB.fdb"

If I insert the port number:

"DRIVER=Firebird/InterBase(r) driver;UID=MyUser;UID=MyPwd;
DBNAME=127.0.0.1/3050:C:\path\to\my\database\MyDB.fdb"

I receive the "Undefined service 3050/tcp" error.

 From isql I can get a connection correctly also specifying a port!

I don't know why!

Thanks in advance!
Daniele.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Paul Reeves-2]

On Friday 15 February 2008, Daniele Barzotti wrote:

> If I insert the port number:
>
> "DRIVER=Firebird/InterBase(r) driver;UID=MyUser;UID=MyPwd;
> DBNAME=127.0.0.1/3050:C:\path\to\my\database\MyDB.fdb"
>
> I receive the "Undefined service 3050/tcp" error.
>
>  From isql I can get a connection correctly also specifying a port!
>
> I don't know why!
>

Interesting. I would guess that the odbc driver is incorrectly parsing
the URL, but it would be necessary to check the source to verify this.

For the time being you will have to connect without specifying a port
number.


Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Andrea Chiado Piat]

Daniele Barzotti ha scritto:
[CUT]
> "DRIVER=Firebird/InterBase(r) driver;UID=MyUser;UID=MyPwd;
> DBNAME=127.0.0.1/3050:C:\path\to\my\database\MyDB.fdb"

Your string in exactly this?
If so check for password: you have to write PWD and not UID

Bye
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Daniele Barzotti]

Jorge Andrés Brugger ha scritto:
> Test from control panel dsn dialog is ok?
>

Yes, from CP the "Test Connection" works correctly!

Regards,
Daniele.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel