I'm looking for a "Step by Step" guide on how to set up a PC as a SqlBase server and access/run application from multi PC.

I have a 5 user license for SqlBase 12.1 and one Team Developer license 7 and windows 10

If possible I need a very detailed guide as I never have been on this side of the IT, only developing applications.

Thanks

Hi,

Glad to see you joined this forum.
As FRBhote wrote, there is a starter.pdf book in you SQLBase documentation folder and all the needed info is there.

Basically, as I wrote on the OpenText forum, you should install the SQLBase server on a PC which will act as a database server.
Install it as a service and on the last page check the "allow external connections" or something like that, this will take care of the windows firewall.

On the client PC's point the sql.ini's serverpath to the network name or ip address of the PC which is acting like a server and you are done.
In your TD folder (or the deploy folder on other PC's)

On PC 1(server) only SqlBase installed as you advice, sql.ini is named sql.ini3 in the att.zip
On PC 2 (client) is installed TD developement and also SqlBase which maybe is the reason for my problem. Sql.ini2 is located under SqlBase drive, Sql.ini1 is located under TD drive.
I have not Deploy on this machine.
I got an undocumented error, but I think this is becuase SqlBase started on PC2 ?????
IP address, I'm not sure where to find it, but run a program https://www.whatismyip.com/ which gave me the settings you see in the different ini files.

Am I close to something???
I have also raised a support question about my SqlBase 5 user which the PMC seems not to be what I should use.

Have a nice day

You do not have the required permissions to view the files attached to this post.

In you sql.ini1 which is your TD sql.ini, there is a public IP address which you probably got from whatsmyip.com.
If you are on the same network, that's wrong, you have to supply the local IP address of the server.

If, on the other hand, you are trying to reach the server over the internet (located somewhere else) that will not work from scratch.
Such a configuration is doable but there are different scenarios...

What I want is to have this PC1 run as a server for my PC2 and at the end for PC3-4 and 5 located elswhere in Norway. On PC2-5 I will install Deploy and RbDeploy and a Sql.ini and the .exe I have created from TD.

I think my understanding of the network and WiFi is where I got stuck.

Ok, to get the IP for your PC1 on WiFi click on the WiFi symbol on the taskbar and choose the properties of your wifi connection.
At the end of the page you will have the IP address you are looking for.

As for the PC3,4 & 5, which are located outside the network your server is on, to access the server, you will need to have either a fixed IP address from your ISP for your router, or you should get a Dynamic DNS address.
Here is a link explaining what Dynamic DNS is: https://www.1and1.com/digitalguide/serv ... namic-dns/

For this to work, you (or someone else) will have to configure the router for port forwarding (port 2155) and DynDNS in case your will be using it.
Also, for such a connection I would make everything secure, encrypt the databases, configure the communication to force SSL and so on.

Ethernet, is that just to hook up a cable in my router, buy a box to extend ports for this new cables, and hook up PC1 and PC2 to this box? PC-3-4-5 will have to do the same, and then we can go down the ethernet way?

If all PC's have access to ethernet, and the abouve is correct as my understanding, is this a better way of going, rather than DNS.

Hopefully I have managed to place a valid quiestion, and that you have understood it.

The one on your TD PC should point to the server.
For now I would deactivate the SQLBase from your TD PC, removing the autostartpath from it, and renaming the sql.ini in the TD\sqlbase folder.
We can bring it back later, but for now let's keep thing simple.
Remember, after you have changed the sql.ini you have to restart the SQLBase server.
Is it installed as a service on PC1?

Must all the PC's be hooked up using a cable from the Router, not wifi anymore?

No, they can work over wifi or fixed cable, it doesn't matter.

kjellv wrote:
To change the sql.ini, is this the only change I have to do, "serverpath=server1,10.0.0.110,2155/*" with the new IP address?

Yes, that is the only change to get it work.

kjellv wrote:
Also, important, will this work for PC3-4-5 if they all are on the same WiFi - (same office) the way it works for me today on PC1 and PC2 ????????

If they are on the same network they will work the same as PC2.

If PC3,4,5 are outside your network, ie. not on the same router, in order for them to reach your PC1 server, you will have to provide them an public IP address.

The address 10.0.0.x (as well as the 192.168.x.x I was writing before) is your private network which cannot be accessed from the outside. It's the address your router DHCP is providing for the devices on your local network, like PC's, tablets, smartphones, etc.

Your router has a public address, it's the one you got with whatsmyip.com, but unless your ISP provides you with a fixed IP address (the one that never change and it's allocated for you) it's a dynamic IP address that changes after some time (usually 24-48 hours or even more, depending on your ISP).
Don't know the prices in your country, but here in Croatia leasing a fixed IP address costs about 5 times more than the dynamic one.

The solution for this is to get a Dynamic DNS account, and tell the router to use it to provide the new IP every time it's changed. One of the services is dyndns which has a small annual fee, or you can use some other free Dynamic DNS services. What they do is that, instead of the ever changing IP address, they provide you a name which you can use to access your router, something like kjellv.is-a-guru.com
So you can use it in your PC3,4,5 sql.ini serverpath: