Connect remote db problem

carmenlei · #1 (**permalink**) 06-03-04, 00:18

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~

sathyaram_s · #2 (**permalink**) 06-03-04, 04:20

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

carmenlei · #3 (**permalink**) 06-03-04, 05: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?

J Petruk · #4 (**permalink**) 06-03-04, 08:06

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech