Driver could not be loaded (0) SQLSTATE=IM002

From: Srimathi Chandrasekaran <Srimathi(dot)Chandrasekaran(at)mailbox(dot)tu-dresden(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Driver could not be loaded (0) SQLSTATE=IM002
Date: 2006-04-25 12:10:47
Message-ID: 1145967047.444e11c7882f6@rmc60-231.urz.tu-dresden.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Ludek Finstrle 2006-04-25 12:30:18 Re: Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver
Previous Message Ludek Finstrle 2006-04-25 10:37:03 Re: odbc 8.01.02 8190 bytes limitation