connect to AS400 using ADO...

[Matthew Wells]

Can someonne please tell me an ADO connection string to use to link an AS400
table to Access WITHOUT using a DSN?

Thanks.

Matthew Wells
MWells@FirstByt e.net

[pietlinden@hotmail.com]

Re: connect to AS400 using ADO...


Matthew Wells wrote:[color=blue]
> Can someonne please tell me an ADO connection string to use to link[/color]
an AS400[color=blue]
> table to Access WITHOUT using a DSN?
>
> Thanks.
>
> Matthew Wells
> MWells@FirstByt e.net[/color]

Have a look at Carl Prothman's website. He has examples of ADO/.NET
connections on his website

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForAS400FromIBM

[Rick Brandt]

Re: connect to AS400 using ADO...

Matthew Wells wrote:[color=blue]
> Can someonne please tell me an ADO connection string to use to link
> an AS400 table to Access WITHOUT using a DSN?
>
> Thanks.
>
> Matthew Wells
> MWells@FirstByt e.net[/color]

I don't know about ADO specifically, but I have never been able to do any
sort of connection to our AS400 (ISeries) without using a DSN. The problem I
run into is that I can find no entry in the connect string for the "System"
argument that works, and yet it also doesn't work if I leave that argument
out.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Matthew Wells]

Re: connect to AS400 using ADO...

I've been able to open an ADO connection without a DSN, but not refresh a
table link.


"Rick Brandt" <rickbrandt2@ho tmail.com> wrote in message
news:Zkz5e.8887 $c76.8335@newss vr11.news.prodi gy.com...[color=blue]
> Matthew Wells wrote:[color=green]
> > Can someonne please tell me an ADO connection string to use to link
> > an AS400 table to Access WITHOUT using a DSN?
> >
> > Thanks.
> >
> > Matthew Wells
> > MWells@FirstByt e.net[/color]
>
> I don't know about ADO specifically, but I have never been able to do any
> sort of connection to our AS400 (ISeries) without using a DSN. The problem[/color]
I[color=blue]
> run into is that I can find no entry in the connect string for the[/color]
"System"[color=blue]
> argument that works, and yet it also doesn't work if I leave that argument
> out.
>
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>
>
>[/color]

[Matthew Wells]

Re: connect to AS400 using ADO...

I've been ablo to open a connection object and even use the connection to
open an ADO recordset. I want to have my linked tables refresh the
connection string. Right now they use the DSN, I want to get away from
that. The website only gives connection object connection strings. I tried
to add ";Table=tablena me", but that didn't work. I'm looking for the
connectionstrin g for the tabledef.



<pietlinden@hot mail.com> wrote in message
news:1112981825 .899464.76060@o 13g2000cwo.goog legroups.com...[color=blue]
>
> Matthew Wells wrote:[color=green]
> > Can someonne please tell me an ADO connection string to use to link[/color]
> an AS400[color=green]
> > table to Access WITHOUT using a DSN?
> >
> > Thanks.
> >
> > Matthew Wells
> > MWells@FirstByt e.net[/color]
>
> Have a look at Carl Prothman's website. He has examples of ADO/.NET
> connections on his website
>[/color]
http://www.carlprothman.net/Default....orAS400FromIBM[color=blue]
>[/color]