Re: FSO/firewall question

From: Baki (bobradovic2001@yahoo.com)
Date: 10/01/02 

From: "Baki" <bobradovic2001@yahoo.com>
Date: Tue, 1 Oct 2002 08:34:54 -0400

Hi Ken,
I didn't mean to store files in SQL Server using FSO, but to store files
(simple fso.Copy) on the server where SQL Server is installed!
Thanks anyway,
Regards,
Baki
"Ken Schaefer" <kenRMV@THISadOpenStatic.com> wrote in message
news:#mowWgEaCHA.2616@tkmsftngp09...
> 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: create excel worksheet from Active X Script Task Props
    ... personally I would be using the Excel object model to do this ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > Dim fso, MyFile ... > Set fso = CreateObject ...
    (microsoft.public.sqlserver.dts)
  • Re: FSO/firewall question
    ... For any such firewall question, you can always try the operation and then ... check the firewall logs to see what ports were used / blocked. ... > on the server where SQL Server is installed! ... >> You can not access your database server using FSO. ...
    (microsoft.public.inetserver.iis.security)
  • Re: website defaced
    ... Do you run an FTP server on ... Or an SQL Server? ... How about remote access software? ... the admin website is not accessible from the Internet? ...
    (microsoft.public.inetserver.iis.security)
  • Re: What is the best way to transfer a file of size around 20GB ?
    ... If the file is now on the FTP Server, did you try downloading the file off the FTP Server? ... If the file is not on a FTP Server, get a temporary FTP server running on that server, and use the other computer to download the file off that FTP Servr. ... the backup staff restore it to another server that runs as IIS + FTP Server (Not the one where SQL Server installed). ...
    (microsoft.public.windows.server.general)
  • Re: Replication
    ... The only other virtual directory used in replication ... virtual directory on your ftp server. ... Looking for a SQL Server replication book? ... > subscription, repldata folder in the SQL Server directory, etc... ...
    (microsoft.public.sqlserver.replication)