VC++6.0在程序中自动添加ODBC数据源

 

// 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_)

经测试,以上代码正确