At 12:58 AM 19/05/2007, you wrote: >I am learning to use Firebird and its .NET provider. > >We have installed Firebird on a separate PC (call it dbserver). > >I am using a separate PC on which I have WinXP and VS2005 installed. > >I am using EMS SQL Manager Lite for Firebird management. > >Using this I have created a dummy database, which has got only one table >in it. > >When ever I try to connect the FB server I get the message that you have >to specify DB location. What is this?
Where, on the physical host machine, the server should look for the database file. >How can I find the location of a database on a remote server? Provide the physical file path to the database file, as seen by the server machine. >If the FB is running on a separate remote machine how can we specify the >location of database? The database is (and must be) a physical file on the server host machine...not a network share, mapped drive, etc.). You can provide this in one of two ways: a) as a verbatim path b) as an alias, referring to a verbatim path you have defined in aliases.conf in Firebird's root directory Preceding the path or alias, you must provide either the node name or the IP address of the host machine. TCP/IP is recommended: Consider a database file named mydata.fdb, located in a machine named fbserver at IP address 10.1.1.99, on partition (or physical disk) D: in a folder named databases. The following connection formats are valid for a TCP/IP connection: fbserver:D:\databases\mydata.fdb 10.1.1.99:D:\databases\mydata.fdb For now, you may also use a proprietary Windows (named pipes~NetBeui) networking connection, as follows: \\fbserver\D:\databases\mydata.fdb This isn't recommended for serious work, however. It is noisy and error-prone and will be dropped in future. >In fact why should we have to specify the location of database? A database server can serve multiple databases and Firebird is client/server software. Clients connect to Firebird databases across heterogeneous networks. Different server platforms have different filesystems and different ways of naming files. So, for example, your client program could connect to the same database running on a Linux server fbserverx, as follows: fbserverx:/databases/mydata.fdb >Such a thing is not necessary in MS SQL Server, where we just have >to give Database Name only and we can access all the tables in the database. But you can't run MS SQL Server anywhere else but on Windows, can you? Firebird servers can run on anything: Linux, HP-X, MacOSX, Solaris, etc., etc. >Can someone enlighten me here. It seems you need to read up on the most basic documentation...starting with the Getting Started guide in your doc folder. You might also like to Google for "Client/server", "cross-platform" and "interoperability" to understand some fundamental concepts of computing as it exists beyond the feathered nest of Microsoft. It would also be useful for you to visit the Lists page at the Firebird website ( http://firebirdsql.org/index.php?op=lists ) to find out which lists are appropriate for the questions you want to ask; and http://firebirdsql.org/index.php?op=doc to search for documentation resources... Helen ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider