C / C++ / MFC

21-May-04 4:14

Is there any easy way to connect mysql database with mfc? I don't know how to use odbc Cry | :((

The mysql++ api i downloaded could not run under microsoft visual c++.net ....

AAntix21-May-04 4:45

AAntix

21-May-04 4:45

Install MySQL's ODBC driver ( http://dev.mysql.com/downloads/connector/odbc/3.51.html ). Setup a DSN for your database and then just use CDatabase and CRecordset to get your data.

Jim
QTExtender - The OFFICIAL addon for QuoteTracker.

Chooikw21-May-04 6:09

21-May-04 6:09

how is it if the other user uses my program to remotely connect to the mysql database in my computer?Do they need to install the mysql odbc too?

valikac21-May-04 7:03

valikac

21-May-04 7:03

ODBC is a database connectivity interface on the Win32 platform that can connect to various DBMSs including MySQL.

Kuphryn

BlackDice21-May-04 7:33

BlackDice

21-May-04 7:33

I made a dll to connect to a mysql database, run a query and insert the results into a .dbf file or .xls. I think the only thing you have to do is include the MySQL.h file in your project and link to the library. From there just use the functions declared in the MySQL header file. If this sounds like a reasonable solution and you need a sample, just let me know and I'll dig up the code and paste a snippet here. Wink | ;)

If it's broken, I probably did it

bdiamond

Chooikw21-May-04 11:11

21-May-04 11:11

Ofcourse i need a sample since i can't find out the functions' name inside the dll;P

BlackDice21-May-04 11:46

BlackDice

21-May-04 11:46

The functions are declared in the "Mysql.h" header file, and the definitions are in the mysql.cpp file

wherever your mysql folder is there's a folder in there called 'Include'. all the files in there
should be included in your project.

#include the mysql.h file in your [yourapp.cpp] file. then here's a snippet: well a whole function Big Grin | :-D

Sorry it's a little sloppy; It's time to leave work now, and I'm doing this at the last minute

int Export(BSTR szServer, BSTR szDB, BSTR szUser, BSTR szPassword, BSTR szSQL, int nExportType)
{
	/*notes--
			Author: Diamond ringold (2004-03-22)
			Purpose: accepts a query string along with server name, dbname, user, password
					and gets a result set from a MySQL database.  Then allows user to select name and
					directory of a new dbase table to export queried info to
	*/
	SQLRETURN			sr;
	int						numOfRows=0;							//Counter
	int						numOfFields=0;						//Counter
	int						connected=0;							//status flag
	MYSQL					*dbHandle;								//Connection handle
	MYSQL_RES			*res;											//Result struct
	MYSQL_FIELD		*field;										//Field struct
	MYSQL_ROW			row;											//row struct
	char					errmsg[512];
	
	hDbConn =0;
	hOdbcEnv = 0;
	// Create the mysql object 
	dbHandle=mysql_init((MYSQL*)0);

	CString szDBFName;
	CString strPath,strTblName;

	try
	{
		CString sFileFilter;
		if(nExportType)
			sFileFilter = "Excel Spreadsheet (*.xls)|*.xls||";
		else
			sFileFilter = ".dbf files (*.dbf)|*.dbf||";
		//open file save dialog
		CFileDialog dlg(FALSE,".DBF",NULL,OFN_ENABLESIZING | OFN_HIDEREADONLY,sFileFilter);
		if(dlg.DoModal() == IDOK)
		{
			szDBFName = dlg.GetPathName();
			strTblName = dlg.GetFileName();
			//if no name in filename box
			if((szDBFName.GetLength() || strTblName.GetLength() ) == 0)
			{
				AfxMessageBox("Export Canceled",MB_OK | MB_ICONINFORMATION);
				return 0;
			}
		}
		else //if user pressed cancel
		{
			AfxMessageBox("Export Canceled",MB_OK | MB_ICONINFORMATION);
			return 0;
		}
		
		int nPos = szDBFName.Find(strTblName,0);
		strPath = szDBFName.Left(nPos);

		//connect to MySQL db
		if(mysql_real_connect(dbHandle,			// Handle to mysqlobject 
									(char*)szServer,			// Host - default=localhost
									(char*)szUser,				// Username
									(char*)szPassword,		// Password
									(char*)szDB,					// Databasename
									MYSQL_PORT,						// Port of connection
									NULL,									// Used by Unixsocket
									0))										// client_flag
		{

			connected=1;
		}
		else //failed to connect
		{
			sprintf(errmsg, "\nConnection Error: %s\n", mysql_error(dbHandle));
			AfxMessageBox(errmsg);
			connected = 0;
		}

		//select the default db
		if(mysql_select_db(dbHandle,(char*)szDB))
		{
			sprintf(errmsg, "\nSelect DB Error: %s\n", mysql_error(dbHandle));
			AfxMessageBox(errmsg);
			return 0;
		}

		//execute query
		if(mysql_query(dbHandle,(char*)szSQL))
		{
			sprintf(errmsg, "\nError: %s\n", mysql_error(dbHandle));
		AfxMessageBox(errmsg);
		return 0;
		
		}

		//store the query results
		res=mysql_store_result(dbHandle);
		
		CString			strConnect;

		//connect to dbase directory chosen by user
		
		if(nExportType)
			strConnect.Format("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DefaultDir=%s;",strPath); 
		else //driverid 533 = dbase 5.0; 277 = dbase IV
			strConnect.Format("Driver={Microsoft dBase Driver (*.dbf)};DriverID=533;Dbq=%s;",strPath);
			
		
		if(hDbConn != SQL_NULL_HANDLE)
			SQLFreeHandle(SQL_HANDLE_DBC, hDbConn); //free connection
		
		if(hOdbcEnv != SQL_NULL_HANDLE)
			SQLFreeHandle(SQL_HANDLE_ENV,hOdbcEnv); 
				//return code for odbc calls
		
		//allocate environment
		sr = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hOdbcEnv);
		SR_CHECK
		//set the app's odbc version
		sr = SQLSetEnvAttr(hOdbcEnv, SQL_ATTR_ODBC_VERSION	,(SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER);
		SR_CHECK

		//allocate connection
		sr = SQLAllocHandle(SQL_HANDLE_DBC, hOdbcEnv, & hDbConn);
		SR_CHECK

		//set connect timeout
		sr = SQLSetConnectAttr(hDbConn,SQL_ATTR_LOGIN_TIMEOUT,(void*)5,0);
		SR_CHECK
		//connect to data source
		char szConnectString[512];
		sprintf(szConnectString,"%s",strConnect);
		
		char szDescription[1024];
		SQLSMALLINT				length;
		sr = SQLDriverConnect(hDbConn,NULL , (UCHAR*)szConnectString, 512,
			(UCHAR*)szDescription,1023,&length,SQL_DRIVER_COMPLETE_REQUIRED);
		
		SR_CHECK
				
		CString sColumns;
		numOfRows = (int) mysql_num_rows(res);
		numOfFields= (int) mysql_num_fields(res);
		
		if(numOfRows > 255)
		{
			AfxMessageBox("Too many fields for export.");
			return 0;
		}
		//dynamic arrays based on number of fields to hold field types and lengths
		char *			bNeedTics = new char[numOfFields] ;
		int *				nFieldLen = new int[numOfFields];
		CString			sColumnsToInsert;	
		sColumnNames = new CString[numOfFields];

		for(int i = 0; i < numOfFields; i++)
		{
			bNeedTics[i] = 'N';
		}
		CString* sStatements = new CString[numOfRows];

		//this FOR loop build string for create table statement	
		
		for (i =0;i < numOfFields;i++)
		{
			field=mysql_fetch_field(res);
			CString		sTemp = field->name;
			sColumnsToInsert += sTemp + ",";
			int				nType = field->type;
			int nLen = (int)field->length;
			CString					sCol;
			nFieldLen[i] = nLen;
			sTemp = CheckFieldname(sTemp,i);
			sColumnNames[i] = sTemp;

			switch(nType)
			{			
				case FIELD_TYPE_ENUM:
				case FIELD_TYPE_TINY:
				case FIELD_TYPE_SHORT:
					sCol.Format("%s %s,",sTemp,"INTEGER ");
					break;
				case FIELD_TYPE_LONG:
					sCol.Format("%s %s,",sTemp,"LONG ");
					break;
				case FIELD_TYPE_FLOAT:
				case FIELD_TYPE_DECIMAL:
					sCol.Format("%s %s,",sTemp,"FLOAT ");
					break;
				case FIELD_TYPE_DOUBLE:
					sCol.Format("%s %s,",sTemp,"DOUBLE ");
					break;
				case FIELD_TYPE_NULL:
					break;
				case FIELD_TYPE_LONGLONG:
				case FIELD_TYPE_INT24:
					sCol.Format("%s %s,",sTemp,"LONG ");
					break;
				case FIELD_TYPE_YEAR:
				case FIELD_TYPE_DATE:
				case FIELD_TYPE_NEWDATE:
					bNeedTics[i] = 'D';
					sCol.Format("%s %s,",sTemp,"DATE ");
					break;
				case FIELD_TYPE_TIME:
				case FIELD_TYPE_DATETIME:
				case FIELD_TYPE_TIMESTAMP:
					bNeedTics[i] = 'D';
					sCol.Format("%s %s,",sTemp,"DATETIME ");
					break;
				case FIELD_TYPE_SET:
					sCol.Format("%s %s,",sTemp,"int ");
					break;
				case FIELD_TYPE_TINY_BLOB:
				case FIELD_TYPE_MEDIUM_BLOB:
				case FIELD_TYPE_LONG_BLOB:
				case FIELD_TYPE_BLOB:
					bNeedTics[i] = 'T';
					sCol.Format("%s %s,",sTemp,"MEMO ");
					break;
				case FIELD_TYPE_VAR_STRING:
				case FIELD_TYPE_STRING:
					bNeedTics[i] = 'T';
					sCol.Format("%s TEXT(%d),",sTemp,nLen);
					break;
					
			}
			
			sColumns += sCol;
		
		}
		sColumnsToInsert = sColumnsToInsert.Left(sColumnsToInsert.GetLength() - 1);
		sColumns = sColumns.Left(sColumns.GetLength() - 1);
		sColumns = "CREATE TABLE " + strTblName + " (" + sColumns + ")";

		char tmp1[10000];
		sprintf(tmp1,"%s",sColumns);
		SQLCHAR*				SQL1 = (SQLCHAR*)tmp1;
		if(!nExportType) 
			executeSQL(SQL1);  //only do this if .dbf
		SQLSMALLINT				cols = 0;


		CString			sTic;
		CString			sTemp;
		CString			sValues,sInsertString;
		SQLDisconnect(hDbConn);
		CDBFRecordset* m_Set = 0;
		CString str;


		if(!nExportType)
		{	
			m_Set =  new CDBFRecordset;
			m_Set->Open(szDBFName);
			
			for(i=0;i<numOfRows;i++)
			{
   			row=mysql_fetch_row( res );
				m_Set->AddNew();
				sValues = "";
				for (int col=0;col<numOfFields;col++)
				{	
					field=mysql_fetch_field(res);
					str = row[col];
					CString sYear,sMonth,sDay,sHour,sMinute,sSecond;
					COleDateTime * t;
					BOOL bDate = FALSE;

					if(bNeedTics[col] == 'D')
					{
						
							str.Remove('-');  //take out dashes in case it's an empty date
							int len = str.GetLength();
							sYear = str.Mid(0,4);
							sMonth = str.Mid(4,2);
							sDay = str.Mid(6,2);
							//if more than 8 characters then column also has time info
							if(len > 8)
							{
								sHour = str.Mid(8,2);
								sMinute = str.Mid(10,2);
								sSecond = str.Mid(12,2);
							}
							else
							{
								sHour = sMinute = sSecond = "0";
							}
							bDate = TRUE;
							 t = new COleDateTime(atoi(sYear),
								 atoi(sMonth),atoi(sDay),atoi(sHour),atoi(sMinute),atoi(sSecond));
						
					}
					COleVariant fVar;
					if(bDate)
						fVar = *t;
					else
						fVar = str;
					
					m_Set->SetFieldValue(col,fVar);
				}

			m_Set->Update();

			}   //end of rows loop
			m_Set->Close();
			delete m_Set;
		}

mysql_free_result( res ) ;	//free the result set
		dbHandle->free_me;

If it's broken, I probably did it

bdiamond

Chooikw22-May-04 3:47

Serializing the valarray class(STL)

22-May-04 3:47

Thx for your helpful reply and i'm able to connect to my mysql database now! Smile | :)

Cyberizen21-May-04 3:49

Cyberizen

21-May-04 3:49

Hello gurus
I need to serialize an STL type called valarray but the the Serialize function is giving me errors regarding the << and the >> operator is there anyway or alternative to get over this thing please help

Regards
Ahmed

Frames in DHTML ED control

Member 52815521-May-04 3:27

Member 528155

21-May-04 3:27

Anybody use frames in dhtml ed control. Plz give suggestion.

lokesh

Problem with ListView API : LVM_ISERTITEM

ravjak21-May-04 2:51

21-May-04 2:51

"Hi I'm developing dll which will do some changing stuff with ListView. I have a funny problem I want to change value of iImage in a LV_ITEM according to pszText value. Problem occurs when I want to test value of pszText, exception ouccrs Access Violation 0xC0000005 Frown | :(

But I'm testing if pitem and pitem->pszText are not null even if I tryed to use strdup(pitem->pszText) the same exception occurs. There is no problem when I tryed to change value of iItem. Is is somehow connected witch injection dll into some application ?? and its address space ??
"

<br />
(WNDPROC) gfnListProc;<br />
//in some previous called function<br />
gfnListProc = (WNDPROC)SetWindowLong(listview, GWL_WNDPROC,(LONG)ListProc);<br />
<br />
__declspec(dllexport) LRESULT CALLBACK ListProc(HWND hwnd, UINT uiMsg,WPARAM wParam, LPARAM lParam)<br />
{<br />
	<br />
	switch (uiMsg)<br />
	{<br />
		case LVM_INSERTITEM:<br />
			{<br />
				LV_ITEM FAR* pitem = (LV_ITEM FAR*) lParam;<br />
				if(pitem && pitem->pszText)<br />
						MessageBox(0, pitem->pszText,":-)",MB_OK);					<br />
				<br />
				break;<br />
			}<br />
	}<br />
	return CallWindowProc(gfnListProc, hwnd, uiMsg, wParam, lParam);<br />
}<br />
<br />
//from commctr.h<br />
<br />
typedef struct tagLVITEMW<br />
{<br />
    UINT mask;<br />
    int iItem;<br />
    int iSubItem;<br />
    UINT state;<br />
    UINT stateMask;<br />
    LPWSTR pszText;<br />
    int cchTextMax;<br />
    int iImage;<br />
    LPARAM lParam;<br />
#if (_WIN32_IE >= 0x0300)<br />
    int iIndent;<br />
#endif<br />
} LVITEMW, FAR* LPLVITEMW;<br />
<br />
<br />
#define ListView_InsertItem(hwnd, pitem)   \<br />
    (int)SNDMSG((hwnd), LVM_INSERTITEM, 0, (LPARAM)(const LV_ITEM FAR*)(pitem))<br />
<br />

Thaks for reading that stuff Smile | :)

Pain is a weakness living the body

Andrew Quinn AUS21-May-04 3:12

Andrew Quinn AUS

21-May-04 3:12

Hi,

Are you sure that lParam is pointing to a valid LV_ITEM structure?

Cheers,
Andy

ravjak21-May-04 3:14

21-May-04 3:14

I'm pretty sure because listview is a HWND of list control and its valid

Pain is a weakness living the body

bikram singh21-May-04 3:56

bikram singh

21-May-04 3:56

Check that mask member contains LVIF_TEXT This flag indicates that the pszText member contains a valid address. If the flag is not set, the member could contain any "address".

Also, check that cchTextMax member is not zero. (not really required)

Bikram Singh

ravjak21-May-04 4:18

21-May-04 4:18

this pice of code doesn't work Frown | :(

<br />
case LVM_INSERTITEM:<br />
			{<br />
				LV_ITEM FAR* pitem = (LV_ITEM FAR*) lParam;<br />
				if(!pitem && !pitem->pszText)<br />
					break;<br />
<br />
				if( pitem->mask & LVIF_TEXT == LVIF_TEXT && pitem->cchTextMax>0)  <br />
				{<br />
					MessageBox(okno,pitem->pszText,":-)",MB_OK);					<br />
				}<br />
				break;	<br />

any other ideas Confused | :confused:

Pain is a weakness living the body

bikram singh21-May-04 4:29

bikram singh

21-May-04 4:29

Try using brackets to delimit each expression you are testing in the if statement.

Bikram Singh

jmkhael21-May-04 4:39

jmkhael

21-May-04 4:39

What happens if pitem != NULL and pitem->pszText = NULL?

(Hint: It wont break)

I would do the test:

if(pitem && pitem->pszText)
{
// Do the dance...
}

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

ravjak21-May-04 4:53

21-May-04 4:53

Not working hmmm hardcore hehe.
Im testing changing iImage value according to iItem and it seems to be good if I know sequence of adding apriori, which will require some more coding. Anyway its really strage stuff isn't it Confused | :confused:

Pain is a weakness living the body

jmkhael21-May-04 4:58

jmkhael

21-May-04 4:58

Try this

case LVM_INSERTITEM:
{
LPLVITEM pitem = (LPLVITEM) lParam;
if(pitem && pitem->pszText)
{
if( ((pitem->mask & LVIF_TEXT) == LVIF_TEXT))
{
MessageBox(okno,pitem->pszText,"",MB_OK);
}
}
break;

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

ravjak21-May-04 6:14