Connecting to AS400

From: Darshan (Darshan_at_discussions.microsoft.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 07:51:02 -0700

I am creating a .NET Windows Application, that will connect to an AS400
database, and run a fixed query against it every 5 hours.

I am having problems creating the connection string. I do not know what
provider I have to use.
So far, I have:
"Provider=?;Data Source=ProductsDB;User Id=XXXXXXXX;Password=XXXXXXX;"

I tried AS400 as the Provider, but that did not work. Some help please.

Darshan

Relevant Pages

  • Re: Connecting to AS400
    ... Whose provider are you using? ... > database, and run a fixed query against it every 5 hours. ... > I am having problems creating the connection string. ...
    (microsoft.public.data.ado)
  • Re: MS Oracle Data Provider BUG: Data corrupt after 16 rows with O
    ... Could you use this to check the data in your database? ... Once you have done this with both the Oracle managed provider and either ... imported into the 9i database without any errors (i tried 8i Client as well ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: application design problem
    ... Actual action is depends on your Provider which provide service for a particual database or data store. ... When I would click Button1 this sql would execute: ... I dont think its a good idea to put all your client spcific logic ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Choosing a Windows Database
    ... >> use some kind of relational database. ... >> multiple users can access and something scalable and fast. ... >> ADO.NET or ODBC provider. ... >> out there using the DBF type files. ...
    (microsoft.public.vb.database)
  • Re: VS.net installs sql express as default datastore for role/membersh
    ... I can use sql or access databases for dataaccess, ... Asp.net web site administration tool. ... Select provider configuration ... it seems easy to select an other database. ...
    (microsoft.public.dotnet.framework.aspnet)