#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2010
    Posts
    2
    Rep Power
    0

    FB embed server and network drive


    Hello all,
    I'm using Firebird SQL embed database. On the local disk it works very well. I tried to copy the database file (something.fdb) to the network drive and the client shows the error message "Unable to complete network request to host fsgt. Failed to establish the connection." The connection string was: database=H:/my_projects/something.fdb.
    I tried to change the connection string: database=\\192.168.0.2\user/my_projects/something.fdb. The IP adress 192.168.0.2 is the adress of the file server. But it was without any result.
    The client runs on Windows XP SP3, in the Windows firewall I allowed the port 3050.
    The server runs on Linux and the port 3050 is usually not used. Between the server and the client there is Samba.

    What is wrong?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2010
    Posts
    52
    Rep Power
    5
    Ive never been successful at connecting to a database file that is not on the same computer as the firebird server, so ive always assumed its not possible.

    But I do know that if your on a different computer from the server, you still write your connection file path as if you are on the server not the path from the client to the file.

    For example, trying to use database workbench to open a database on the server from a client, you state the server is 192.168.0.2 or whatever, and then you say the path is E:/db/file.fdb not \\sharepath\db\file.fdb (or whatever), even though that E:/db doesn't exist on the client , its still the path on the server to it.

    Also i would imagine, that even if it is possible and i just havnet figured it out yet, having firebird trying read a db file over a network would be realllly slow, compared to reading it from a hard drive on the same machine.

    Reading a db file on the same hard drive that firebird is running on isnt even the best way, having 3 separate hard drives (on the same computer) for the database, the temp files, and the system is the best.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    205
    Rep Power
    15
    the connection string might be wrong:

    check if you have connection from workstation to the server (at command prompt type: telnet <server_address_or_hostname> 3050

    if it says there's no connection to host, they rule out network problems first.


    i usually use aliases in the /etc/firebird/aliases.conf file, like:

    mydb = /data/db/blabla.fdb


    and i my connection string looks like: connstr='192.168.0.100:mydb' , where 192.168.0.100 is my server's address

    there are no \\ because this is a firebird protocoll connection not an SMB.


    not using aliases then the connection string will be:

    connstr='192.168.0.100:/data/db/blabla.fdb'

    Important to take care of that the firebird user on the server to have read/write access on the /data/db/blabla.fdb file.
    Last edited by nagysz; September 18th, 2010 at 04:38 AM.
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2010
    Posts
    2
    Rep Power
    0
    Thank for the replies.
    I connected two computers direct with a network cable. The OS of the computers was MS Windows, the antivirus and the firewall on the computers were disabled. I put the database.fdb into a shared folder and tried to connect from the other computer. But it didn't work.
    So I will create an application, which will copy the DB file from the network drive to the HDD, run the DB client program and after closing the client program copy the DB file back to the network drive
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2009
    Posts
    37
    Rep Power
    6
    Originally Posted by SimyV
    So I will create an application, which will copy the DB file from the network drive to the HDD, run the DB client program and after closing the client program copy the DB file back to the network drive
    Bad idea

    Try

    networkcomputername:\sharename\databasename.fdb
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,057
    Rep Power
    383
    Why are you using the embedded server when the file is on another computer?
    IMO - a bad. idea.

    Just use the regular FB server on the remote machine and move on.
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    205
    Rep Power
    15
    looooool you sounded like my little brother. He also has an idea for everything....now matter how inefficient it is )))
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,057
    Rep Power
    383
    Originally Posted by nagysz
    looooool you sounded like my little brother. He also has an idea for everything....now matter how inefficient it is )))
    Which post sounded like your little brother?
    Which idea do you consider inefficient?
    Without this information I am not sure what your post illuminates.
  16. #9
  17. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    205
    Rep Power
    15
    Originally Posted by clivew
    Which post sounded like your little brother?
    Which idea do you consider inefficient?
    Without this information I am not sure what your post illuminates.
    scuzi! it was a reply to SimyV to this one:

    Thank for the replies.
    I connected two computers direct with a network cable. The OS of the computers was MS Windows, the antivirus and the firewall on the computers were disabled. I put the database.fdb into a shared folder and tried to connect from the other computer. But it didn't work.
    So I will create an application, which will copy the DB file from the network drive to the HDD, run the DB client program and after closing the client program copy the DB file back to the network drive

    Comments on this post

    • clivew agrees : Then I have to agree!

IMN logo majestic logo threadwatch logo seochat tools logo