RE: odbc

There is a really cool feature called Data Transformation Services (DTS) in
Microsoft Sql server. I use this to transfer the data between AS400 and Sql
Server.

DTS is basically a wizard type of thing. You must enter where the data
coming from & the data  going to ( could be as400, sql server, access,
oracle etcc...) and also specify what type of connection you are using. In
the connection type you can specify whether its a ODBC or OLEDB connection
type.

OLEDB is a nothing but a free driver thats available with your client
access express.

I never had any kind of data type errors between sql server & as400 and
find it very easy to work with, especially when you deal with data residing
in two different machines.

Hope that helps.

Let me know if you need any more information.

Thanks.
Gade.






"Stone, Brad V (TC)" <bvstone@taylorcorp.com>@midrange.com on 05/08/2000
03:19:12 PM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
cc:
Subject:  RE: odbc


I'd love to here this! Lay it on me, Gade! (unless it's using a mirroring
product)

Brad

> -----Original Message-----
> From: Gade_R_Reddy@consecofinance.com
> [mailto:Gade_R_Reddy@consecofinance.com]
> Sent: Monday, May 08, 2000 11:31 AM
> To: RPG400-L@midrange.com
> Subject: RE: odbc
>
>
>
> Do you have access to microsoft Sql Server???.
>
> If you have, there is a really easy way to transfer data from
> As400 to Sql
> Server & then to your Access. I do this all the time, Believe
> me its really
> simple!!!!.
>
> Let me know.
> Gade.
>

> > ----- Original Message -----
> > From: <Imaginor@aol.com>
> > To: <RPG400-L@midrange.com>
> > Sent: Saturday, May 06, 2000 11:18 AM
> > Subject: odbc
> >
> > > I would like to download a '400 physical file to a
> microsoft access
> data
> > base
> > > file. An associate of mine informed me that when using
> client access,
> it
> > will
> > > take 2 or 3 steps (1. transfer data to a text file...2.
> map to an excel
> > > file...3. import to access). Using an odbc connection and
> definition,
> > can I
> > > map and download directly into access? if so, please
> explain the steps.
> > Thank
> > > you.
> > >
> > > Richard Deutsch
> > > Kiss Products, NY


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---