Re: [Iodbc-list] problem with iodbc test

[Srimathi C. <Sri...@ma...>]

hi tim 
i have tried using 
$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

Have a nice day.
It immedately throws me to the $ prompt.
What may be the problem
regards
srimathi.c






Quoting Tim Haynes <th...@op...>:

> 
> On 25 Apr 2006, at 16:54, Srimathi Chandrasekaran wrote:
> 
> > hi
> > I am using suse linux 9.3
> 
> OK
> 
> > I have modified By odbcinst.ini also as You have suggested
> > I have cleared the problem of Driver could not be loaded (0)  
> > SQLSTATE=IM002.
> > The mistake was my odbc.ini was with some empty spaces after the  
> > starting of
> > ODBC data sources.
> 
> Interesting - I'll have a look into that.
> 
> > I have cleared all the empty spaces and it is working But it is   
> > not going to
> > sql prompt
> > $GLOBUS_LOCATION/bin/iodbctest
> > iODBC Demonstration program
> > This program shows an interactive SQL processor
> > Driver Manager: 03.52.0406.0126
> >
> > Enter ODBC connect string (? shows list): ?
> >
> > DSN                              | Driver
> > ---------------------------------------------------------------------- 
> > --------
> > lrc1000                          | lrc database
> > rli1000                          | rli database
> >
> > Enter ODBC connect string (? shows list): rli1000
> >
> > Have a nice day.it goes to $ prompt
> > then i am not getting the SQL prompt.
> 
> That is not an ODBC connect string; you were right first time with  
> something like `DSN=rlil1000;UID=dbuser;PWD='.
> 
> > MY odbcinst.ini looks like this.
> > [ODBC Data Sources]
> > lrc1000=lrc database
> > rli1000=rli database
> > [lrc1000]
> > Driver       =/usr/local/globus-4.0.1/lib/psqlodbc.so
> > Setup        =/usr/local/globus-4.0.1/lib/psqlodbc.so
> > [rli1000]
> > Driver       = /usr/local/globus-4.0.1/lib/psqlodbc.so
> > Setup        = /usr/local/globus-4.0.1/lib/psqlodbc.so
> 
> That looks better, but I think you'd benefit from a blank line before  
> each of the sections ([).
> 
> Regards,
> 
> ~Tim
> -- 
> Tim Haynes
> Product Development Consultant
> OpenLink Software
> <http://www.openlinksw.com/>
> 
>