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
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 |