DB2 ODBC connectivity problem in RHEL5 32 bit

 
Thread Tools Search this Thread
Operating Systems Linux Red Hat DB2 ODBC connectivity problem in RHEL5 32 bit
# 1  
Old 04-27-2012
DB2 ODBC connectivity problem in RHEL5 32 bit

Hi,
I installed Db2 9.7 on RHEL5 32bit .
Instance Name is db2inst1 amd in that i created database as mydb.
I exported env variables for
classpath ,db2dir,db2instance
LD_LIBRARY_PATH ,PATH ,ODBC, ODBCHOME ,ODBCINI
My application needs ODBC connectivity and so I modified odbc.ini file .
Following is the configuration for the same :

[DB2_TEST]
Driver=/home/db2inst1/sqllib/lib32/libdb2.so
Description=DB2 9.7 Driver
SERVER=localhost
PORT=50000
USER=db2inst1
Password=abcd1234
Database=MYDB
OPTION=3
SOCKET=


when I execute , getting this error
isql -v db2_test db2inst1 abcd1234
[S1009][unixODBC][IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=S1009
[ISQL]ERROR: Could not SQLConnect


Kindly Help
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Problem with tar on RHEL5.8

Hi All, I have a tar file that I want to extract, I need the permissions and owners of the file to be the same as on when they were tared. I am using this command to un-tar the file. tar --acl --xattrs --same-owner --same-permissions -zvxf MANJUNATH_acl_corner_cases.tgz -C /cifs1/share1/... (7 Replies)
Discussion started by: prinsh
7 Replies

2. Linux

Unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0

Hi , I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0 I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH, ODBCINI , ODBCSYSINI etc . Getting the error as Data source name not found, and no default driver specified ERROR: Could not SQLConnect ... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies

3. Red Hat

RHEL5 - desktop problem

hi all, any one has occured below issue before? i login to RHEL 5 using user name root. howver, after logged, nothing displayed on desktop, total was empty on desktop. some more, right click mouse right button, no such options to choose. any one has this issue before? any idea to... (3 Replies)
Discussion started by: maxlee24
3 Replies

4. UNIX for Dummies Questions & Answers

java1.6 for rhel5 32 bit

where can I download java1.6 for rhel5 32 bit. find it hard to search on the net. thanks (3 Replies)
Discussion started by: lhareigh890
3 Replies

5. AIX

ODBC Connectivity between Oracle10g on AIX and Mainframe

Hi, I have a task of setting up connectivity between Oracle 10g (AIX) and Mainframe (1 library). Went through couple of documents, forums, blogs etc. MY understanding is ODBC Generic Connectivity is free from Oracle side. Question: (may be dumb to you) 1. Has anybody done this and would... (3 Replies)
Discussion started by: jvmani_1
3 Replies

6. Red Hat

vsftpd with ssl support on rhel5 64 bit

Hi Friends, I am trying to configure vsftpd server 2.0.5 on rhel5 64 bit installation. I am getting an error when initiating an ssl connection. I am using filezilla 3.0 ftp client. Client is specifically using passive mode connection. I can see the client is able to connect to the server,... (0 Replies)
Discussion started by: arumon
0 Replies

7. Red Hat

RHEL5 Kickstart NFS & DHCP Problem

I just finished setting up a Kickstart Server for our RHEL 5 installs. It's configured to use the PXE boot and NFS for the installation. Everything works fine when I just build one machine at a time. The installation works from begining to end. But when I try the install three machines at... (5 Replies)
Discussion started by: apfistler
5 Replies

8. Linux

RHEL5 Kickstart Problem... HELP!

Folks, Im hoping you guys can help me. Here is a description of what I have going on. Fresh VM, trying to run a Kickstart Install on it for RHEL5. I am looking to access the kickstart file through nfs. I boot from a local ISO image and everything goes fine, I get to the boot prompt and enter... (3 Replies)
Discussion started by: mkono
3 Replies

9. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

10. Solaris

How to check Oracle odbc connectivity in solaris ?

Hi, I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server. Please guide me how to do it in solaris env. Aru (2 Replies)
Discussion started by: aarora_98
2 Replies
Login or Register to Ask a Question
ODBC_SETOPTION(3)							 1							 ODBC_SETOPTION(3)

odbc_setoption - Adjust ODBC settings

SYNOPSIS
bool odbc_setoption (resource $id, int $function, int $option, int $param) DESCRIPTION
This function allows fiddling with the ODBC options for a particular connection or query result. It was written to help find work around to problems in quirky ODBC drivers. You should probably only use this function if you are an ODBC programmer and understand the effects the various options will have. You will certainly need a good ODBC reference to explain all the different options and values that can be used. Different driver versions support different options. Because the effects may vary depending on the ODBC driver, use of this function in scripts to be made publicly available is strongly dis- couraged. Also, some ODBC options are not available to this function because they must be set before the connection is established or the query is prepared. However, if on a particular job it can make PHP work so your boss doesn't tell you to use a commercial product, that's all that really matters. PARAMETERS
o $id - Is a connection id or result id on which to change the settings. For SQLSetConnectOption(), this is a connection id. For SQLSet- StmtOption(), this is a result id. o $function - Is the ODBC function to use. The value should be 1 for SQLSetConnectOption() and 2 for SQLSetStmtOption(). o $option - The option to set. o $param - The value for the given $option. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 odbc_setoption(3) examples <?php // 1. Option 102 of SQLSetConnectOption() is SQL_AUTOCOMMIT. // Value 1 of SQL_AUTOCOMMIT is SQL_AUTOCOMMIT_ON. // This example has the same effect as // odbc_autocommit($conn, true); odbc_setoption($conn, 1, 102, 1); // 2. Option 0 of SQLSetStmtOption() is SQL_QUERY_TIMEOUT. // This example sets the query to timeout after 30 seconds. $result = odbc_prepare($conn, $sql); odbc_setoption($result, 2, 0, 30); odbc_execute($result); ?> PHP Documentation Group ODBC_SETOPTION(3)