RE: SQL package creation and usage

Chris,

I don't think you can set the package name in the connection string.
If you're doing this just to debug this particular ASP page, you could
change DFTPKGLIB to a library other than XSPPKG, as changing the library is
allowed.

Check this page out for more details on valid connection string parameters:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/rzaik/rzai
k15.htm

Elvis


-----Original Message-----
Subject: SQL package creation and usage

When a web page (ADO/.asp) connects to the iSeries server using iSeries
Access ODBC, a SQL package is created due to the connection using extended
dynamic SQL.  The package is given a default name, since we are using the
following connection string:

Db.Open "Driver=iSeries Access ODBC Driver; System=servername; UID=username;
PWD=password; XDYNAMIC=1; DFTPKGLIB=XSPPKG;
PKG=XSPPKG/DEFAULT(IBM),2,0,1,0,512;"

I would like to assign a specific, unique name to the package for a
particular asp page, but cannot get the engine to create a new package with
a new name, for example:

Db.Open "Driver=iSeries Access ODBC Driver; System=servername; UID=username;
PWD=password; XDYNAMIC=1; DFTPKGLIB=XSPPKG;
PKG=XSPPKG/mysqlpkg(IBM),2,0,1,0,512;"

Can anyone tell me if and how this can be done?