Very Computer

1. weird odbc error

Hi,

I have a fairly simple routine which retrieves a single field. But this
routine will fail after being called exactly 160 times !!!

char* getLastName(char* pId)
{

    char* pRetVal = new char(51);
    char Statement[255];
    sprintf(Statement, "SELECT last_name FROM namemaster WHERE id='%'",
pId);

    SQLINTEGER fieldLenOrInd = SQL_NTS;
    SQLBindCol(m_hStmt, 1, SQL_C_CHAR, pRetVal, 51, &fieldLenOrInd);

    SQLRETURN retcode = SQLExecDirect(m_hStmt, (unsigned char*)&Statement,
SQL_NTS);

    retcode = SQLFetch(m_hStmt);

    SQLCloseCursor(m_hStmt);

    return pRetVal;

For simplicity I removed all error handling, etc. It took me two days to
figure out why. But I haven't got any clue.

Please help if you know anything about it. I am using SQL Server 7.0 and
ODBC 3.510.3513.

Thanks a bounch!

Philip

2. Vague Informix Error

3. Weird ODBC error?

4. JDBC for SQL Server 2000 from M$, this JDBC is not for international users, no encoding can somewhere be added

5. Weird ODBC error with Access95/VB5/SQL Server 6.5

6. bcp return status

7. Weird ODBC error

8. Report Format Question

9. key group locked error, weird TDBEdit focus error

10. Please help me solve this weird ODBC Connection Problem

11. weird ODBC+SQLServer 7.0 problem

12. Help with weird fetch delay from SS7 via ODBC

13. A weird ODBC+SQL Server 7.0 problem