Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Firebird SQL Development
Reload this Page

Error Connecting Remote Database Server

Discuss Error Connecting Remote Database Server in the Firebird SQL Development forum on Dev Shed.
Error Connecting Remote Database Server Firebird SQL Development forum discussing administration, Firebird SQL syntax, or other Firebird SQL-related topics. Firebird is the evolution of Borland's Interbase product.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 5th, 2004, 05:25 AM
Sanket_devshed Sanket_devshed is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Posts: 7 Sanket_devshed User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy Error Connecting Remote Database Server
Hello All,

I am getting this error while connecting to remote database.

Version :- V1.5.1
Client :- WinXP
Server :- WinXP

SQL> CONNECT MyServer:3050/E:/DATABASE/JIM.gdb
USER SYSDBA PASSWORD masterkey;

Statement failed, SQLCODE = -902

Unable to complete network request to host "MyServer".
-Failed to establish a connection.
-No connection could be made because the target machine actively refused it.

I have Checked the Following Things
1) Required Guardian and Server Services are running on both the machines.
2) The Path Specified is Correct.
3) I tried the same thing by mapping Network Drive ... but same error occurs.

Please Help !!!
- Sanket
Reply With Quote
  #2  
Old October 5th, 2004, 05:53 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,925 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 20 h 9 m 23 sec
Reputation Power: 279
Are you shure that the firewall of WinXP is not blocking that port?
See this for an example.
Reply With Quote
  #3  
Old October 5th, 2004, 07:17 AM
Sanket_devshed Sanket_devshed is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Posts: 7 Sanket_devshed User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by pabloj
Are you shure that the firewall of WinXP is not blocking that port?
See this for an example.


yes ... i have checked ... it is not blocked ... that port is open
I went to the Server and issued the following Commad

c:\> NETSTAT -ao

it displayed a pid listening at port 3050.
Also in the Network Settings i have disabled Firewalls.
Still the same Error.
Reply With Quote
  #4  
Old October 5th, 2004, 07:27 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,925 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 20 h 9 m 23 sec
Reputation Power: 279
Are you shure that Firebird is not boud to a specific IP address in firebird.conf
Quote:
...
# Allows incoming connections to be bound to the IP address of a
# specific network card. It enables rejection of incoming connections
# through any other network interface except this one. By default,
# connections from any available network interface are allowed.
#
# Type: string
#
#RemoteBindAddress =
...
Reply With Quote
  #5  
Old October 6th, 2004, 05:34 AM
Sanket_devshed Sanket_devshed is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Posts: 7 Sanket_devshed User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by pabloj
Are you shure that the firewall of WinXP is not blocking that port?
See this for an example.


It works in a WinXP Client and Win2K Server Mode.

So there is definitely some thing which is not allowing to connect firebird on XP server.
I have disabled the firewalls, but still the same problem.
My Firebird Server is running as a Win XP "Service".

I was able to connect on Win2k Server without specifying the port...

SQL> CONNECT MyServer:d:/Firebird_1_5/examples/Employee.fdb user SYSDBA password
masterkey;

Database: MyServer:d:/Firebird_1_5/examples/Employee.fdb, User: SYSDBA

How to check whether firewall's are disabled on XP ?
Reply With Quote
  #6  
Old October 6th, 2004, 05:46 AM
Sanket_devshed Sanket_devshed is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Posts: 7 Sanket_devshed User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by pabloj
Are you shure that Firebird is not boud to a specific IP address in firebird.conf


Yes ... it is not bound to a particular IP.

<Entry from My Server's firebird.conf File>
# Type: string
#
#RemoteBindAddress =

One more thing ...
It is also Accepting Connections from Win2k Client.

The problem is only with XP -> XP communication.

- Sanket
Reply With Quote
  #7  
Old December 8th, 2004, 09:25 AM
ipaw ipaw is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2004
Location: NS Canada
Posts: 20 ipaw User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 35 m 37 sec
Reputation Power: 0
Cool
Is the fbclient.dll present?
Reply With Quote
  #8  
Old December 11th, 2004, 06:53 AM
upscene upscene is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 223 upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level)upscene User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 7 h 14 m 50 sec
Reputation Power: 8
Your port specification is faulty:

myserver/3050:c:\data\mydb.fb


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server
Upscene Productions
http://www.upscene.com
__________________
Martijn Tonies
Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
Upscene Productions
http://www.upscene.com
Last edited by upscene : December 11th, 2004 at 06:55 AM.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Error Connecting Remote Database Server

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway. 
Stay green...Green IT