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

AS400 connection again...

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? I want to use:

currentdb.tabledefs(td).connect = sConnectionString
currentdb.tabledefs(td).RefreshLink

I CAN ALREADY CREATE AN ADO CONNECTION. THE WEB SITES PEOPLE ARE SUGGESTING
ONLY GIVE CONNECTION STRINGS NOT A STRING I CAN USE FOR A TABLEDEF.
Is there a way?

Thanks.

Matthew Wells
MW****@FirstByte.net


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Fri, 08 Apr 2005 21:38:21 GMT, "Matthew Wells"
<MW****@FirstByte.net> wrote:

I like this site for connection strings:
http://www.carlprothman.net/Default.aspx?tabid=81
(formerly able-consulting.com)

-Tom.

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

currentdb.tabledefs(td).connect = sConnectionString
currentdb.tabledefs(td).RefreshLink

I CAN ALREADY CREATE AN ADO CONNECTION. THE WEB SITES PEOPLE ARE SUGGESTING
ONLY GIVE CONNECTION STRINGS NOT A STRING I CAN USE FOR A TABLEDEF.
Is there a way?

Thanks.

Matthew Wells
MW****@FirstByte.net


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.