Hello Bill, > Used IB 10 years ago. Porting an SQL Anywhere app to FB 2.5. Going well > until I try to connect a client to the database - "database unavailable." I > have shared the DB folder on my Windows 7 machine, can browse to it from a > client machine (Win 10) and see Full Control permissions.
Don't put your database into a shared folder. The clients must not have direct physical access to the database file, because they can play around taking physical copies then, worst case corrupting the database. Only the Firebird process needs physical access to the database file locally. Clients need to use a TCP/IP connect string then, e.g. myhost:c:\data\database.fdb, where c:\data\database.fdb is the location on the machine running the Firebird process. Or even better, use database aliases, configurable in a Firebird configuration file called 'aliases.conf', which allows you to define a mapping from a custom name to a physical location. E.g.: mydb = c:\data\database.fdb The custom name 'mydb' should then be used in the connect string, e.g. with myhost:mydb Hope this helps. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. I have disabled > my Trend AV on the Win7 server as well as put incoming and outgoing rules in > the firewall for FBserver.exe. > > > > I am using the ODBC client to connect via ADO which works fine on the Win7 > server. I've run out of things to try. Any suggestion would be greatly > appreciated. > > > > Thanks, > > > > Bill Skelton > > > > Landmark Data Systems, Inc. > > 2 Old River Place, Ste L > > Jackson, MS 39202 > > 601-362-0303 > > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > Posted by: "Bill Skelton" <[email protected]> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > >
