... - Mailing list pgsql-odbc
From | Srimathi Chandrasekaran |
---|---|
Subject | ... |
Date | |
Msg-id | 1146391117.44548a4d70308@rmc60-231.urz.tu-dresden.de Whole thread Raw |
List | 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
pgsql-odbc by date: