473,320 Members | 1,879 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

connect to AS400 using ADO...

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
4 4643

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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: vee10 | last post by:
hi, I need help to connect to database(SQLSERVER2005) using javascript please help me
5
by: chathu03j | last post by:
how do you connect a MS Access database to a vb application using the ODBC connection?
3
by: yogesh | last post by:
how to connect MySQL using C++ in redhat .... can any one tell a sample of code to creat ,connect and execute the statement in c++ code ... please help me .....
3
by: HardQuestion | last post by:
Hi I'm unable to connect to Oracle10g using vb Its giving providers problem
1
by: gioibm | last post by:
Hi. Have someone solution to read mysql database from as400 to write db2??? Thanks
3
by: arasub | last post by:
ep 20, 2007 11:25:57 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found...
0
by: moyoal | last post by:
Dear All, this is my first experience to connect forms and database using VPN / DSL from other location. we have client/server architectures, .FMX are available in 212.147.1.63 server. ...
0
by: VIGIN | last post by:
Dear All, I am trying to connect my Sever using dyndns with php code. My Code is $dsn = 'DRIVER={SQL Server};SERVER=xxxx-xxxxx.dyndns.org,1028\SQLEXPRESS;DATABASE=Cxxxxxxx6'; $connection =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.