Driver could not be loaded (0) SQLSTATE=IM002 - Mailing list pgsql-odbc

From Srimathi Chandrasekaran
Subject Driver could not be loaded (0) SQLSTATE=IM002
Date
Msg-id 1145967047.444e11c7882f6@rmc60-231.urz.tu-dresden.de
Whole thread Raw
Responses Re: Driver could not be loaded (0) SQLSTATE=IM002  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
hi
i am using the following versions for building rls server against
gLobustollkit4.0

psqlodbc-07.03.0200
postgresql-8.0.1
libiodbc-3.52.4
I want to know whether my installation was correct.
1.I have set the environmental varaibles as follows
setenv GLOBUS_LOCATION0/usr/local/globus-4.0.1
# setenv GLOBUS_IODBC_PATH $GLOBUS_LOCATION
# setenv ODBCINI $GLOBUS_LOCATION/var/odbc.ini
 2. for libiodbc-3.52.4
I have done everything as a root

% ./configure --prefix=$GLOBUS_IODBC_PATH --disable-gtktest --with-pthreads
--disable-gui --with-iodbc-inidir=$ODBCINIDIR (i have set ODBCINDIR variable
also)
make
make install
everything is successfully built.
2. i have created odbc.ini in  $GLOBUS_LOCATION/var and copied that to
odbcinst.ini which is in the same directory itself
and my odbc.ini file looks like this
odbc.ini

[ODBC Data Sources]
 lrc1000=lrc database
 rli1000=rli database

 [lrc1000]
 Description  = LRC database
 DSN          = lrc1000
 Driver       =/usr/local/globus-4.0.1/lib/psqlodbc.so
 Servertype   = postgres
 SERVER       = localhost
 USER         = dbuser
 Password     =
 Database     = lrc1000
 OPTION       = 3
 Trace        = off
   port        =5432

 [rli1000]
 Description  = RLI database
 DSN          = rli1000
 Driver       = /usr/local/globus-4.0.1/lib/psqlodbc.so

 Servertype   = postgres
 SERVER       = localhost
 USER         = dbuser
 Password     =
 Database     = rli1000
 OPTION       = 3
 Trace        = off

  port=5432



[Default]
Driver=/usr/local/globus-4.0.1/lib/psqlodbc.so
port=5432
3.i have installed postgresql
./configure --prefix=$GLOBUS_LOCATION--without readline(if i didnt give this
--without readline then it wasnot  able to configure)
make
make install
this was built sucessfully
chown -R postgres:postgres /usr/local/globus-4.0.1
 su - postgres



cd /usr/local/globus-4.0.1
bin/initdb -D ./data
bin/pg_ctl -D ./data -l data/logfile start
bin/createuser
bin/createdb -O dbuser  -U dbuser  -W lrc1000
bin/createdb -O dbuser  -U dbuser  -W rli1000
bin/psql -l
it also listed the databases whatever i have
then i created the database schema by using the commands
psql -W -U dbuser  -d lrc1000  -f
$GLOBUS_LOCATION/setup/globus/globus-rls-lrc-postgres.sql
psql -W -U dbuser  -d rli1000  -f
$GLOBUS_LOCATION/setup/globus/globus-rls-rli-postgres.sql

4. i have installed psqlODBC
./configure --prefix=$GLOBUS_LOCATION--enable threads
make
make install
this was installed properly


But when i run the iodbctest
$GLOBUS_IODBC_PATH/bin/iodbctest "DSN=lrc1000;UID=dbuser;PWD="
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no
default driver specified. Driver could not be loaded (0) SQLSTATE=IM002
1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no
default driver specified. Driver could not be loaded (0) SQLSTATE=IM002
i have gone through email archive but i couldn't get much of it
i am having sleepless nights because of this.
whether anybody can tell me whether my installa tion procedure  is correct?
IF u have any rough idea on what direction i proceed it will be great help to
me.
thanks for your time and consideration
cheers
srimathi.c

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: odbc 8.01.02 8190 bytes limitation
Next
From: Ludek Finstrle
Date:
Subject: Re: Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver