Re: How do I connect from iSeries to MS SQL Server 2000?

Our problem is performance; we're having scores of simultaneous searches on 
10s of millions of db records.  An upgrade to an iSeries system capable of 
handling our projected needs over the next 3 years (hundres of simultaneous 
searches on 100s of millions of records) will cost at about $500K, another 
$1M+ after that.  My gawd.

So... I'm exploring alternatives to spending that kind of money.

Option 1 (for me) is quicker. I don't know what performance will be like 
using a 3rd party connector (such as RPG2SQL), so I'll have one of our Java 
programmers explore option 2 (JDBC).

That said: where can I find more info/examples of using JDBC to pull data 
from a MS SQL server?  Our Java guys know virtually nothing about the 
iSeries, and I'll need to give them a starting point.

Tom

<rob@xxxxxxxxx> wrote in message 
news:OF7BD5A123.2E23F2C0-ON05257018.0074F34D-05257018.007560B8@xxxxxxxxxxxx
> Been a LOT of discussion on this support, or lack thereof, lately.
>
> You have a few choices:
> 1 - Spend money for a canned solution
> 2 - Learn java and use jdbc
> 3 - Seek alternative solution.
> 4 - Submit DCR to IBM to get what you are trying to work to do so.
>
> People happy to take your check:
> a - IBM for something called websphere integrator.  What it has in common
> with Websphere - who knows.  Marketing ploy I suspect.  Don't let it
> confuse you.
> b - Search for John Brandt for his solution
> c - Search for Vern Hamberg and the company he works for now.
> d - Possibly some others.  (Forgive me if I've missed you.)
>
> The native lack to do what you are trying to do is chafing us mightily.
>
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Tom" <tomh5480@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 06/06/2005 03:55 PM
> Please respond to
> Midrange Systems Technical Discussion 
> <midrange-l@xxxxxxxxxxxx>
>
>
> To
> midrange-l@xxxxxxxxxxxx
> cc
>
> Subject
> How do I connect from iSeries to MS SQL Server 2000?
>
>
>
>
>
>
>
> I have a database on a MS SQL Server (SP3a), installed on a Windows XP Pro
>
> (SP2) testbed.  I think that I've got the DRDA stuff set up properly on
> the
> AS400:
>
> 1. ADDTCPHTE INTNETADR('192.168.30.66') HOSTNAME((TOMDELL))
> 2. QSYS/ADDRDBDIRE RDB('TOMDELL') RMTLOCNAME('192.168.30.66' *IP)
> 3. ADDSVRAUTE USRPRF(TOMH) SERVER(TOMDELL) USRID(TOMH)
> PASSWORD('PASSWORD')
>
> I start up Interactive SQL on the 400, and enter this command:
>
> connect to TOMDELL user tomh using 'PASSWORD'
>
> And I get this error log:
>
>>strsql
>>A remote host refused an attempted connect operation (CPE3425)
>>DDM TCP/IP communications error occurred on connect() to Application
> Server
>>(CPD3E34)
>>File QCNDDMF was already closed, never opened or not from this process
>>(CPF4404)
>>Cannot establish DDM connection with remote system (CPF9162)
>>Communication error occurred during distributed database processing
>>(SQ30080)
>
> I'm weak on the PC side of things - to allow the connection to the pc
> database:
> 1. I've "heard" DRDA is available for MS SQL Server - true?  How do I
> get/activate it? Or is it already active after initial MS SQL Server
> installation?
> 2. Is there some config that I need to check in MS SQL Server 2000?  How
> about in Windows XP Pro?
> 3. There's no firewall running on the PC, there is a corporate firewall.
> Do
> I need to make sure that some particular ports are open?
> 4. Is there some .net or other PC software thing that I should install to
> get this working?
>
> Tom
>
>
>
> -- 
> 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.
>
>
> -- 
> 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.
>
>