Subject Re: How to use a Dbase app on two geographically diverse locations From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Sat, 13 Jan 2018 00:08:48 +0530 Newsgroups dbase.getting-started Attachment(s) test_odbc2.prg On 10/01/2018 00:10, Ronnie MacGregor wrote: > In article <OvQyscIiTHA.904@ip-AC1E04A7>, akshat.kapoor@kapoorsons.in says... > >> dbServer = "localhost" >> //how to specify this server from a client computer. Is it UNC path or >> //IP address. > > If the server is on the local network, you simply use the machine name here. > Sorry to be back with more questions but this is one issue to which I have not been successful in finding an answer. With localhost I was successful in creating a connection using ADO also, (Have been unable to understand all the components of the different connection strings but still have a working form with a grid / working datamodule and will be able to repeat the connection successfully ) but failed to access the same data over LAN. I have attached my test_odbc2.prg for reference only. \\Windows-2l0igcp\c\dbasetutorial\muneem\         unc path working correctly for accessing files over LAN using OODML //192.168.1.103/check_php.php                 this is also working in chrome hence both are correct but failed with all of the following lines dbServer = "//192.168.1.103/localhost" dbServer = upper("192.168.1.103\localhost") dbServer = upper("\\Windows-2l0igcp\localhost") None seem to be working. Can proceed with further testing after running a successful test connection only. Regards Akshat