Subject Undefined service in ODBC application
Author nocsav
Hello,

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?

Thanks very much!

David