Subject Re: [firebird-support] ODBC Requirements
Author Helen Borrie
Rick,

At 11:10 PM 28/04/2006, you wrote:
> Hi All:
>Testing my ODBC32 / Firebird interface I'm having problems connecting:
>Below is an abstract of the current error:
>FbConnect Program Entry:
>OpenDataBase Proc Entered
>Connect String:
>Driver={Firebird/InterBase(r) driver}; SERVER=localhost;
>
>DBNAME="localhost:c:\Program
>Files\Firebird\Firebird_1_5\examples\EMPLOYEE.FDB"; USER=SYSDBA;
>
>PASSWORD=masterkey
>SQLAllocHandle Successful
>SQLDriverConnect Not Successful
>ret = 65535
>ODBC Error: SQLState Code: 08004
>Native Error: 0
>
>Unable to complete
>
>network request to host ""localhost".
>Failed to locate host machine.
>The specified name was not found in the hosts file or Domain Name

This may or may not be due in part to your not having localhost
defined in your Hosts file. ( $windir$\system32\drivers\etc\hosts)

You need:
127.0.0.1 localhost


>Rick: note the quote mark before the server ID I used in the DataBase
>name of localhost, in the Connect String as appearing in the
>ODBC Error Message. it has a double quote in the name. I use the
>double quotes because of the space in the Windows "Program Files"
>directory name, that's how it worked under ISQL. There is a short name
>for this directory entry I can use to eliminate the space in the DB
>Path but I've not found it yet googling around.

localhost:c:\Progr~01\Firebird\Firebird_1_5\examples\EMPLOYEE.FDB

>Does anyone know what I'm talking about or do you have any ideas or
>comments about the message or connection technique?

I suspect you might be running the command.com command shell, not
cmd.exe. What is your Windows version?

But for ODBC connection problems you ask on the firebird-odbc-devel
list, to which I note you are subscribed.

./heLen