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 11:22:41 +0530
Newsgroups dbase.getting-started

On 13/01/2018 00:30, Ronnie MacGregor wrote:
> In article <t6yAXS9iTHA.1828@ip-AC1E04A7>, akshat.kapoor@kapoorsons.in says...
>
>> \\Windows-2l0igcp\c\dbasetutorial\muneem\
>
>  From the above line I can see that your server name or machine name is :
>
> Windows-2l0igcp
>
>
>> 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")
>
> Of course these will fail.
>
> The constant "localhost" equates to 127.0.0.1 which is basically a loopback
> connector to the machine that you are working on.
>
> So using localhost or 127.0.0.1 or the local machine name, may all very well
> work on the stand alone machine in front of you, but it isn't going to work for
> any remote machine.
>
> dbServer = "192.168.1.103"
>
> This might very well work, but the IP address is more likely to change than the
> machine name.
>
> dbServer = "Windows-2l0igcp"
>
> Try this one . . . . . and you stand a better chance !!

dbServer = "WINDOWS-2L0IGCP"

Error:  OLE Dispatch Exception:  [MySQL][ODBC 3.51 Driver]Host
'WINDOWS-A4C8QK3' is not allowed to connect to this MariaDB server

It seems the SQL server has been located but there is a rights issue
Regards
Akshat