Missing server name, port,ordatabase name in call to CC_connect - Mailing list pgsql-odbc

From Srimathi Chandrasekaran
Subject Missing server name, port,ordatabase name in call to CC_connect
Date
Msg-id 1146391231.44548abf7a6b4@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:

Previous
From: Srimathi Chandrasekaran
Date:
Subject: ...
Next
From: Hendrik Koch
Date:
Subject: Mac OS X ODBC Driver - compile errors - need help