Missing server name, port,ordatabase name in call to CC_connect

Missing server name, port,ordatabase name in call to CC_connect

am 30.04.2006 12:00:31 von Srimathi Chandrasekaran

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 corr=
ect.
env | grep ODBC
ODBCINIDIR=3D/usr/local/globus-4.0.1/var
ODBCINI=3D/usr/local/globus-4.0.1/var/odbc.ini
GLOBUS_IODBC_PATH=3D/usr/local/globus-4.0.1
2. i have made the trace and debug file in my odbc.ini.I am herewith att=
aching
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_SUC=
CESS)
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_SUCC=
ESS)
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_SUC=
CESS)
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=3Dlrc1000;UID=3Ddbuser;PWD=3D =
|
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.

=20

ite17139:/ # $GLOBUS_IODBC_PATH/bin/iodbctest "DSN=3Dlrc1000;UID=3Ddbuser=
;PWD=3D"
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, p=
ort,
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, p=
ort,
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, p=
ort,
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, p=
ort,
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, p=
ort,
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, p=
ort,
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









---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq