// ST.cpp : Defines the class behaviors for the application.
//
#include "stdafx.h"
#include "ST.h"
#include "STDlg.h"
#include <ODBCINST.H>//
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
typedef BOOL (WINAPI *SQLCONFIGDATASOURCE_FUNCTION)(HWND,WORD,LPCSTR,LPCSTR);//另加的
/
// CSTApp
BEGIN_MESSAGE_MAP(CSTApp, CWinApp)
//{{AFX_MSG_MAP(CSTApp)
// NOTE - the ClassWizard will add and remove mapping macros here.
// DO NOT EDIT what you see in these blocks of generated code!
//}}AFX_MSG
ON_COMMAND(ID_HELP, CWinApp::OnHelp)
END_MESSAGE_MAP()
/
// CSTApp construction
CSTApp::CSTApp()
{
// TODO: add construction code here,
// Place all significant initialization in InitInstance
}
/
// The one and only CSTApp object
CSTApp theApp;
/
// CSTApp initialization
BOOL CSTApp::InitInstance()
{
AfxEnableControlContainer();
//调用动态连接库odbccp32.dll的函数SQLConfigDataSource
HINSTANCE h=::LoadLibrary("ODBCCP32.DLL");
SQLCONFIGDATASOURCE_FUNCTION pConfigDataSource=0;
pConfigDataSource=(SQLCONFIGDATASOURCE_FUNCTION)GetProcAddress(h,"SQLConfigDataSource");
//使用动态路径设置odbc数据源
char sDirectory[256];
::GetCurrentDirectory(256,sDirectory);
strcat(sDirectory,"\\db\\Student.mdb");
char ss[256]="DSN=studb0DBQ=";
strcat(ss,sDirectory);
ss[9]=0; //区分前后子字符串
int length=strlen(ss);
ss[length]=0; //因为该参数以双结束符结尾
BOOL res=pConfigDataSource(NULL,ODBC_ADD_SYS_DSN,"Microsoft Access Driver (*.mdb)", ss);
::FreeLibrary(h);//释放动态连接库资源
// Standard initialization
// If you are not using these features and wish to reduce the size
// of your final executable, you should remove from the following
// the specific initialization routines you do not need.
#ifdef _AFXDLL
Enable3dControls(); // Call this when using MFC in a shared DLL
#else
Enable3dControlsStatic(); // Call this when linking to MFC statically
#endif
CSTDlg dlg;
m_pMainWnd = &dlg;
int nResponse = dlg.DoModal();
if (nResponse == IDOK)
{
// TODO: Place code here to handle when the dialog is
// dismissed with OK
}
else if (nResponse == IDCANCEL)
{
// TODO: Place code here to handle when the dialog is
// dismissed with Cancel
}
// Since the dialog has been closed, return FALSE so that we exit the
// application, rather than start the application's message pump.
return FALSE;
}
============================================================
// stdafx.h : include file for standard system include files,
// or project specific include files that are used frequently, but
// are changed infrequently
//
#if !defined(AFX_STDAFX_H__5492AC48_D37B_47EB_A7DF_1ED3A20611F3__INCLUDED_)
#define AFX_STDAFX_H__5492AC48_D37B_47EB_A7DF_1ED3A20611F3__INCLUDED_
#if _MSC_VER > 1000
#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
#include <afxdb.h>
#include <afxtempl.h>
#include <odbcinst.h>
#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" rename("EOF", "_EOF")
using namespace ADODB;
//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.
#endif // !defined(AFX_STDAFX_H__5492AC48_D37B_47EB_A7DF_1ED3A20611F3__INCLUDED_)
经测试,以上代码正确