thanks! I checked and they have the same collation seetings. I looked into the sp_helpuser code and then realized that the one in sql server 2005 returns 7 columns but the one in sql server 2000 returns 6. My application expects 6 columns and gets the error with sql server 2005.

Hi, my VC++ 6.0 application calls my check_user_sp stored procedure that calls the sys.sp_helpuser system stored procedure: ----- CREATE PROCEDURE check_user_sp @inp_user VARCHAR(20) AS EXEC sp_helpuser @inp_user ----- I have no problem running the application against database on the 2000 sql server(2000 - 8.00.760), but I get 'Invalid character value for cast specification' error with the same database on the 2005 sql server(2005 - 9.00.1399.06). the sp_helpuser is dated 1996/08/14 10:33 on both 2000 and 2005 server, and I don't get error when exec my get_user_sp in the 2005 sql server management studio. what is 2005 sql server doing to cause this? THANKING FOR YOUR HELP!

Thank you cmk !

to make the nextBuf and workBuf in the following code multi-thread save, is it correct to replace "static" with "__declspec(thread)" in the code? or it should be "__declspec(thread) static" ? THANKS FOR THE HELP! ------ static int nextBuf ; static char workBuf[8][64] ; char * GetBuf() { nextBuf++ ; if( nextBuf >= 8 ) nextBuf = 0 ; return workBuf[nextBuf] ; }

Thanks! and, how to set the tooltip to the CEdit text? hope there's a sample code showing it.

Hi, if the the text line is longer than the CEdit control, how to do this: when pointing mouse over the control, the whole line is shown in a tip like rectangle (like when pointing to an item in a listControl, the whole item text is displayed in a rectangle) ? Thanks!

Hi, I get lastError code = 12003 when trying GetFile() as follows- Could you tell me what is the error for this code and how to fix it. Thanks !! --my code (vc__6.0): CInternetSession sess( _T("mysite"), 1, PRE_CONFIG_INTERNET_ACCESS); CFtpConnection* pConnect = NULL ; sess.GetFtpConnection( _T("ftp.mysite.com") , _T("me") , _T("pwd") ) ;} if( ! pConnect->GetFile( _T("bcu.txt") , _T("c:\\tou.txt") , FALSE ) ) { DWORD dw = GetLastError(); }

Hi, is there sample code to kill or shutdown another mfc dialog application (.exe) from an mfc application ? THANKS !

Hi, is there sample code to stop another mfc dialog application (.exe) from an mfc application ? THANKS !

Hi, I want to use VC++ (6.0) to create an excel file, add rows, and set each column to a certain width so that when the file opens the data are in decent display. Could you give me some code sample or application sample to do this? Appreciate your time and help!