Subject | Re: [firebird-support] ODBC Requirements |
---|---|
Author | Richard Thomas |
Post date | 2006-04-28T13:10:52Z |
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
Services.
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 O
DBC 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.
Does anyone know what I'm talking about or do you have any ideas or
comments about the message or connection technique?
Rick USA
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
Services.
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 O
DBC 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.
Does anyone know what I'm talking about or do you have any ideas or
comments about the message or connection technique?
Rick USA