Re: FSO/firewall question

From: Ken Schaefer (kenRMV@THISadOpenStatic.com)
Date: 09/30/02 

From: "Ken Schaefer" <kenRMV@THISadOpenStatic.com>
Date: Mon, 30 Sep 2002 16:11:41 +1000

You can not access your database server using FSO. FSO is for file system
manipulation. You need to use a data access technology (eg ADO+OLEDB, SQLDMO
etc) to connect to SQL Server.

If you want to insert a file into your SQL Server, you can use ADO, and this
will work via TCP port 1433

That said, storing binary/BLOB data in SQL Server probably isn't the best
use of resources...

Cheers
Ken 

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Baki" <bobradovic2001@yahoo.com> wrote in message
news:#WwOcVmZCHA.1860@tkmsftngp12...
> Hi guys,
> we have following standard configuration:
>     * external firewall (TCP 80, 25, 21)
>     * web server, ftp server (IIS 5.0), standalone server
>     * internal firewall (TCP 1433)
>     * database server (SQL Server 2000), member of AD
> We also have web application (on IIS) that works fine. Meanwhile we
started
> collecting files on our FTP server. We want to store those files on
database
> server using FSO, from our web application. In order to do that, what TCP
> ports do we have to open on internal firewall? Wouldn't  security be
> jeopardized? What can we implement as an alternative solution (maybe FTP
> upload from application -iis to db-server?)
> Thanks in advance,
> Baki
>
>

Relevant Pages

  • Re: How do you modify and save txt or xml file using FP VBA or via
    ... Now I understand and know what you meant, and I do know capabilities of FSO ... I do not think I can execute asp code from this environment. ... I am trying to figure out how to use FP Server Extensions to help me EDIT ... > security update, then there is usually no charge for the call. ...
    (microsoft.public.frontpage.addins)
  • Re: file system management
    ... Except the word "fso" doesn't belong to asp.net dictionary. ... the server part is doable. ... Present it to the client allow drag and drop then post back to ... >> Mike, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Set a value to a hidden field in a web page
    ... Check if the fso object is set. ... Do you have yet tweaked security? ... If I remember when security is not tweaked, ... server side even if you don't want to upload this file. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How do you modify and save txt or xml file using FP VBA or via
    ... Yes, FSO is a Windows Server component, but requires access permission on server for a specific ... security update, then there is usually no charge for the call. ... > Dim oFSO As FileSystemObject ...
    (microsoft.public.frontpage.addins)
  • Re: Set a value to a hidden field in a web page
    ... The problem does not appear when working with fso. ... > "Hidden Text" server side? ... >> The problem appear when I'm trying to set the value to the hide control, ... >> function getpicvb() ...
    (microsoft.public.dotnet.framework.aspnet)