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

AS400 connection AGAIN....

P: n/a
FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR
CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN
EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I NEED TO REFRESH A DAO
(Access) TABLEDEF OBJECT'S CONNECTION STRING WHICH MUST INCLUDE A CLAUSE FOR
THE TABLE NAME. THIS IS WHAT I NEED. PLEASE READ AGAIN.

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

or if I must:

docmd.transfer database....

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.

Thank you.

Matthew Wells
MW****@FirstByte.net
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
The first link below should do the trick for you...

http://members.rogers.com/douglas.j....LessLinks.html

ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafa...m&Article=true

HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875

ODBC DSN Less
http://www.able-consulting.com/MDAC/...BC_DSNLess.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #2

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Using ADO usually means connection w/ the OLE DB connection. A TableDef
uses ODBC connection strings.

I've had trouble using ODBC DSN-less connection strings with AS400s.
Never could get the system name to be recognized. Perhaps it was the
system I was trying to connect to.

Here is a format for an AS400, ODBC connection for a TableDef (all one
line):

ODBC;Driver={Client Access ODBC Driver (32-bit)};
System=my_system_name;Uid=myUserName;Pwd=myPwd

The Table Name parameter is not needed when you reset the connection
string for a TableDef; it will be automatically added to the string when
you reset it.

The driver "Client Access ODBC Driver (32-bit)" must be in the ODBC
Administration, Drivers window.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlrOK4echKqOuFEgEQLocACdFv80nAFWwoVR/yIGPNcNhb90t+EAnjcq
/1pJ1hsH9qb21jsEg6Ur/fga
=eX0v
-----END PGP SIGNATURE-----
Matthew Wells wrote:
FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR
CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN
EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I NEED TO REFRESH A DAO
(Access) TABLEDEF OBJECT'S CONNECTION STRING WHICH MUST INCLUDE A CLAUSE FOR
THE TABLE NAME. THIS IS WHAT I NEED. PLEASE READ AGAIN.

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

or if I must:

docmd.transfer database....

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.

Nov 13 '05 #3

P: n/a
That is the string I've found, but it doesn't work. I keep getting

Reserved error (-7778); there is no message for this error.

any ideas?

Matthew Wells
MW****@FirsByte.net

"MGFoster" <me@privacy.com> wrote in message
news:e7*****************@newsread2.news.pas.earthl ink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Using ADO usually means connection w/ the OLE DB connection. A TableDef
uses ODBC connection strings.

I've had trouble using ODBC DSN-less connection strings with AS400s.
Never could get the system name to be recognized. Perhaps it was the
system I was trying to connect to.

Here is a format for an AS400, ODBC connection for a TableDef (all one
line):

ODBC;Driver={Client Access ODBC Driver (32-bit)};
System=my_system_name;Uid=myUserName;Pwd=myPwd

The Table Name parameter is not needed when you reset the connection
string for a TableDef; it will be automatically added to the string when
you reset it.

The driver "Client Access ODBC Driver (32-bit)" must be in the ODBC
Administration, Drivers window.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlrOK4echKqOuFEgEQLocACdFv80nAFWwoVR/yIGPNcNhb90t+EAnjcq
/1pJ1hsH9qb21jsEg6Ur/fga
=eX0v
-----END PGP SIGNATURE-----
Matthew Wells wrote:
FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR
CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I NEED TO REFRESH A DAO
(Access) TABLEDEF OBJECT'S CONNECTION STRING WHICH MUST INCLUDE A CLAUSE FOR THE TABLE NAME. THIS IS WHAT I NEED. PLEASE READ AGAIN.

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

or if I must:

docmd.transfer database....

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.

Nov 13 '05 #4

P: n/a
"ODBC;DRIVER={Client Access ODBC Driver
(32-bit)};DESC=QGPL;SORTTABLE=;LANGUAGEID=ENU;XLATEDLL =;DFTPKGLIB=QGPL;SYSTEM=192.168.104.22;FILEDSN=XX; ;TABLE=QGPL.A"

U NEED TO CHANGE [SYSTEM] & [TABLE]
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.