||Re: How to use a Dbase app on two geographically diverse locations
Akshat Kapoor <firstname.lastname@example.org>
||Sat, 13 Jan 2018 11:22:41 +0530
On 13/01/2018 00:30, Ronnie MacGregor wrote:
> In article <t6yAXS9iTHA.1828@ip-AC1E04A7>, email@example.com says...
> From the above line I can see that your server name or machine name is :
>> 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