Re: How to configure SSL external access to a database?

[Wayne McAlpine <wayne.mcalpine@xxxxxxxxxxxxxxxxx>]

You're right Jerry.  I didn't read it closely enough before I posted. 
FTP is limited to file transfers and won't provide record-level access. 
 You can, however, use it to append a file to an existing file.

Scott's idea of using a VPN for the secure connection and then using 
ODBC sounds like a good approach.

Jerry Adams wrote:
> Charles,
>
> In your original post you said you " want to allow one of our partners to connect to a DB2 database file located on our iSeries, using SSL, to write records".  This doesn't sound like an ftp process, but I'm no ftp expert.
>
> ODBC set-up (Windows Control Panel...Administrative Tools...ODBC...) has an option to allow the connection using SSL.  Define your ODBC connection, there is a "Connection Options..." button.  The SSL option is towards the bottom (Windows XP).
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles St-Laurent
> Sent: Friday, August 08, 2008 11:26 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: How to configure SSL external access to a database?
>
> Hi!
>
> How is it possible to write records to a database file using secured ftp?
>
> Charles
>
>
> You can do  <http://archive.midrange.com/midrange-l/200808/msg00281.html#>
> secure FTP and write records to a database file.
>
> Charles St-Laurent wrote:
>
>
> Hi!
> I want to allow one of our partners to connect to a DB2 database file
> located on our iSeries, using SSL, to write records. But I don't know how to
> configure SSL to allow encrypted ODBC access to this table. It it possible
> natively? Must we buy a third-party database tool and install it on our
> iSeries  <http://archive.midrange.com/midrange-l/200808/msg00281.html#>
> server?
> If it is possible to do it natively, is there any step-by-step tutorial that
>
> shows how to configure it?
> Thanks for your answers
> Charles St-Laurent
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.