Login or Register to Ask a Question and Join Our Community


Red Hat

DB2 ODBC connectivity problem in RHEL5 32 bit

Login to Discuss or Reply to this Discussion in Our Community

 
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

LEARN ABOUT DEBIAN

dbix::class::storage::dbi::odbc::access

DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)		User Contributed Perl Documentation	      DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)

NAME

       DBIx::Class::Storage::DBI::ODBC::ACCESS - Support specific to MS Access over ODBC

DESCRIPTION

       This class implements support specific to Microsoft Access over ODBC.

       It is a subclass of DBIx::Class::Storage::DBI::ODBC and DBIx::Class::Storage::DBI::ACCESS, see those classes for more information.

       It is loaded automatically by by DBIx::Class::Storage::DBI::ODBC when it detects a MS Access back-end.

       This driver implements workarounds for "IMAGE" and "MEMO" columns, and DBIx::Class::InflateColumn::DateTime support for "DATETIME" columns.

EXAMPLE DSN

	 dbi:ODBC:driver={Microsoft Access Driver (*.mdb, *.accdb)};dbq=C:Users
kitoverDocumentsaccess_sample.accdb

TEXT
/IMAGE/MEMO COLUMNS
       Avoid using "TEXT" columns as they will be truncated to 255 bytes. Some other drivers (like ADO) will automatically convert "TEXT" columns
       to "MEMO", but the ODBC driver does not.

       "IMAGE" columns work correctly, but the statements for inserting or updating an "IMAGE" column will not be cached, due to a bug in the
       Access ODBC driver.

       "MEMO" columns work correctly as well, but you must take care to set LongReadLen to "$max_memo_size * 2 + 1". This is done for you
       automatically if you pass LongReadLen in your connect_info; but if you set this attribute directly on the $dbh, keep this limitation in
       mind.

AUTHOR

       See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.14.2							    2011-05-10			      DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)