Subject Re: [firebird-support] Undefined service in ODBC application
Author Martijn Tonies
Hi,

> My company embeds Firebird in its product. One of our users is having
> a process communication problem, and I am not sure what's going on.
>
> Platform/environment
> Firebird 1.5.1
> Windows 2000
>
> Our application is developed in C++ and uses both ODBC and the
> Firebird services API.
>
> The user gets the following error from SQLDriverConnect:
>
> Failed to open data source
> Unable to complete network request to host "127.0.0.1".
> Failed to locate host machine.
> Undefined service 1233/tcp.
> SQL error code=0, SQL state: 08004
>
> The database name in the ODBC connect string looks something like
> this:
>
> DBNAME=127.0.0.1/1233:C:\TEMP\SOMETHING.GDB
>
> I'm confused about how this can happen. My understanding is that
> "undefined service" error happens when you try to use a service name
> defined in the services file.
>
> In our case, we specified a particular port number(1233). So I would
> expect fbclient to skip the service lookup and connect.
>
> Another strange thing: Despite our problems with ODBC, our application
> seems able to communicate with fbserver using the services API.
>
> Any thoughts?

Has InterBase 7 been installed on that machine?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com