Connecting to AS400

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Cannot display ODBC login prompt - want to connect without DSN
    ... ODBC was superseded thirteen years ago by OleDb: ... In this particular case, my program will conect to an Oracle database, but ... There does not seem to be a .NET provider for MS Access, ...
    (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)