WinSCP with Database

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.

Actually I am getting information from text file.
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

You can possibly use command-line client on the database of the server-side. But this is completely out of topic of this forum.

But can I know how?

@goku: 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 provides this as an interface it ought to 'just work'. For me the HP Nonstop worked great but ymmv.

Nope, by the way, I plan to create a website.
Inside the website, I set a ID and PW.

To check the correct id and 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.

@goku: OK, you are talking two different 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 application (forum) and we log in with that. Application 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 available 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 for a rookie. Here is a link (<invalid hyperlink removed by admin>) 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 (<invalid hyperlink removed by admin>), but it is for a very old version of Apache.

I hope I got the point of your question and provided useful feedback.

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

<invalid hyperlink removed by admin>

@Freitag: Thank you. I will check this out. =)