Topic "Winscp with Database"

Author Message
raghavendraselvan.sk
[View user's profile]

Joined: 2010-03-30
Posts: 3
Location: Bangalore
Hi,

I need to connect to sql server database from winscp.com , is there a way . I could find call statement is present. But i dont know how to connect to database to get some information from tables .

actaually i am getting information from text file .

open user:password@example.com
cd home/asuser
get *.txt D:\max\

Instead of getting info from file , i am planning to store these info in sql server tables and get the info from tables to this winscp.com.

please let me know if you find any way along with the example

Thanks
Raghav
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25034
Location: Prague, Czechia
You can possibly use command-line client on the database of the server-side. But this is completely out of topic of this forum.
_________________
Martin Prikryl
goku

Guest


but can i know how?
Freitag
[View user's profile]

Joined: 2007-10-25
Posts: 51
goku wrote:
but can i know how?


It entirely depends on the database engine. I only know of one database that provides this type of interface. HP Nonstop (formery Tandem) provides a way to use FTP to log in and use the "get" command against a stored procedure name. It executes the stored procedure and then provides the results in a CSV format as if you had started a normal file download transfer.

From the client end it is identical to standard FTP - so if your database engine provies this as an interface it ought to 'just work'. For me teh HP Nonstop worked great but ymmv.
goku

Guest


nope, by the way, i plan to create a website.
inside the website, i set a ID n PW.

to check the correct id n pw, i need to connect to mysql to do so. but i got no idea to connect to mysql with winscp.

anyone of you know how to connect to mysql database with winscp? so i can check my id password that already keep inside the database.

thank you.
Freitag
[View user's profile]

Joined: 2007-10-25
Posts: 51
goku wrote:
nope, by the way, i plan to create a website.
inside the website, i set a ID n PW.

to check the correct id n pw, i need to connect to mysql to do so. but i got no idea to connect to mysql with winscp.

anyone of you know how to connect to mysql database with winscp? so i can check my id password that already keep inside the database.

thank you.


OK, you are talking two differnt things here. WinSCP connects to server software and a website is application software.

This of this forum site. Only Martin has access to the files that make up this website and he might use WinSCP to manage those files. But we all have IDs inside the web applicaiton (forum) and we log in with that. Applicaiton access and file access are two different animals.

Now if you are looking for how a website might handle file upload and download, check how phpBB does it. The user ID that owns the phpBB application has permission to upload files. And as a user uploads a file through the phpBB software it is tracked so that the unique file name on the server (not the same as the file name the user used for it) is stored in a DB table. When a user wants to download a file, the list of avaialable files is shown to him (pulled from the DB by SQL according to his permissions) and when he clicks the download link a standard file transfer is kicked off in the web server.

phpBB has all the examples in it you might need, but that software is huge and not a good starting place fora rookie. Here is a link to a set of source code that manages user registration and login. And this link is to a set of source code that lets you do remote file management.

You can also let Apache manage access directly, but it does not typically keep the ID/PW in a database. Instead it uses a config file in a secure (non-remotely accessible - except by WinSCP and owner ID) area. Some quick google searches did find where someone showed how to manage Apache using a MySQL table, but it is for a very old version of Apache.

I hope I got the point of your question and provided useful feedback.
Freitag
[View user's profile]

Joined: 2007-10-25
Posts: 51
Here is an open source project that might be what you are looking for almost exactly.

<invalid hyperlink removed by admin>
goku

Guest


Freitag wrote:
Here is an open source project that might be what you are looking for almost exactly.

<invalid hyperlink removed by admin>



Thank you. i will check this out. =)
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License