From: Srimathi Chandrasekaran <Srimathi(dot)Chandrasekaran(at)mailbox(dot)tu-dresden(dot)de>
To: Ludek Finstrle <luf(at)pzkagis(dot)cz>, pgsql-odbc(at)postgresql(dot)org
Subject:
Date: 2006-04-30 09:58:37
Message-ID: 1146391117.44548a4d70308@rmc60-231.urz.tu-dresden.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Hi luf

I am using the libiodbc-3.52.4.tar.gz,postgresql-8.0.1.tar.gz and
psqlodbc-07.03.0200.tar.gz
1.i have used the env | grep ODBC' and checked the env variables are correct.
env | grep ODBC
ODBCINIDIR=/usr/local/globus-4.0.1/var
ODBCINI=/usr/local/globus-4.0.1/var/odbc.ini
GLOBUS_IODBC_PATH=/usr/local/globus-4.0.1
2. i have made the trace and debug file in my odbc.ini.I am herewith attaching
the trace file
** iODBC Trace file
** Trace started on Sun Apr 30 11:02:10 2006
** Driver Manager: 03.52.0406.0126

[000000.000344]
iodbctest 00000000 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x80836e0

[000000.000432]
iodbctest 00000000 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x80836e0 (0x8085de8)

[000000.000494]
iodbctest 00000000 ENTER SQLSetEnvAttr
SQLHENV 0x8085de8
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)

[000000.000567]
iodbctest 00000000 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x8085de8
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)

[000000.000634]
iodbctest 00000000 ENTER SQLAllocHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x8085de8
SQLHANDLE * 0x80836dc

[000000.000693]
iodbctest 00000000 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x8085de8
SQLHANDLE * 0x80836dc (0x80867d0)

[000000.000752]
iodbctest 00000000 ENTER SQLSetConnectOption
SQLHDBC 0x80867d0
SQLUSMALLINT 1051 (unknown connection attribute)
SQLLEN 134707501

[000000.000818]
iodbctest 00000000 EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
SQLHDBC 0x80867d0
SQLUSMALLINT 1051 (unknown connection attribute)
SQLLEN 134707501

[000000.000878]
iodbctest 00000000 ENTER SQLGetInfo
SQLHDBC 0x80867d0
SQLUSMALLINT 171 (SQL_DM_VER)
SQLPOINTER 0xbfffebc0
SQLSMALLINT 255
SQLSMALLINT * 0xbfffe9be

[000000.000976]
iodbctest 00000000 EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
SQLHDBC 0x80867d0
SQLUSMALLINT 171 (SQL_DM_VER)
SQLPOINTER 0xbfffebc0
| 03.52.0406.0126 |
SQLSMALLINT 255
SQLSMALLINT * 0xbfffe9be (15)

[000000.001082]
iodbctest 00000000 ENTER SQLDriverConnect
SQLHDBC 0x80867d0
SQLPOINTER 0x0
SQLCHAR * 0xbfffedf0
| DSN=lrc1000;UID=dbuser;PWD= |
SQLSMALLINT -3 (SQL_NTS)
SQLCHAR * 0x8083780
SQLSMALLINT 4096
SQLSMALLINT * 0xbfffe9ba
SQLUSMALLINT 1 (SQL_DRIVER_COMPLETE)
3.
MY output of iodbctest i am really not getting the interacive sql prompt.

ite17139:/ # $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.ite17139:/ #
4. WHENI am to building the rls server #

ANd when i run rls server i am getting following output
2006-04-30 10:34:25 T1078464160: startthread: id 1089199024 num 1
2006-04-30 10:34:25 T1078464160: startthread: id 1091300272 num 2
2006-04-30 10:34:25 T1078464160: startthread: id 1093401520 num 3
2006-04-30 10:34:25 T1078464160: lrc_init: lrc1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open: lrc1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open(lrc1000): Missing server name, port,
or
database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: lrc_init(lrc1000): Missing server name, port,
or database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: rli_init: rli1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open: rli1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open(rli1000): Missing server name, port,
or
database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: readsender(rli1000): Missing server name,
port,
or database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: usage_send:
2006-04-30 10:34:25 T1078464160: lrc_init: lrc1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open: lrc1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open(lrc1000): Missing server name, port,
or
database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: lrc_init(lrc1000): Missing server name, port,
or database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: rli_init: rli1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open: rli1000 dbuser
2006-04-30 10:34:25 T1078464160: db_open(rli1000): Missing server name, port,
or
database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: readsender(rli1000): Missing server name,
port,
or database name in call to CC_connect.
2006-04-30 10:34:25 T1078464160: usage_send:
2006-04-30 10:34:43 T1078464160: lrc_init: lrc1000 dbuser
2006-04-30 10:34:43 T1078464160: db_open: lrc1000 dbuser
2006-04-30 10:34:43 T1078464160: db_open(lrc1000): Missing server name, port,
or
database name in call to CC_connect.
2006-04-30 10:34:43 T1078464160: lrc_init(lrc1000): Missing server name, port,
or database name in call to CC_connect.
2006-04-30 10:34:43 T1078464160: rli_init: rli1000 dbuser
2006-04-30 10:34:43 T1078464160: db_open: rli1000 dbuser
2006-04-30 10:34:43 T1078464160: db_open(rli1000): Missing server name, port,
or
database name in call to CC_connect.
2006-04-30 10:34:43 T1078464160: readsender(rli1000): Missing server name,
port,
or database name in call to CC_connect.
Thanks in advance
Regards
srimathi.c

Browse pgsql-odbc by date

  From Date Subject
Next Message Srimathi Chandrasekaran 2006-04-30 10:00:31 Missing server name, port,ordatabase name in call to CC_connect
Previous Message noreply 2006-04-28 14:38:56 [ psqlodbc-Bugs-1000586 ] Confusing to download current version