By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

connect to AS400 using ADO...

P: n/a
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
MW****@FirstByte.net
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

Matthew Wells wrote:
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
MW****@FirstByte.net


Have a look at Carl Prothman's website. He has examples of ADO/.NET
connections on his website
http://www.carlprothman.net/Default....orAS400FromIBM

Nov 13 '05 #2

P: n/a
Matthew Wells wrote:
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
MW****@FirstByte.net


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

Nov 13 '05 #3

P: n/a
I've been able to open an ADO connection without a DSN, but not refresh a
table link.
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:Zk*****************@newssvr11.news.prodigy.co m...
Matthew Wells wrote:
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
MW****@FirstByte.net
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


Nov 13 '05 #4

P: n/a
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=tablename", but that didn't work. I'm looking for the
connectionstring for the tabledef.

<pi********@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

Matthew Wells wrote:
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
MW****@FirstByte.net


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

http://www.carlprothman.net/Default....orAS400FromIBM

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.