| Author |
Message |
nospam
Guest
|
 Posted:
Tue Oct 26, 2004 5:54 pm Post subject:
AS400 and ADO.NET |
|
|
I've defined the following Data Source with the Data Access Tool:
Data Source Platform: AS/400 File System
Network Type: TCP/IP
Address or Alias: 192.168.100.14
Port: 446
Location: S105DXTM
Default Library: QGPL
User, Password, etc, etc.
The "Connect" button and "Sample Query" button are working fine on this data
source (called AS400DS).
But, when I run the Managed Db2 Client sample with the .udl file defined
with DataAccessTool for AS400DS, I get the error: "Invalid UDL file".
Which would be the right connection string of MsDb2Connection class for this
data source? |
|
| Back to top |
|
 |
Aaron Grady [MSFT]
Guest
|
| Posted:
Wed Oct 27, 2004 2:46 am Post subject:
Re: AS400 and ADO.NET |
|
|
In the data access tool you need to define a Data Source with a platform of
DB2/AS400.
AS/400 File system is for accessing flat files on the AS/400, not database
files.
If you do need to accesss flat files on the AS/400 from .NET then you can do
this, but you need to use the Managed provider for Ole Db
(System.Data.OleDb), not the Managed provider for DB2.
HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"nospam" <nospam@online.nospam> wrote in message
news:%232e4zr1uEHA.2012@TK2MSFTNGP15.phx.gbl...
| Quote: | I've defined the following Data Source with the Data Access Tool:
Data Source Platform: AS/400 File System
Network Type: TCP/IP
Address or Alias: 192.168.100.14
Port: 446
Location: S105DXTM
Default Library: QGPL
User, Password, etc, etc.
The "Connect" button and "Sample Query" button are working fine on this
data
source (called AS400DS).
But, when I run the Managed Db2 Client sample with the .udl file defined
with DataAccessTool for AS400DS, I get the error: "Invalid UDL file".
Which would be the right connection string of MsDb2Connection class for
this
data source?
|
|
|
| Back to top |
|
|
nospam
Guest
|
| Posted:
Thu Oct 28, 2004 3:34 pm Post subject:
Re: AS400 and ADO.NET |
|
|
Thank you Aaron.
If I define the following Data Source (called 'xxxx')with the Data Access
Tool:
Data Source Platform: DB2/AS400
Network Type: TCP/IP
Address or Alias: 192.168.100.14
Port: 446
Initial Catalog: S105DXTM
PackageLocation: Test
Default Schema: Test
User, Password, etc
The connect button works fine, the messages on it are:
Successfully connected to data source 'xxxx'.
Server class: DB2/400
Server version: 05.01.0000
The Packages button works fine too, the messages on it are:
Connected to data source 'xxxx'.
AUTOCOMMITTED package has been created.
READ COMMITTED package has been created.
READ UNCOMMITTED package has been created.
SERIALIZABLE package has been created.
REPEATABLE READ package has been created.
The package creation process has completed successfully.
However, the "Sample Query" button throws these error messages:
Could not connect to data source 'xxxx':
One or more errors occurred during processing of command.
Do you have any idea how I can see more details about this error?.
Have you tried the Managed DB2 Client Sample in the SDK on AS/400?
"Aaron Grady [MSFT]" <aagrady@online.microsoft.com> wrote in message
news:edMe%23U6uEHA.3948@TK2MSFTNGP15.phx.gbl...
| Quote: | In the data access tool you need to define a Data Source with a platform
of
DB2/AS400.
AS/400 File system is for accessing flat files on the AS/400, not database
files.
If you do need to accesss flat files on the AS/400 from .NET then you can
do
this, but you need to use the Managed provider for Ole Db
(System.Data.OleDb), not the Managed provider for DB2.
HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"nospam" <nospam@online.nospam> wrote in message
news:%232e4zr1uEHA.2012@TK2MSFTNGP15.phx.gbl...
I've defined the following Data Source with the Data Access Tool:
Data Source Platform: AS/400 File System
Network Type: TCP/IP
Address or Alias: 192.168.100.14
Port: 446
Location: S105DXTM
Default Library: QGPL
User, Password, etc, etc.
The "Connect" button and "Sample Query" button are working fine on this
data
source (called AS400DS).
But, when I run the Managed Db2 Client sample with the .udl file defined
with DataAccessTool for AS400DS, I get the error: "Invalid UDL file".
Which would be the right connection string of MsDb2Connection class for
this
data source?
|
|
|
| Back to top |
|
|
Aaron Grady [MSFT]
Guest
|
| Posted:
Fri Oct 29, 2004 12:03 am Post subject:
Re: AS400 and ADO.NET |
|
|
The sample query button uses the default schema to try and get a list of
tables. If your default schema setting is not filled in, or not pointing to
a valid library/collection, this could fail. Or if you don't have rights to
the library/collection it is pointing to. To get more info about what might
be happening you would have to turn on some tracing.
Yes, I have used the SDK sample against an AS/400 without any problems. What
happens if you use that tool to run a query against the AS/400? If it fails,
can you post the exact error message you receive?
Thanks,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"nospam" <nospam@online.nospam> wrote in message
news:%23QeH8mNvEHA.1204@TK2MSFTNGP10.phx.gbl...
| Quote: | Thank you Aaron.
If I define the following Data Source (called 'xxxx')with the Data Access
Tool:
Data Source Platform: DB2/AS400
Network Type: TCP/IP
Address or Alias: 192.168.100.14
Port: 446
Initial Catalog: S105DXTM
PackageLocation: Test
Default Schema: Test
User, Password, etc
The connect button works fine, the messages on it are:
Successfully connected to data source 'xxxx'.
Server class: DB2/400
Server version: 05.01.0000
The Packages button works fine too, the messages on it are:
Connected to data source 'xxxx'.
AUTOCOMMITTED package has been created.
READ COMMITTED package has been created.
READ UNCOMMITTED package has been created.
SERIALIZABLE package has been created.
REPEATABLE READ package has been created.
The package creation process has completed successfully.
However, the "Sample Query" button throws these error messages:
Could not connect to data source 'xxxx':
One or more errors occurred during processing of command.
Do you have any idea how I can see more details about this error?.
Have you tried the Managed DB2 Client Sample in the SDK on AS/400?
"Aaron Grady [MSFT]" <aagrady@online.microsoft.com> wrote in message
news:edMe%23U6uEHA.3948@TK2MSFTNGP15.phx.gbl...
In the data access tool you need to define a Data Source with a platform
of
DB2/AS400.
AS/400 File system is for accessing flat files on the AS/400, not
database
files.
If you do need to accesss flat files on the AS/400 from .NET then you
can
do
this, but you need to use the Managed provider for Ole Db
(System.Data.OleDb), not the Managed provider for DB2.
HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD
SNA Server/Host Integration Server 2000
Microsoft
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"nospam" <nospam@online.nospam> wrote in message
news:%232e4zr1uEHA.2012@TK2MSFTNGP15.phx.gbl...
I've defined the following Data Source with the Data Access Tool:
Data Source Platform: AS/400 File System
Network Type: TCP/IP
Address or Alias: 192.168.100.14
Port: 446
Location: S105DXTM
Default Library: QGPL
User, Password, etc, etc.
The "Connect" button and "Sample Query" button are working fine on
this
data
source (called AS400DS).
But, when I run the Managed Db2 Client sample with the .udl file
defined
with DataAccessTool for AS400DS, I get the error: "Invalid UDL file".
Which would be the right connection string of MsDb2Connection class
for
this
data source?
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in