Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    33

    Arrow Unanswered: connection string of OLE DB for DB2

    Hi all,

    I am writing c# application to connect to a DB2 database using OLE DB,
    do any one of u knows the correct format of the connection string, if possible, pls give an example.

    Much Thanks.

    ME

  2. #2
    Join Date
    Apr 2004
    Posts
    3
    Take a look at www.connectionstrings.com

    We use the following string. Server port, Schema, Extended properties parts are optional. trusted_connection tells the database to use OS authentication.

    Code:
    Provider=IBMDADB2;Data Source=YourDatabase;Location=YourServer:YourServerPort;CurrentSchema=YourDefaultSchema;Extended Properties="trusted_connection=yes";
    Michael.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •