Visit Our UNIX and Linux User Community


Access database over internet, help


 
Thread Tools Search this Thread
Special Forums IP Networking Access database over internet, help
# 1  
Old 10-13-2009
Access database over internet, help

Hi! Smilie
I'm new here, and I will appreciate all the help you can give.

This is the problem we are trying to solve at my office.

At office 1 we have SCO UNIX 5.0.can't remember last number. On it runs database software on which we input/read/modify data throughout terminal software, on remote computers XP based(VPN). Also we have ADSL router/modem attached to the switch case with static IP address.

On the other side we have remote office (office 2, VPN 3 computers), also with ADSL on switch case.

Now, is there any way that we can access database to SCO in office 1 throughout internet, and throughout terminal window, from office 2? And how to setup?

Thanks.

EDIT:

Forgot to add:

ADSL Router/Modem has static IP address, created by ISP, and 20 addresses that are setted on router for VPN users to access internet. VPN is not DHCP based, they all have static IP's.

As an example - Workstation PC1:
IP address 192.0.1.10
subnetmask 255.255.255.0
gateway 192.168.1.1(modem)
Primary DNS: 212.62.xxx.xxx ; Secondary DNS: 212.62.xxx.xxx
Internet IP address because of router/modem 192.168.1.10

Last edited by PNemesis; 10-13-2009 at 11:25 AM..
# 2  
Old 12-01-2009
If you are accessing the database via a terminal app, then your best bet would be to SSH to the SCO server.

On the Windows computers, download Putty which will allow you to SSH to your server.

You will need to know the public IP address at Office 1. If it is dynamic, you should sign up for a dynamic dns (search google for that).

You will also need to configure your router at office 1 to allow and forward traffic on port 22 to your SCO server. The steps for this will vary based on the brand of router. Your best bet is to look at its documentation.

_____________

Last edited by vbe; 12-02-2009 at 04:55 AM.. Reason: rm URL

Previous Thread | Next Thread
Test Your Knowledge in Computers #713
Difficulty: Medium
The shared bus between the program memory and data memory leads to the von Neumann bottleneck, the limited throughput (data transfer rate) between the CPU and memory compared to the amount of memory.
True or False?

10 More Discussions You Might Find Interesting

1. IP Networking

Does my provider limit my internet access or somesites access?

Hi Good Day, i would like to ask for further info about my problems experiencing this evening. Im a PPP0 connection in the internet using 3G located in asia pacific region.i had this problem this evening in my INTERNET connections that there are some sites i can't open example ( Gizmodo.com,... (2 Replies)
Discussion started by: jao_madn
2 Replies

2. IP Networking

Network Tweaking - Database Query Across Internet

Hi We run a script that queries a database via the internet and we need the fast possible connections to the database server. I have centos server which sends the requests to the database across the internet . it sends upto 800 queries per milliseconds however this using the default... (4 Replies)
Discussion started by: um08
4 Replies

3. UNIX for Dummies Questions & Answers

Can not access internet?

Hi everybody. I've setup SunSolaris 10 on VirtualBox, but when I start Sun, I can connect to the Internet, when I open terminal and type command for list device ethernet: #ifconfig -a just only see loopback lo0 Can help me solve this problem? Thank you very much, ken (0 Replies)
Discussion started by: kenjingo
0 Replies

4. Solaris

cannot access to internet , help

hi experts i have a sun Enterprise 220 R server with solaris 10 and patches , i configured network card with ip addresses that have access to Internet but i can't be connected :confused: for same informations : root@E220R # ifconfig -a lo0:... (5 Replies)
Discussion started by: lid-j-one
5 Replies

5. UNIX for Dummies Questions & Answers

Internet Access Control

I need to control intenet access @ work. xample. I need PC 1 to only be able to access these five sites and add to the list as needed. Can anyone pint me a direction. (1 Reply)
Discussion started by: fruiz
1 Replies

6. Solaris

Cannot access internet

Hi Friends,:b: This is venkatesh, i have Intel Dual core PC and installed Solaris 10. I have a problem that i cannot access internet in my PC i don't know either the drivers installed or not. I manually assign ip 192.168.1.7 and if i ping to this it is alive and if i ping for 192.168.1.1 for the... (4 Replies)
Discussion started by: 1409.venkatesh
4 Replies

7. SCO

internet access

My SCO box has lost connection to the internet. It sites behind a fire wall and is connected to a local network. What should I check for. (2 Replies)
Discussion started by: fruiz
2 Replies

8. UNIX for Dummies Questions & Answers

Internet access

Hi everybody, I'd like create a connection (by modem) for my unix workstation. I just have the RS232 port and my modem, no lan connection, and I want to surf the net. How can I setup it? Thanks in advance, Mauro (1 Reply)
Discussion started by: Mauro
1 Replies

9. UNIX for Dummies Questions & Answers

Internet access via gateway

Internet access via gateway env: RedHat 6.1 Hi, Until now, we used PPP via an ISDN modem to connect our server to the internet. The ISDN ip-up/down scripts in /etc/ppp add ippp0 as the default route. From that point on we can for instance get mail via fetchmail. Now we have a ADSL... (1 Reply)
Discussion started by: progressdll
1 Replies

10. UNIX for Dummies Questions & Answers

internet access

I've configured my TCP/IP to have the right protocols to access the internet such as TPC/IP, subnet mask, gateway and dns server but still Im not able to ping anything to the internet. Anybody who has some few good words for me? I need help. Thanks. (2 Replies)
Discussion started by: nseal101
2 Replies

Featured Tech Videos