Hi Walter, On 30/05/13 12:20, Walter wrote: > I had to use a Windows 7 machine as Firebird server...after updating firewall > rules everything is ok, but Firebird seems to ignore the aliases.conf > file...I place the fdb file in a shared folder, with full access granted to > everyone, and create the alias. I can access the database locally providing > the full path, by if I try to use the alias I got this error: > > Unsuccessful execution caused by a system error that precludes successful > execution of subsequent statements. > I/O error during "CreateFile (open)" operation for file "XFILES". > Error while trying to open file. > > any clues ?
Q1. What is the exact path where the database file lives? Copy it from Explorer if possible as opposed to typing it directly into the email. Q2. What do yo have in your aliases.conf for this database? I have noticed that, with employee, for example, you get two aliases created within the file: employee = /full/path/to/employee.fdb employee.fdb = /full/path/to/employee.fdb So you can connect to employee or employee.fdb and get to the same database. You can, as you know, also connect to the full path as well. Q3. Are you connecting locally (on the database server) or remotely? If locally, then the alias.conf should simply be as above, the path to the database. if remotely, then your own aliases.conf (assuming that exists in a client only install - I've never done one!) will need to have the server name as well: employee = win7_server:employee employee.fdb = win7_server:employee In this case, your local employee aliases connect to the server and use the server's employee alias. The above (colon separator) assumes TCP protocol. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767
