Hi All I am using "Select @@basedir" command to get installation path of mysql.

MYSQL_RES *res;

stt="select @@basedir;"

mysql_query(conn, strp)
res = mysql_store_result(conn) ;

How can i get result in CString.

Hi All How can i get MSSQL Installation path?There is any command Plz help me

Thanks for reply. Can you give me idea to solve that problem?

Hi how can i chane VARIANT to CString?

VARIANT var=pRange->GetValue();
CString strp;
str=CString(var.bstrVal);

some time i got exception

Unhandled exception at 0x7c80a30a in test.exe: 0xC0000005: Access violation reading location 0x001e2000.

Call stack show

test.exe!ATL::ChTraitsCRT<char>::GetBaseTypeLength(const wchar_t * pszSource=0x001e1f98) Line 284 + 0x1e bytes C++

in cstring.h class pointing

static int __cdecl GetBaseTypeLength( _In_z_ LPCWSTR pszSource ) throw()
{
// Returns required buffer length in XCHARs
return ::WideCharToMultiByte( _AtlGetConversionACP(), 0, pszSource, -1, NULL, 0, NULL, NULL )-1;
}

Can any one tell me region behind of exception. Plz help me

Hi Can i get column name from excel?

thanks for reply .I know that change the extension by using as Save As option.But how it is possible through code.

Please help me some one..

Hi All Can i save change excel *.xls to *.xlsx?

you can always specify the precision you want to keep

yes i am converting double to Cstring(CSting str.formate("%.4f",double)). But i want to convert same values like if double tr=98.29982355 then i want to convert Cstring str=98.29982355 and when tr=9.89 then str=9.89. So i think if i have a length of double then it's make to easy. Any way there is any more option to convert double to CString. Plz help me

Thanks for reply. i use your code.It's return always 8.

double tr=111.989877445678;
int lenght = sizeof(tr);
result is length=8;

Hi All Can i get double length?I have a variable double l=111.98987744,so can i get

l length

Plz help me.

i try it but i have got error.

error LNK2001: unresolved external symbol "private: static class xlw::XlfOperImpl * xlw::XlfOperImpl::instance_" (?instance_@XlfOperImpl@xlw@@0PAV12@A)
error LNK2001: unresolved external symbol "public: double __thiscall xlw::XlfOper::AsDouble(int *)const " (?AsDouble@XlfOper@xlw@@QBENPAH@Z)
error LNK2001: unresolved external symbol "private: int __thiscall xlw::XlfOper4::Allocate(void)" (?Allocate@XlfOper4@xlw@@AAEHXZ)
error LNK2001: unresolved external symbol "public: class xlw::XlfOper4 & __thiscall xlw::XlfOper4::Set(char const *)" (?Set@XlfOper4@xlw@@QAEAAV12@PBD@Z)
error LNK2001: unresolved external symbol "public: class xlw::XlfOper4 & __thiscall xlw::XlfOper4::Set(class xlw::CellMatrix const &)" (?Set@XlfOper4@xlw@@QAEAAV12@ABVCellMatrix@2@@Z)
error LNK2001: unresolved external symbol "public: __thiscall xlw::XlfOper4::~XlfOper4(void)" (??1XlfOper4@xlw@@QAE@XZ)
error LNK2001: unresolved external symbol "public: class xlw::XlfOper4 & __thiscall xlw::XlfOper4::SetError(unsigned short)" (?SetError@XlfOper4@xlw@@QAEAAV12@G@Z)
error LNK2001: unresolved external symbol "private: int __thiscall xlw::XlfOper12::Allocate(void)" (?Allocate@XlfOper12@xlw@@AAEHXZ)
error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::Set(char const *)" (?Set@XlfOper12@xlw@@QAEAAV12@PBD@Z)
error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::Set(class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> > const &)" (?Set@XlfOper12@xlw@@QAEAAV12@ABV?$basic_string@_WU?$char_traits@_W@std@@V?$allocator@_W@2@@std@@@Z)
error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::Set(class xlw::CellMatrix const &)" (?Set@XlfOper12@xlw@@QAEAAV12@ABVCellMatrix@2@@Z)
error LNK2001: unresolved external symbol "public: __thiscall xlw::XlfOper12::~XlfOper12(void)" (??1XlfOper12@xlw@@QAE@XZ)
error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::SetError(unsigned short)" (?SetError@XlfOper12@xlw@@QAEAAV12@G@Z)
error LNK2001: unresolved external symbol "public: static class xlw::XlfExcel & __cdecl xlw::XlfExcel::Instance(void)" (?Instance@XlfExcel@xlw@@SAAAV12@XZ)
error LNK2001: unresolved external symbol "public: class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<

Thanks for responce. Have you tried XLW? Is that not working as well? No i havn't tried.Can you tell me how can i use XLW.

yes it's working but when i write more than 50thousend rows in sheets(more than one sheet) then it's showing error.

Unhandled exception at 0x7c812a6b in Excel.exe: Microsoft C++ exception: CMemoryException at memory location 0x0237e2b4..
In dbgheap.c line pvBlk = _heap_alloc_dbg_impl(nSize, nBlockUse, szFileName, nLine, errno_tmp);

Can you give me tips for that?

Hi All How can i copy excel sheet?I have a two excel file(ExcelSource.xls and ExcelDes.xls).ExcelDes.xls have allready two sheet(Sheet1 and Sheet2).Now i try to copy sheet1 from ExcelSource.xls to ExcelDes.xls in sheet3. Plz give me tips. Thanks in Advance.

Hi all How can i convert CString to long.I am try this

CString Content="000995688787";
int newintval=atoi(Content);
result is
newintval=225212472
and
__int64 n64Tmp=_atoi64(Content);
result is
n64Tmp=225212472

Hi All I am able to connect mysql through ODBC.But i want to know there is any method to connect Mysql without Odbc? Plz help me

you can change access of usb device through registry. Registry path [code] LOCAL_MACHINE, "SYSTEM\\CurrentControlSet\\Control\\StorageDevicePolicies" [/code] just you change the values [code] "0" to "1" WriteProtect="1" [/code]

Thank to you also.

Plz don't blame

(another login) to "help yourself"

Thanks for comment.