not very sure abt this.. bt i guess that if u wanna arrive at 251 ie. -5 (sign extended), u gotta use short int or int instead of unsigned int. hope this helps

thx a lot!! kudos..

yeah.. there r more operations that r to be performed on this temp table.. modifications, etc.. but i got to get this running b4 i put in the other stmts... SOS!!

trying to execute this stored procedure using a prg that connects to the server using an ODBC DSN. it doesnot retrieve the result set. CREATE PROCEDURE PROC_1 AS CREATE TABLE #abc ( ssn char(30) ) insert into #abc(ssn) select phone from tbl_users select * from #abc GO when executed directly, ie. say, Query Analyser or Excel, there r no probs encountered. also, when i remove the create n insert stmts, n change the #abc to a table abc, am getting the results. Thanks..

try calling GetShortPathName before the create file function..

using the function AcceptSecurityContext for authentication. But the fn returns error when trying to authenticate on a virtual machine. SEC_E_NO_AUTHENTICATING_AUTHORITY No authority could be contacted for authentication. This could be due to the domain name of the authenticating party being wrong, the domain being unreachable, or to a trust relationship failure. in case of virtual machines, is there one more level involved? thanks

need a win32 api that authenticates a windows NT user or the like... pl post any links for the same.. thanks..

need to make a dsn less connection to a file whose path is known. my present code connects to dsn.. m_retcode = SQLAllocHandle(SQL_HANDLE_DBC, m_henv, &m_hdbc); m_retcode = SQLDriverConnect(m_hdbc, NULL, (unsigned char *)pConString, SQL_NTS, NULL, 0, &m_constrout, SQL_DRIVER_NOPROMPT); what should the parameters be now? thanks apoorva

Select a.*, b.* from Customers a,(Select OrderID,Orderdate,CustomerID from Orders) b where a.CustomerID = b.CustomerID facing a prob while modifying this one through my program.. the code seems right.. not v good with sql.. is the syntax of this query correct?

Thanks a lot for ur reply szSQL is a character array declared as char szSQL[1024]={0}; i have tried both the option but not much improvement in the memory accumulation. i suppose the problem is with SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle),it does not free the full memory which is been allcated by rc = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&EnvHandle).

hi This is Apoorva raje.I am facing a problem with SqlExecuteDirect() function, my piece of code is doing deleting all the recods from 12 different table and then insert new records in those tables. each table will have approximate 100 to 1,00,000 records .For deletion i copy the query into a char array and then first allocate a statement handle execute it by SqlExecuteDirect()function and then free the statement handle but even we are freeing the statement handle the memory is not freed and its accumulating around 12mb. the code is given below: //delete ARCDataSet //Same code for deleting data for 12 other tables rc = SQLAllocHandle(SQL_HANDLE_STMT,ConHandle,&StmtHandle); memset(szSQL,0,1024); sprintf(szSQL,"delete from ARCDataSet"); rc = SQLExecDirect(StmtHandle,(SQLCHAR*)szSQL,strlen(szSQL)); rc = SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle); // rc = SQLAllocHandle(SQL_HANDLE_STMT,ConHandle,&StmtHandle); memset(szSQL,0,1024); int m_Dsq =0; m_Dsq = atoi(((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb->m_chDSQ ); sprintf(szSQL,"INSERT INTO ARCDS (ARCDSQ,DBServer,DBSuperUser,DBSuPwd,DBSignature,DBComments,nDsq,noCats,noTabs,noCols,noSTC,noScopes,noDataSets,noEntrances,noEntSets,noPermits) values (\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',%d ,%d , %d, %d,%d ,%d , %d,%d ,%d, %d );" rc = SQLExecDirect(StmtHandle,(SQLCHAR*)szSQL,strlen(szSQL)); rc = SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle); // 3.1 end parameters writing into ARCDS ------------------ user details start ------------------------------------*/ // 3.2 begin Isert into Security db , user details rc = SQLAllocHandle(SQL_HANDLE_STMT,ConHandle,&StmtHandle); unsigned int nUsq = ((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb->m_noUsers; int iVal=0; for ( int nIdx = 0; nIdx < 35000 ; nIdx++) { iVal=0; memset(szSQL,0,1024); sprintf(szSQL,"insert into ARCdstc (type,dstcSeq,ARCdstcName) values (\'%s\',%d,\'%s\')", chType, ((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb-mp_arcTables[nIdx]->tsq , ((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb->mp_arcTables[nIdx]->tableName ); rc = SQLExecDirect(StmtHandle,(SQLCHAR*)szSQL,strlen(szSQL)); } rc = SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle); // 3.2 end Isert into Security db , user details //Same code to insert data into 10 other different tables. Thanks in advance , i will be thankfull to all.

tried that already.. not working.. thanks anyways.. :-)

my code splits a large chunk of folders and files into multiple disks. every file is read in binary mode and written in a disk using fopen(), fgetc(), fputc() till its capacity is exceeded. the code also integrates the disks into one. now every kind of file is running smoothly (.exe .txt etc) except .cab files. it says the xyz.cab file is corrupt. what cud be the prob? thx

need to design a server & intercept info in the dll to interact with a database. is there a way to do that? for instance, where can i trap packets sent by a web user to the server? any modification in the dll required? how can we get the session id of web client from server end?

need to design a server & intercept info in the dll to interact with a database. is there a way to do that? for instance, where can i trap packets sent by a web user to the server? any modification in the dll required?