subject_59546.htm

vc

<p>
序号：59546 发表者：logout 发表日期：2003-11-08 15:59:52
<br>主题：已知数据源，如何得知其对应的驱动程序信息？
<br>内容：ODBC数据源,谢谢
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：wjb 回复日期：2003-11-08 16:33:39
<br>内容：附件是一个很完整的例子。<BR>连接ODBC后，在help菜单中的命令查看驱动信息。<BR>
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：logout 回复日期：2003-11-08 18:24:46
<br>内容：使用函数SQLDataSources进行迭代，首先用：<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;retcode = SQLDataSources(henv, SQL_FETCH_FIRST_SYSTEM, szDSNName,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sizeof(szDSNName), NULL, szDescription, sizeof(szDescription), NULL);<BR>进行初始化，然后&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(SQL_SUCCEEDED(retcode))<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Do the next one, if it exists.<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;retcode = SQLDataSources(henv, SQL_FETCH_NEXT, szDSNName,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sizeof(szDSNName), NULL,szDescription, sizeof(szDescription), NULL);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR><BR>这样服务名在szDSNName中，驱动名在szDescription中。<BR><BR>有谁知道szDescription应定义为多长？<BR>szDSNName应定义为SQL_MAX_DSN_LENGTH + 1
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>