Visit Our UNIX and Linux User Community

Connect to database through FTP server

Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Connect to database through FTP server
# 1  
Old 10-02-2015
Connect to database through FTP server

Hi All

I need to run a query on a remote database through a shell script. I have the query, I have the script ready. I have the details of the database server I need to connect to.
Now my problem here is , the server where I run the shell script is an FTP server.
->I do not have Oracle installed on it.
->when I execute sqlplus command - says no command found

How do I connect to the database and run the query? I searched forms but all the servers in question have oracle installed. But I don't have on mine.

I have the username and password, Port, Hostname, IP. So is there a way I can connect to the database and execute my query ?

FTP Linux server : GNU/Linux
Database : Oracle

Any help is much appreciated!!

Thanks in Advance!
# 2  
Old 10-02-2015
You may be able to use a Perl DBI connector to do this without the Oracle commandline tool.
# 3  
Old 10-05-2015
Thankyou so much Corona688 . I never used perl before, do you mind if you can share the sample code how it looks and how to connect and execute the query.
# 4  
Old 10-05-2015
If you don't know perl then that's not so helpful.

You might be able to use something like yasql, short for "yet another sql*plus replacement". There are a few similar projects.
# 5  
Old 11-27-2015
You can't do that. I don't know of a single database provider that will work over FTP, including Access.

You MUST have the Access database on either a local drive OR on a UNC path on a server, NOT an FTP or HTTP path. Those will not work.

But unless you have CPanel, ssh or some other form of access that will let you run MySQL or a program that can access the data via MySQL. You don't have access to MySQL's files, not even the file that has your database in it. (They might not even be on the computer you have access to.)

Previous Thread | Next Thread
Test Your Knowledge in Computers #452
Difficulty: Medium
San Francisco has a Linux-based traffic controller computer that meets the latest Advanced Transportation Controller (ATC) standards.
True or False?

10 More Discussions You Might Find Interesting

1. AIX

Connect to database server and execute sql

I have a requirement and below is the detail. Create a shell script and needs to run in server "a". Connect to teradata database server "b". execute the .sql file from server "a" Save the output of the query to a file in server "a" Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies

2. Shell Programming and Scripting

Not able to connect to new FTP server

Hi All, We have done new FTB setup. I am not able to to connect to this new target server. Here is the new setup to send files to the FTB : - Login : FTB-TAN-DEV-SAP - Protocol : SFTP - Port : 54322 - Hostname : ftb-dev.apj.hp - Env : DEV - Target ID : 3225 I tried connecting to the... (5 Replies)
Discussion started by: ROCK_PLSQL
5 Replies

3. Shell Programming and Scripting

Connect to FTP find files and export them to another server

Hi I'm trying to make script that will connect to FTP Server than find files that contain word HIGH in name and than export them to another server. Can anyone tell me if something like this is possible? Thanks :) (7 Replies)
Discussion started by: steve87bg
7 Replies

4. Linux

Unable to connect to Server machine from a client machine using ftp service

Hi, Could you please help me with the below issue.. I'm running RHEL6 OS on both server ( and client machines ( I'm trying to connect to server from the client machine using ftp service. I have installed vsftpd daemon on both the machines. I'm getting... (4 Replies)
Discussion started by: raosr020
4 Replies

5. UNIX for Advanced & Expert Users

Public key to connect from one ftp server to other server

How to generate public key to connect from one ftp server to other server to use in scripting. (1 Reply)
Discussion started by: sridhardwh
1 Replies

6. Linux

Generate public key to connect from one ftp server to other server

How to generate public key to connect from one ftp server to other server to use in scripting. (0 Replies)
Discussion started by: sridhardwh
0 Replies

7. UNIX for Advanced & Expert Users

Unable to use FTP command to connect from one server to another

Hi, I have two unix servers A and B. from A i am trying to use the ftp command to connect to B but I am getting the "ftp: connect: A remote host refused an attempted connect operation." I checked the following things : 1.) Unix Server details for A and B after running the command uname -a... (3 Replies)
Discussion started by: mick_000
3 Replies

8. Shell Programming and Scripting

How to connect to FTP server which requires SSL authentication?

Hello, I tried searching through lot of threads for a solution but couldn't fetch the exact solution, so I am creating a new thread. I am trying to connect to a FTP server 1) using a simple FTP command, it gives the error : 534 Policy requires SSL. Login failed. 2) using SFTP... (19 Replies)
Discussion started by: amitshete
19 Replies

9. AIX

ftp connect in passive mode , ftp settings

how to connect to ftp server in passive mode? ftp and how can i see ftp settings, doesn't exist some ftpd.conf there is some other file where i check the options and configurations of ftp server? Thanks (3 Replies)
Discussion started by: prpkrk
3 Replies

10. Shell Programming and Scripting

ftp script not able to connect to ftp server.

I have the following ftp script to get files from a remote location. However, on running the script I find that I am not even able to connect to ftp server. I am able to connect to ftp server using other GUI ftp tools like WS_FTP using the same IP. IP used here is a dummy IP. What can go... (3 Replies)
Discussion started by: gram77
3 Replies

Featured Tech Videos