Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    24

    Unanswered: Connect remote db problem

    I am a beginner of DB2 and I have problems when I try to connect to the remote DB2 server. Is there any method other than add a new db alias in the configuration assistant? Or can I connect to a database server without specifying any database name? thanks very much~
    Last edited by carmenlei; 06-03-04 at 01:21.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can define DB2DBDFT using db2set command ... If an application has no database connection but SQL statements are issued, an implicit connect will be made if the DB2DBDFT database ...

    BTW, what is your problem connecting to a database ?

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2004
    Posts
    24
    Actually I want to connect to the db2 server with my application written by VC++ and SQLAPI. The problem is that I found that I can connect to the datebase only when the application and database rest in the same machine. I use the connection string as "DSN=data source name, Uid=id, PWD=pwd". I guess that if I install the DB2 client in the client machine and use the configuration assistant to set the configuration, then I will success, isn't it? I want to know is there any method other than install the DB2 client? Did I use the right connection string?

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by carmenlei
    Actually I want to connect to the db2 server with my application written by VC++ and SQLAPI. The problem is that I found that I can connect to the datebase only when the application and database rest in the same machine. I use the connection string as "DSN=data source name, Uid=id, PWD=pwd". I guess that if I install the DB2 client in the client machine and use the configuration assistant to set the configuration, then I will success, isn't it? I want to know is there any method other than install the DB2 client? Did I use the right connection string?
    Correct - you need the client installed.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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