📄 在c++builder中创建access odbc数据源.htm
字号:
<td class=tdmenubar>· <a href='/article/29/' class="menubar" title='Photoshop基础教程 文章数：195'>Photoshop基础</a></td>
</tr>
<tr>
<td class=tdmenubar>· <a href='/article/28/30/' class="menubar" title='Photoshop滤镜 文章数：136'>Photoshop滤镜</a></td>
<td class=tdmenubar>· <a href='/article/28/31/' class="menubar" title='Photoshop实例 文章数：233'>Photoshop实例</a></td>
</tr>
<tr>
<td class=tdmenubar>· <a href='/article/33/' class="menubar" title='Dreamwaver教程 文章数：271'>Dreamwaver</a></td>
<td class=tdmenubar>· <a href='/article/34/' class="menubar" title='flash教程 文章数：423'>Flash</a></td>
</tr>
<tr>
<td class=tdmenubar>· <a href='/article/35/' class="menubar" title='Fireworks教程 文章数：136'>Fireworks</a></td>
<td class=tdmenubar>· <a href='/article/37/' class="menubar" title='注册码 文章数：173'>注册码</a></td>
</tr>
<tr>
<td class=tdmenubar>· <a href='/article/38/' class="menubar" title='系统进程 文章数：45'>系统进程</a></td>
<td class=tdmenubar>· <a href='/article/39/' class="menubar" title='C# 文章数：0'>C#</a></td>
</tr>
<tr>
<td class=tdmenubar>· <a href='/article/40/' class="menubar" title='汇编语言 文章数：116'>汇编语言</a></td>
<td class=tdmenubar>· <a href='/article/41/' target="_blank" class="menubar" title='.Net 文章数：2630'>.Net</a></td>
</tr>
<tr>
<td class=tdmenubar>· <a href='/article/42/' class="menubar" title='网页浏览 文章数：267'>网页浏览</a></td>
<td class=tdmenubar>· <a href='/article/43/' target="_blank" class="menubar" title='邮件工具 文章数：74'>邮件工具</a></td>
</tr>
<tr>
<td class=tdmenubar>· <a href='/article/44/' target="_blank" class="menubar" title='联络聊天 文章数：31'>联络聊天</a></td>
<td class=tdmenubar>· <a href='/article/45/' target="_blank" class="menubar" title='IP通讯 文章数：126'>IP通讯</a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2" bgcolor="#FFFFFF"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="titleback1">热门文章</td>
</tr>
<tr>
<td height="100" valign="top">· <font color='#0066FF'>[图文]</font> <a href=/article/5/12/2006/200608311537.html title='Google再度扩张：收购3D设计软件'>Google再度扩..</a><br>
· <a href=/article/5/11/2006/200608301361.html title='Google究竟知道多少个人隐私？'>Google究竟知道多少..</a><br>
· <a href=/article/5/11/2006/200608301351.html title='Google搜索从入门到精通 (1)'>Google搜索从入门到..</a><br>
· <font color='#0066FF'>[图文]</font> <a href=/article/5/12/2006/200608311519.html title='google也来做统计了'>google也来做..</a><br>
· <font color='#FF0066'>[组图]</font> <a href=/article/5/12/2006/200608311488.html title='Google徽标全集(1998-2005)'>Google徽标全..</a><br>
· <font color='#0066FF'>[图文]</font> <a href=/article/5/11/2006/200608301352.html title='有趣的Google新鲜技巧玩法'>有趣的Google..</a><br>
· <a href=/article/5/11/2006/200608301360.html title='Google排名—搜索引擎登记技巧'>Google排名—搜索引..</a><br>
· <font color='#0066FF'>[图文]</font> <a href=/article/10/2006/200608291188.html title='菜鸟安全防患之饿死木马'>菜鸟安全防患..</a><br>
· <a href=/article/9/2006/20060827361.html title='数学最大数字'>数学最大数字</a><br>
· <a href=/article/10/2006/200608291195.html title='Google搜索技巧(6):用Google找自己'>Google搜索技巧(6):..</a><br></td>
</tr>
<tr>
<td height="2" bgcolor="#FFFFFF"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="titleback1">相关文章</td>
</tr>
<tr>
<td height="100" valign="top">· <a href="/article/1/14/2006/2006092518470.html" title='如何在C++ Builder的DLL中使用数据库控件'>如何在C++ Builder的..</a><br>
· <a href="/article/1/14/2006/2006092518454.html" title='在C++ Builder中实现桌布自动更新'>在C++ Builder中实现..</a><br>
· <a href="/article/1/14/2006/2006092518380.html" title='在C++中创建持久对象'>在C++中创建持久对象..</a><br>
· <a href="/article/1/14/2006/2006092518365.html" title='在C++中实现变长数组'>在C++中实现变长数组..</a><br>
· <a href="/article/1/14/2006/2006092518296.html" title='在C++ Builder中用socket api来写网络通讯程序（同时支持TCP和UDP协议）'>在C++ Builder中用s..</a><br>
· <font color='#0066FF'>[图文]</font> <a href="/article/1/14/2006/2006092518288.html" title='在C++ Builder6上使用Boost正则表达式库'>在C++ Builde..</a><br>
· <a href="/article/1/14/2006/2006092518266.html" title='在C++中实现“属性 (Property)”'>在C++中实现“属性 ..</a><br>
· <a href="/article/1/14/2006/2006092518250.html" title='在C++中实现属性'>在C++中实现属性</a><br>
· <font color='#0066FF'>[图文]</font> <a href="/article/1/14/2006/2006092518249.html" title='在C++ Builder6中使用XML'>在C++ Builde..</a><br>
· <a href="/article/1/14/2006/2006092518231.html" title='在C++ Builder中如何通过对象名称来访问到该对象呢？答案就是使用MAP容器。'>在C++ Builder中如何..</a><br></td>
</tr>
</table>
</td>
<td width="588" align="right" class="tableright">
<table width="575" border="0" cellpadding="0" cellspacing="0" style="table-layout:fixed;word-break:break-all">
<tr>
<td align="center" height=32 style="font-size: 12pt;color: #FF6600;">在C++Builder中创建Access odbc数据源</td>
</tr>
<tr>
<td align="center" height=25 bgcolor=#F7F7F7>作者：佚名 来源：不详 发布时间：25/09/2006 19:25:02 发布人：admin</td>
</tr>
<script language=javascript>
var newasp_fontsize=9;
var newasp_lineheight=12;
</script>
<tr>
<td><p align="right"><a style="CURSOR: hand; POSITION: relative" onclick="if(newasp_fontsize>8){NewaspContentLabel.style.fontSize=(--newasp_fontsize)+"pt";NewaspContentLabel.style.lineHeight=(--newasp_lineheight)+"pt";}" title="减小字体"><img src="/images/1.gif" border="0" width="15" height="15"><font color="#FF6600">减小字体</font></a>
<a style="CURSOR: hand; POSITION: relative" onclick="if(newasp_fontsize<64){NewaspContentLabel.style.fontSize=(++newasp_fontsize)+"pt";NewaspContentLabel.style.lineHeight=(++newasp_lineheight)+"pt";}" title="增大字体"><img src="/images/2.gif" border="0" width="15" height="15"><font color="#FF6600">增大字体</font></a>
</p>
<div id="NewaspContentLabel" style="display:block;padding:0px 10px;" class="ContentFont"><FONT id=font_word style="FONT-SIZE: 14px; FONT-FAMILY: 宋体, Verdana, Arial, Helvetica, sans-serif"><P>想用BDE导Access数据库，要创建ODBC 数据源。找了半天也没见着BCB写的代码，所以我改写了一个。如有不足处，请指正。 <A href="mailto:========jianlinlong@163.net">========jianlinlong@163.net</A></P><P>/*<BR>函数功能：创建Access ODBC数据源<BR>输入参数：DSN--------所要创建的 Access ODBC数据源的名称<BR> strMDBFile-----------Access 库文件的完整路径<BR> strDesc---------这个数据源的描述<BR> strLoginUser---------登录strMDBFile所指的文件的用户名<BR> strPassword----------登录strMDBFile所指的文件的密码<BR>返回值 ：成功返回true, 否则会抛出Exception (这样写会不会有问题呀？)<BR>用 法:<BR> (1)CreateAccessDSN("jll_access", "c:\\<a target="_blank" href="http://www.malegebide.com" class="wordstyle">windows</a>\\desktop\\starso.mdb");<BR> (2)CreateAccessDSN("jll_access2", "c:\\<a target="_blank" href="http://www.malegebide.com" class="wordstyle">windows</a>\\desktop\\starso.mdb", " ", "Admin", "ok_pwd");<BR>注 意：<BR> #include <Registry.hpp><BR> #include <memory></P><P> using namespace std;<BR>*/<BR>bool __fastcall CreateAccessDSN(const AnsiString& DSN,<BR> const AnsiString& strMDBFile,<BR> const AnsiString& strDesc = "no descript",<BR> const AnsiString& strLoginUser = "",<BR> const AnsiString& strPassword = "")<BR>{<BR> auto_ptr<TRegistry> spReg(new TRegistry());<BR> spReg->RootKey = HKEY_LOCAL_MACHINE; <A href="file://设">//设</A>置根键值为HKEY_LOCAL_MACHINE<BR> <A href="file://找">//找</A>到Software\ODBC\ODBC.INI\ODBC Data Sources<BR> if (spReg->OpenKey("Software\\ODBC\\ODBC.INI\\ODBC Data Sources", true))<BR> {//注册一个DSN名称<BR> spReg->WriteString(DSN, "Microsoft Access Driver (*.mdb)" );<BR> spReg->CloseKey();<BR> }else{<BR> /<A href="file://创">/创</A>建键值失败<BR> throw Exception("增加ODBC数据源失败");<BR> }<BR> <A href="file://找">找</A>到或创建Software\ODBC\ODBC.INI\MyAccess,写入DSN配置信息<BR> if (spReg->OpenKey("Software\\ODBC\\ODBC.INI\\" + DSN, true))<BR> {<BR> spReg->WriteString("DBQ", strMDBFile);//数据库目录，<font id="mppmknlfljkvwnlj">育M件EAeW\|软?]tQJ育</font><p id="ijwchknqjdmrjas">d[TiR5+g+,(T[Hd</p>连接您的数据库<BR> spReg->WriteString("Description", strDesc);//数据源描述<BR> char buf[MAX_PATH];<BR> ::GetSystemDirectory(buf, MAX_PATH);<BR> spReg->WriteString("Driver", AnsiString(buf) + "<A href="file://\\odbcjt32.dll">\\odbcjt32.dll</A>" );//驱动程序DLL文件<BR> spReg->WriteInteger("DriverId", 25 ); <A href="file://驱">//驱</A>动程序标识<BR> spReg->WriteString("FIL", "Ms Access;" ); <A href="file://Filter">//Filter</A>依据<BR> spReg->WriteInteger("SafeTransaction", 0 ); <A href="file://支">//支</A>持的事务操作数目<BR> spReg->WriteString("UID", strLoginUser);//用户名称<BR> spReg->WriteString("PWD", strPassword);//用户密码<BR> BYTE bData = 0;<BR> spReg->WriteBinaryData("Exclusive", &bData, 1); <A href="file://非">//非</A>独占方式<BR> spReg->WriteBinaryData("ReadOnly", &bData, 1 ); <A href="file://非">//非</A>只读方式<BR> spReg->CloseKey();<BR> }else{<BR> throw("增加ODBC数据源失败");<BR> };<BR> <A href="file://找">//找</A>到或创建Software\ODBC\ODBC.INI\MyAccess\Engines\Jet<BR> <A href="file://写">//写</A>入DSN数据库引擎配置信息<BR> if (spReg->OpenKey("Software\\ODBC\\ODBC.INI\\" + DSN + "<A href=''''file://\\Engines\\Jet"''''>\\Engines\\Jet"</A>, true))<BR> {<BR> spReg->WriteString( "ImplicitCommitSync", "Yes");<BR> spReg->WriteInteger("MaxBufferSize", 2048 );//缓冲区大小<BR> spReg->WriteInteger("PageTimeout", 10 );//页超时<BR> spReg->WriteInteger("Threads", 3 );//支持的线程数目<BR> spReg->WriteString("UserCommitSync", "Yes");<BR> spReg->CloseKey();<BR> }else{<BR> throw("增加ODBC数据源失败");<BR> }<BR> return true;<BR>}<BR></P></span></span> <div id="Message" class="Message"></div></font></div>
<div></div>
</td>
</tr>
<tr>
<td align="right" height=25 bgcolor=#F7F7F7 style="display:block;padding:0px 10px">
[<script language=JavaScript src="/article/Hits.Asp?ArticleID=18290"></script>]
[<a href="javascript:history.go(-1)">返回上一页</a>]
[<a href=javascript:window.print()>打 印</a>]
[<a href="/user/favorite.asp?action=add&topic=在C++Builder中创建Access odbc数据源">收 藏</a>]</td>
</tr>
<tr>
<td style="display:block;padding:0px 10px"><div>上一篇文章：<a href=/article/1/14/2006/2006092518289.html>C++ 和 Delphi 的函数覆盖(Override)与重载(overload)</a></div><div>下一篇文章：<a href=/article/1/14/2006/2006092518291.html>C++ Builder 初学问与答（二）</a></div></td>
</tr>
</table>
<table width="575" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="titlebg1">∷相关文章评论∷ （评论内容只代表网友观点，与本站立场无关！） [<a href=/article/comment.asp?ArticleID=18290 target=_blank>更多评论</a>…]</td>
</tr>
<tr valign="top">
<td></td>
</tr>
</table>
</td>
</tr>
</table>
<!-- 页面底部开始 -->
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0" class="tableborder">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="8" class="linebar"></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="65" align="center" class="tablebody">QQ:310646
<a href="/admin/admin_login.asp" target="_blank" class="navmenu">A</a>
Copyright © 2006 <font face=Verdana, Arial, Helvetica, sans-serif><b>Malegebide.Com</b></font>. <script language="javascript" type="text/javascript" src="http://js.users.51.la/529370.js"></script>No Rights Reserved <br></td>
</tr>
<tr>
<td height="5"></td>
</tr>
</table>
</body>
</html>
<script language="javascript" src="/inc/Std_StranJF.Js"></script>
<!-- 页面底部结束 -->
<script src="/count.asp" type="text/javascript"></script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -