At 10:05 a.m. 19/09/2013, Craig Fogg wrote:
>Friends,
>
>I have a database installed on a central computer
>(not running a server OS)
What does that mean, exactly?
>that I am trying to connect to two clients.
Clients connect to databases, not the other way around. And remote clients do
so *only* through a running Firebird server.
>The database folder is
>shared on the network as L:\database\
Firebird is not a file-served system so this (purposely) will not work.
>All PC's are running Windows 7.
>For one client simply connecting to L:\Database|{dbname} in the ODBC
>configuration worked fine.
Check that one again. There's no reason it should work.
>For the other, I cannot connect no matter
>what string I use. Following the Help documentation I have tried all
>combinations suggested. But each time I cannot connect. Both client PC's
>are running the same, newly updated 2.0.2.153 ODBC Driver. Any
>suggestions??
The connection string is hostname:D:\path\to\database_file, where "D:" MUST BE
the actual drive letter of a drive that is under the control of the machine
that is running the Firebird server. Better, use an alias for the
"D:\path\to\database_file" segment.
That's TCP/IP protocol. You could alternatively use Named Pipes protocol with
a string like
\\hostname\D:\path\to\database_file
Although valid, it is deprecated and is a noisy protocol.
>Why did L:{etc} work when this not documented as a valid
>connect string/method? Something hiding in the code we don't know about?
It's not valid and it would be astonishing if it actually does work. But if it
really does then stop right now, as working with a database in any location
that isn't under the control of Firebird's hosts is kamikaze. (With a setting
in firebird.conf, you can do it on some non-Windoze platforms, at your peril.)
Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
