Subject Help IBObjects, Delphi & Local Interbase
Author David Husarik
Hi Group,

I am attempting to connect to Interbase version
WI-V6.0.1.0 on a peer-to-peer network with a Delphi 4
Professional application using IBObjects version
3.6Cd. I know what the standard line from Borland is,
"Use NT Server..." unfortunately I do not have that
option. Interbase was installed using the install.exe
provided by Borland on a Windows 95 machine.

I found instructions for configuring TCP/IP for
Windows 95 on ibPhoenix.com Knowledge Base ID # 84.
The last line says "The Communication Diagnostics
utility can now be used to test Winsock connections,
and DB connections using TCP/IP." The results are
listed below my questions.

First, is it possible to have a Delphi app on one
machine talk to an Interbase database located on a
second machine in a peer to peer network situation.

I get the following error message when I run the
Delphi app.

Project w2reader.exe raised exception class
EIB_ISCError with message ISC_ERROR Code 335544721

ISC ERROR Message:
Unable to complete network request to host
"0008c73a385c"
Failed to establish a connection
Network access is denied
process stopped use step or run to continue.

In the delphi app, do I need to establish a TCP/IP
connection, and if I do need this how do I do it. Do I
need to do a WNetAddConnection2 and if so how do I use
the return information with the TIB_Connection
component.


This is the result of the communication diagnostics
utility.
TCP/IP Tab:

Server Information: Host: 008c73a385c Service: 21
Results:
Attempting connection to 0008c73a385c.
Socket for connection obtained.
Found service 'FTP' at port '21'
Connection established to host '0008c73a385c',on port
21.
TCP/IP Communication Test Passed!

Server Information: Host: 008c73a385c Service: ftp
Results:
Attempting connection to 0008c73a385c.
Socket for connection obtained.
Connection established to host '0008c73a385c',on port
ftp.
TCP/IP Communication Test Passed!

Server Information: Host: 008c73a385c Service: 3050
Results:
Attempting connection to 0008c73a385c.
Socket for connection obtained.
Found service 'GDS_DB' at port '3050'
Connection established to host '0008c73a385c',on port
3050.
TCP/IP Communication Test Passed!

Server Information: Host: 008c73a385c Service: gds_db
Results:
Attempting connection to 0008c73a385c.
Socket for connection obtained.
Connection established to host '0008c73a385c',on port
gds_db.
TCP/IP Communication Test Passed!

Server Information: Host: 008c73a385c Service: ping
Results:
Pinging 0008c73a385c [10.254.28.82] with 32 bytes of
data:
Reply from 10.254.28.82: bytes=32 time=1ms TTL=128
Reply from 10.254.28.82: bytes=32 time=0ms TTL=128
Reply from 10.254.28.82: bytes=32 time=0ms TTL=128
Reply from 10.254.28.82: bytes=32 time=1ms TTL=128
Ping statistics for 10.254.28.82: Packets: Send = 4,
Received = 4, Lost = 0 (0%),
Approximate round trip times in milli-seconds: Minimum
= 0ms, Maximum = 1ms, Average = 0ms

DB Connection Tab

Server Information:
Remote Server: selected
Server Name: 0008c73a385c
Network Protocol: TCP/IP

Database Information:
Database :
\\0008c73a385c\processor\c:\ib_db\w2\W2-TAX-1999.gdb
User Name: SYSDBA
Password: masterkey

Results:
An InterBase error has occurred while attaching.
Error - Unable to complete network request to host
".".
Failed to establish a connection.
An unexpected network error occurred.
InterBase Communication Test Failed!

2nd attempt:

Server Information:
Remote Server: selected
Server Name: 0008c73a385c
Network Protocol: TCP/IP

Database Information:
Database : J:\ib_db\w2\W2-TAX-1999.gdb
User Name: SYSDBA
Password: masterkey

Results:
An InterBase error has occurred while attaching.
Error - Unable to complete network request to host
"j".
Failed to locate host machine.
The specified name was not found in the hosts file or
Domain Name Services
InterBase Communication Test Failed!

Entry from hosts file: 10.254.28.82 0008c73a385c
Entry from Domain Name Services: 0008c73ac00d,
DOR.STATE.MA.US, 10.254.28.75, 10.254.32.75


Thanks in advance,
David Husarik


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/