Geek Answers Handbook

How do I specify a standard SQL library in the IBM iSeries 2 connection to AS / 400?

I am connecting to the AS / 400 stored procedure layer using the IBM iSeries Access for Windows package. This provides a .NET DLL with classes similar to classes in a namespace System.Data. Thus, we use their implementation of the connection class and provide it with a connection string.

Does anyone know how I can change the connection string to specify the default library that it should use?

+5
source share
3 answers

If you connect via .NET :

Provider=IBMDA400;Data Source=as400.com;User Id=user;Password=password;Default Collection=yourLibrary;

- , , .

ODBC Windows (, ):

DRIVER=Client Access ODBC Driver(32-bit);SYSTEM=as400.com;EXTCOLINFO=1;UID=user;PWD=password;LibraryList=yourLibrary

LibraryList - , , ODBC.

IBM AS400, , IBM "System Access for Windows", :

DRIVER=iSeries Access ODBC Driver;SYSTEM=as400.com;EXTCOLINFO=1;UID=user;PWD=password;LibraryList=yourLibrary

, DRIVER.

.NET, providerName XML API, , OleDb:

providerName="System.Data.OleDb"
+4

Delphi Client Access Express. , , , , . DBQ - , System - AS400/DB2.

ConnectionString :=
  'Driver={Client Access ODBC Driver (32-bit)};' +
  'System=' + System + ';' +
  'DBQ=' + Lib + ';' +
  'TRANSLATE=1;' +
  'CMT=0;' +
  //'DESC=Client Access Express ODBC data source;' +
  'QAQQINILIB=;' +
  'PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;' +      
  'SORTTABLE=;' +
  'LANGUAGEID=ENU;' +
  'XLATEDLL=;' +
  'DFTPKGLIB=QGPL;';
+2

OLE DB? , :

<add name="AS400ConnectionString" connectionString="Data Source=DEVL820;Initial Catalog=Q1A_DATABASE_SRVR;Persist Security Info=False;User ID=BLAH;Password=BLAHBLAH;Provider=IBMDASQL.DataSource.1;**Catalog Library List=&quot;HTSUTST, HTEUSRJ, HTEDTA&quot;**" providerName="System.Data.OleDb" />
+1

More articles:


All Articles