AS400 connection AGAIN....

[Matthew Wells]

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

[Albert D. Kallal]

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

[MGFoster]

-----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.

[Matthew Wells]

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" <[e-mail]> 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.

[Johnson Cheung]

"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]