Can you show us your code? Which call is getting the error? Which build number (of the ODBC driver) are you using? What bitness are you using - 32 or 64?

;; This buffer is for notes you don't want to save, and for Lisp evaluation. ;; If you want to create a file, visit that file with C-x C-f, ;; then enter the text in that file's own buffer.

Hi , My code is below:

static void
odbcGetTableSize(char *svr_dsn, char *svr_database, char *svr_schema, char *svr_table,
                 char *username, char *password, char *sql_count, unsigned int *size)
{
    SQLHENV env;
    SQLHDBC dbc;
    SQLHSTMT stmt;
    SQLRETURN ret;

StringInfoData      conn_str;
    StringInfoData      sql_str;
    SQLCHAR OutConnStr[1024];
    SQLSMALLINT OutConnStrLen;

SQLUBIGINT table_size;
    SQLLEN indicator;

StringInfoData name_qualifier_char;
    StringInfoData quote_char;

/* Construct connection string */
    initStringInfo(&conn_str);
    if (svr_database != NULL)
        appendStringInfo(&conn_str, "DSN=%s;DATABASE=%s;UID=%s;PWD=%s;", svr_dsn, svr_database, username, password);
    else
        appendStringInfo(&conn_str, "DSN=%s;UID=%s;PWD=%s;", svr_dsn, username, password);
#ifdef DEBUG
    elog(DEBUG4, "odbc_fdw::odbcGetTableSize: Connection string: %s", conn_str.data);
#endif
    /* Allocate an environment handle */
    SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    /* We want ODBC 3 support */
    SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void *) SQL_OV_ODBC3, 0);
    /* Allocate a connection handle */
    SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);

/* Connect to the DSN */
    ret = SQLDriverConnect(dbc, NULL, (SQLCHAR *) conn_str.data, SQL_NTS,
                           OutConnStr, 1024, &OutConnStrLen, SQL_DRIVER_COMPLETE);

....
}

It fails in - SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env); Am working on 32 bit. And the ODBC driver is the one which came along with sqlanywhere16 installation . My Linux distro is - Red Hat Enterprise Linux Server release 5 (Tikanga).

Also, If you could tell me the procedure to run the sample programs given in path - sdk/dbcapi/examples/ in linux, it would be very helpful. My attempt to compilation with this command - gcc -I/home/vaish/sqlanywhere16/sdk/include/ -I/usr/include/ -L/usr/local/lib/ -L/usr/lib/ -Llibdl.so connecting.cpp -o connecting

failed with below errors:

/tmp/ccXZBXeJ.o: In function `main':
connecting.cpp:(.text+0x26): undefined reference to `sqlany_initialize_interface(SQLAnywhereInterface*, char const*)'
connecting.cpp:(.text+0x8f): undefined reference to `sqlany_finalize_interface(SQLAnywhereInterface*)'
connecting.cpp:(.text+0x142): undefined reference to `sqlany_finalize_interface(SQLAnywhereInterface*)'
/tmp/ccXZBXeJ.o:(.eh_frame+0x11): undefined reference to `__gxx_personality_v0'
collect2: ld returned 1 exit status

Thanks , Vaish

Hi, Basically I need to connect to sybase database in Linux via C programming in linux. I searched on the net and found only tutorial for programming in windows environment/C++ programming. So , If there is any good documentation on connecting sybase in linux C programming , plz share me the link. It will be of great help. Thanks, Vaish