Thread: ODBC SQL connect problem

Dear Sir!
I have installed Linux Mandrake 8.3 and I have problem with the
connection to postgresDB via ODBC.
I configured .odbc.ini file and used the query_db.c source for DB
Connestion test.
The application was compiled this way:
gcc -lpsqlodbc -I/usr/include/pgsql query_db.c -o query_db

I tried the ODBCtest SW and as you can see bellow the connection was
established.

When I have executed the querry_db there has been a problem.
connection paarmeters: DSN='RHDB', UID='postgres', PWD=''
Unable to open data source (ret=-1)

Could you help me or advice some mailing list, please?

Tank you.
Gabor Gorcsos


/****************** ODBCtest ******************/
SQLAllocEnv():
  In:
    phenv: 0xbfffe1fc
  Return:
    SQL_SUCCESS=0
    *phenv: 0x81abf58

SQLAllocConnect():
  In:
    Environment Handle: 0x81abf58
    phdbc: 0xbfffe1fc
  Return:
    SQL_SUCCESS=0
    *phdbc: 0x81b1ef8

SQLConnect():
  In:
    Connection Handle: 0x81b1ef8
    Server: RHDB
    Server Len: SQL_NTS=-3
    User: postgres
    User Len: SQL_NTS=-3
    Auth: <null ptr>
    Auth Len: SQL_NTS=-3
  Return:
    SQL_SUCCESS=0
/*********************************************/


/***************** .odbc.ini *******************/
[ODBC Data Sources]
RHDB = PostgreSQL Test

[RHDB]
Driver=/usr/lib/libpsqlodbc.so
Description=Sample PostgreSQL DSN
DSN=RHDB
Servername=localhost
Username=postgres
Database=basketball
ReadOnly=No
Servertype=postgres
Port=5432
FetchBufferSize=99
ServerOptions=
ConnectOptions=
Options=
ReadOnly=no
Trace=1
TraceFile=/home/ggorcsos/odbc.trace
Debug=1
DebugFile=/home/ggorcsos/odbc.debug
CommLog=1

[Default]
Driver = /usr/lib/libpsqlodbc.so

[ODBC]
InstallDir = /usr/lib/libodbc.so
/*************************************/



/**************************************** query_db.c
************************************************/
#include <stdio.h>
#include <stdlib.h>
#include <sqlext.h>

HENV Environment;
HDBC Connection;
HSTMT Statement;

static unsigned char SelectStmt[] = {"SELECT 'Connected to:
ENG='||property('name')||', DBN='||db_property('name')"};
int main( int argc, char * argv[] )
{
    int res;
    unsigned char * connect_name = (unsigned char *)"RHDB";
    unsigned char * connect_userid = (unsigned char *)"ggorcsos";
    unsigned char * connect_password = (unsigned char *)"";
    SQLCHAR cname[256];
    SQLINTEGER cnamesize;


    if( SQLAllocEnv( &Environment ) != SQL_SUCCESS )
    {
        printf( "Unable to allocate env\n" );
        exit( 0 );
    }

    if( SQLAllocConnect( Environment, &Connection ) !=
SQL_SUCCESS )
    {
        printf( "Unable to allocate connection\n" );
        SQLFreeEnv( Environment );
        exit( 0 );
    }

    if( argc > 1 )
    {
        connect_name = (unsigned char *)argv[1];
        if( argc > 2 )
        {
            connect_userid = (unsigned char *)argv[2];
            if( argc > 3 )
            {
                connect_password = (unsigned char *)
argv[3];
            }
        }
    }


    printf( "connection parameters: DSN='%s', UID='%s', PWD='%
s'\n", connect_name, connect_userid, connect_password);

    res = SQLConnect( Connection, connect_name, SQL_NTS,
connect_userid, SQL_NTS, connect_password, SQL_NTS );
    if( res != SQL_SUCCESS )
    {
        printf( "Unable to open data source (ret=%d)\n",
res );
        exit( 0 );
    }

    if( SQLAllocStmt( Connection, &Statement ) != SQL_SUCCESS )
    {
        printf( "Unable to allocate statement\n" );
        exit( 0 );
    }

    if( SQLExecDirect( Statement, SelectStmt, SQL_NTS )    !=
SQL_SUCCESS )
    {
        printf( "Unable to execute statement\n" );
        exit( 0 );
    }

    res = SQLFetch(Statement);
    if( res != SQL_SUCCESS && res != SQL_SUCCESS_WITH_INFO )
    {
        printf( "Unable to fetch row\n" );
        exit( 0 );
    }

    if( SQLGetData(Statement, 1, SQL_C_CHAR, cname, 255,
&cnamesize) != SQL_SUCCESS)
    {
        printf( "Unable to get data\n" );
        exit( 0 );
    }

    printf( "%s\n", cname );
    SQLDisconnect( Connection );
    SQLFreeConnect( Connection );
    SQLFreeEnv( Environment );
    printf( "Done.\n" );
    return( 0 );
}
/*********************************************************************
******************************/



____________________________________
http://www.pobox.sk/ - najvacsi slovensky freemail