Accessing db2 remotely

dlare9 · #1 (**permalink**) 07-11-06, 10:41

Hi again,

I have a DB2 database placed on a different database server (Remote) and I have C application placed on different location/pc.
I need to connect to the DB2 database from my C application.
Currently I use the ff. codes to connect to the database locally.

Code:

int ConnectToDB( struct dbConfig db ) 
{ 

	if( !strlen( db.username ) || !strlen( db.password ) ) {
		EXEC SQL CONNECT TO :dbName ; 
	} 
	else 
	{ 
		strcpy( userId, db.username ) ; 
		strcpy( password, db.password ); 
		EXEC SQL CONNECT TO :dbName user:userId using :password ; 
	} 
	SQLError( "CONNECT", SQLCODE, &sqlca ) ;
	 return( SQLCODE ) ;
}

Could somebody tell me how to do a remote connection using Embeded SQL in C and to the database w/c is on a different server.

any help would be much appreciated

Regards,
jaro

**all the sample codes that I've found in the net are all for connection locally. I can't seem to find a "connect" in this format connect(<host>, <username>, <password>);

przytula_guy · #2 (**permalink**) 07-11-06, 10:59

local or remote - no difference
connect to db user xx using ccc
this should do in any case

dlare9 · #3 (**permalink**) 07-11-06, 11:17

Quote:

Originally Posted by przytula_guy

local or remote - no difference
connect to db user xx using ccc
this should do in any case

I'm a little bit confuse here.
correct me if I'm wrong, you mean to say that I don't need to change any of my codes?
do I need to change some of the configuration in the DB2?

***note***
I'm using MVC6 and my OS is win2k.
My database is : DB2 Universal Database Personal Edition , Version 8.1

Marcus_A · #4 (**permalink**) 07-11-06, 22:43

When using the Type 2 driver, you need to catalog the remote database on your local machine and use the database alias name as the remote database is known on the local server.

If you were using the Type 4 universal driver, then you could refer directly to the remote host-name, port number, and database name.

guyprzytula · #5 (**permalink**) 07-12-06, 01:32

the last remark is for java programming and not for C language as yours.
Yes - there is no difference for local/remote database. as long as the db is known and accessible from the station where you run the program.
just : connect to dbname user uuu using ww in any case this will do

ARWinner · #6 (**permalink**) 07-12-06, 08:06

If I remember correctly, DB2 Personal Edition does not allow remote connections.

Andy

guyprzytula · #7 (**permalink**) 07-12-06, 08:12

could you indicate the error when connecting to remote db ?
is it a pers. edition ? as the name implies = personal = no remote connection can come in as db2 does not listen on an external port.

Internet Services

Web Development

Digital Marketing

Consumer Tech