登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

面包会有的

... ...

 
 
 

日志

 
 

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

2009-02-23 01:19:46|  分类: VC++ |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

 

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

经测试,以上代码正确

  评论这张
 
阅读(1122)| 评论(0)

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018