急!!按照示例做了个程序,就是联不上mysql!

Question

在另一台电脑上调试后的错误报告
<?xml version="1.0" encoding="UTF-16"?>
<DATABASE>
<EXE NAME="vcmysql4.exe" FILTER="GRABMI_FILTER_PRIVACY">
    <MATCHING_FILE NAME="vcmysql4.exe" SIZE="122938" CHECKSUM="0x74A5E650" BIN_FILE_VERSION="1.0.0.1" BIN_PRODUCT_VERSION="1.0.0.1" PRODUCT_VERSION="1, 0, 0, 1" FILE_DESCRIPTION="vcmysql4 Microsoft 基础类应用程序" COMPANY_NAME="" PRODUCT_NAME="vcmysql4 应用程序" FILE_VERSION="1, 0, 0, 1" ORIGINAL_FILENAME="vcmysql4.EXE" INTERNAL_NAME="vcmysql4" LEGAL_COPYRIGHT="版权所有 (C) 2011" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="1.0.0.1" UPTO_BIN_PRODUCT_VERSION="1.0.0.1" LINK_DATE="05/23/2011 00:38:49" UPTO_LINK_DATE="05/23/2011 00:38:49" VER_LANGUAGE="中文(中国) [0x804]" />
</EXE>
<EXE NAME="kernel32.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="kernel32.dll" SIZE="1144320" CHECKSUM="0xECE8734" BIN_FILE_VERSION="5.1.2600.2180" BIN_PRODUCT_VERSION="5.1.2600.2180" PRODUCT_VERSION="5.1.2600.2180" FILE_DESCRIPTION="Windows NT BASE API Client DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft(R) Windows(R) Operating System" FILE_VERSION="5.1.2600.2180 (xpsp_sp2_rtm.040803-2158)" ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" LEGAL_COPYRIGHT="(C) Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x11E311" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.2180" UPTO_BIN_PRODUCT_VERSION="5.1.2600.2180" LINK_DATE="08/04/2004 07:52:00" UPTO_LINK_DATE="08/04/2004 07:52:00" VER_LANGUAGE="中文(中国) [0x804]" />
</EXE>
</DATABASE>

Answer 1

两个电脑的软件版本(vc6,mysql5.1,odbc3.52,winxp-sp3)是一样的

Answer 2

stdafx.h 代码#pragma once
#endif // _MSC_VER > 1000#define VC_EXTRALEAN // Exclude rarely-used stuff from Windows headers#include <afxwin.h>         // MFC core and standard components
#include <afxext.h>         // MFC extensions
#include <afxdisp.h>        // MFC Automation classes
#include <afxdtctl.h> // MFC support for Internet Explorer 4 Common Controls
#ifndef _AFX_NO_AFXCMN_SUPPORT
#include <afxcmn.h> // MFC support for Windows Common Controls
#endif // _AFX_NO_AFXCMN_SUPPORT
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace \
 rename("EOF","adoEOF")rename("BOF","adoBOF")
//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.#endif // !defined(AFX_STDAFX_H__58597D7F_0E55_4C1F_992A_D172DEF7108F__INCLUDED_)

Answer 3

http://blog.csdn.net/zyq5945/archive/2010/04/14/5486393.aspx
http://topic.csdn.net/u/20100907/23/ecf4483a-9809-4499-85e4-b360b088f4a1.html

Answer 4

void CVcmysql4Dlg::OnInitADOConn()
{
   try
{
//创建连接对象实例
m_pConnection.CreateInstance("ADODB.Connection");
//设置连接字符串
// CString strConnect="DRIVER={Microsoft Access Driver (*.mdb)};\
// uid=;pwd=;DBQ=shujuku.mdb;";
 CString strConnect="Driver={MySQL ODBC 3.51 Driver};server=localhost;database=test;uid=root;pwd=123456;option=16386; ";
//使用Open方法连接数据库  option=16386
//使用Open方法连接数据库
m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}

Answer 5

BOOL CVcmysql4Dlg::OnInitDialog()
{
CDialog::OnInitDialog(); // Add "About..." menu item to system menu. // IDM_ABOUTBOX must be in the system command range.
ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
ASSERT(IDM_ABOUTBOX < 0xF000); CMenu* pSysMenu = GetSystemMenu(FALSE);
if (pSysMenu != NULL)
{
CString strAboutMenu;
strAboutMenu.LoadString(IDS_ABOUTBOX);
if (!strAboutMenu.IsEmpty())
{
pSysMenu->AppendMenu(MF_SEPARATOR);
pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
}
} // Set the icon for this dialog.  The framework does this automatically
//  when the application's main window is not a dialog
SetIcon(m_hIcon, TRUE); // Set big icon
SetIcon(m_hIcon, FALSE); // Set small icon

// TODO: Add extra initialization here
m_Grid.SetExtendedStyle(LVS_EX_FLATSB
|LVS_EX_FULLROWSELECT
|LVS_EX_HEADERDRAGDROP
|LVS_EX_ONECLICKACTIVATE
|LVS_EX_GRIDLINES);
m_Grid.InsertColumn(0,"n",LVCFMT_LEFT,80,0);
m_Grid.InsertColumn(1,"i",LVCFMT_LEFT,80,1);
m_Grid.InsertColumn(2,"j",LVCFMT_LEFT,80,2);
m_Grid.InsertColumn(3,"k",LVCFMT_LEFT,80,3);
AddToGrid();
return TRUE;  // return TRUE  unless you set the focus to a control
}

Answer 6

void CVcmysql4Dlg::AddToGrid()
{
//连接数据库
OnInitADOConn();
//设置查询字符串
_bstr_t bstrSQL = "select * from t1 order by n";
//创建记录集指针对象实例
m_pRecordset.CreateInstance(__uuidof(Recordset));
//打开记录集
m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,
adLockOptimistic,adCmdText);
while(!m_pRecordset->adoEOF)
{
m_Grid.InsertItem(0,"");
m_Grid.SetItemText(0,0,(char*)(_bstr_t)m_pRecordset->GetCollect("n"));
m_Grid.SetItemText(0,1,(char*)(_bstr_t)m_pRecordset->GetCollect("i"));
m_Grid.SetItemText(0,2,(char*)(_bstr_t)m_pRecordset->GetCollect("j"));
m_Grid.SetItemText(0,3,(char*)(_bstr_t)m_pRecordset->GetCollect("k"));
//将记录集指针移动到下一条记录
m_pRecordset->MoveNext();
}
//断开数据库连接
ExitConnect();
}