C / C++ / MFC

CString szSql = "SHOW DATABASES"; to this
szSql = "SHOW DATABASES from mysql", 

rs.Open( CRecordset::forwardOnly, szSql); to this
rs.Open( _T("Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=;User=root; Password=root;Option=3;"),szSql,CRecordset::forwardOnly);

import dbi
import odbc
conn = odbc.odbc("Driver={MySQL ODBC 5.1 Driver}; Server=localhost; Database=; User=root; Password=password; Option=3;")
curs = conn.cursor()
curs.execute("SHOW DATABASES")
curs.fetchall()

[('information_schema',), ('mysql',), ('test',)]

#import "libid:2A75196C-D9EB-4129-B803-931327F72D5C" rename("EOF", "adoEOF")

int main()
{
   CoInitialize(0);
   ADODB::_ConnectionPtr conn(__uuidof(ADODB::Connection));
   conn->Open(_bstr_t("Driver={MySQL ODBC 5.1 Driver}; Server=localhost; Database=; User=root; Password=password; Option=3;"), "", "", 0);
   ADODB::_RecordsetPtr rs = conn->Execute(_bstr_t("SHOW DATABASES"), 0, ADODB::adCmdText);

   _variant_t databaseNames = rs->GetRows(ADODB::adGetRowsRest);
}

_variant_t.

Razanust wrote:

couldn't get that. Plesae elaborate the clue so that i can learn a bit more.

I am trying to use the "isdigit" command for this purpose. Would that be suitable?

Razanust wrote:

Any clue to the solution???

struct MyStruct
{
    char Name[20];
    int age;
}
// Fill the Structure with the appropriate values
MyStruct myStruct;
FILE *pFile = fopen("Record.txt", "Wb+");
fwrite((char*)&myStruct, sizeof(MyStruct), 1, pFile);

fread((char*)&myStruct, sizeof(MyStruct), 1, pFile);

Harsh Shankar wrote:

I Don't know why u are trying there tipical methods.

Razanust wrote:

Any clue to the solution???

std::ifstream fin;
std::vector<Record> records;
	
fin.open("c:\\Records.txt");
std::copy(std::istream_iterator<Record>(fin), std::istream_iterator<Record>(), std::back_inserter(records));
fin.close();