ODBC connect error. Help!!!

Hordi

New Member
Hi,

I have this error while connecting with database. Where problem - I don't known. Please, help.

[DataDirect-Technologies][ODBC 20101 driver][20101]Internal error %s (%s) in SQL from subsystem %s function %s called from %s



//--main.cpp----------------------------------------------------------start----

#include <sql.h>
#include <sqlext.h>
#include <stdio.h>

static bool check_error(SQLRETURN res,SQLHANDLE h)
{
if( (res != SQL_SUCCESS) && (res != SQL_SUCCESS_WITH_INFO) ){
SQLCHAR pStatus[32], pMsg[128];
SQLINTEGER SQLerr;
SQLSMALLINT SQLmsglen;
int i=1;
while( SQLGetDiagRec(SQL_HANDLE_DBC, h,i,pStatus,&SQLerr,pMsg,sizeof(pMsg)-1,&SQLmsglen)!=SQL_NO_DATA){
fprintf(stderr,"%s (%d)\n",pMsg,res);
++i;
}
return false;
}
return true;
}

int main(int argc, char **argv)
{
SQLHANDLE hEnv, hDbc;

SQLRETURN res = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hEnv);
if( !SQL_SUCCEEDED(res) ) return -1;

res = SQLSetEnvAttr(hEnv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
if( !SQL_SUCCEEDED(res) ){
SQLFreeHandle(SQL_HANDLE_ENV, hEnv);
return -1;
}

res = SQLAllocHandle(SQL_HANDLE_DBC, hEnv, &hDbc);
if( !SQL_SUCCEEDED(res) ){
SQLFreeHandle(SQL_HANDLE_ENV, hEnv);
return -1;
}

res = SQLConnect(hDbc,
(SQLCHAR*)"results", SQL_NTS,
(SQLCHAR*)"1", SQL_NTS,
(SQLCHAR*)"111", SQL_NTS);

if(check_error(res,hDbc)){
}
SQLDisconnect(hDbc);

SQLFreeHandle(SQL_HANDLE_DBC, hDbc);
SQLFreeHandle(SQL_HANDLE_ENV, hEnv);

return 0;
}

//--main.cpp------------------------------------------------------end--------------


------odbc.ini------------------------------------------------------------------

[ODBC Data Sources]
results=Progress_SQL92_Driver

[results]
Driver=/usr/dlc91/odbc/lib/pgpro915.so
DatabaseName=etalon_srv
PortNumber=2055
HostName=localhost
LogonID=1
Password=111
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultIsolationLevel=REPEATABLE READ
#LogonID=ccall
StaticCursorLongColBuffLen=4096

[ODBC]
InstallDir=/usr/dlc91/odbc
Trace=1
TraceFile=odbctrace.out
TraceDll=/usr/dlc91/odbc/lib/odbctrac.so
UseCursorLib=0

------odbc.ini------------------------------------------------------------------

thanks
 
Back
Top