适用于旧版Sybase Adaptive Server Anywhere的无DSN的ODBC连接字符串 [英] DSN-less ODBC connect string for legacy Sybase Adaptive Server Anywhere
问题描述
这是对本文的失败回复: Sybase，VB和ADO
This is a failed response to this article: Sybase, VB and ADO
我刚刚做了一个VB6项目，它连接到旧版ASA 7数据库.在完全(由于某种原因或其他原因)完全不使用ASAProv OLEDB提供程序和大量研究之后，以下是用于无DSN的ODBC驱动程序连接的OLEDB ODBC垫片的OLEDB提供程序的连接字符串:
I just did a VB6 project connecting to a legacy ASA 7 database. After failing to use ASAProv OLEDB provider altogether (for one reason or another) and much research, here is the connect string for OLEDB Provider for ODBC shim for a DSN-less ODBC driver connection:
Provider=MSDASQL.1;Driver={Adaptive Server Anywhere 7.0};CommLinks=TCPIP,SharedMemory;EngineName=<database_name>;UID=DBA;PWD=SQL
其中<database_name>是实例名称dbeng7.exe，正在其下运行db.在引擎日志中检查正在启动数据库"<database_name>"".
where <database_name> is the instance name dbeng7.exe is running the db under. Check the engine log for 'Starting database "<database_name>"'.
您可以通过创建系统DSN，调整设置和检查值HKLM\SOFTWARE\ODBC\ODBC.INI\<system_dsn>键来找到ODBC连接字符串的所有有效属性名称.
You can find all the valid property names for an ODBC connect string by creating a system DSN, adjust settings and inspecting values HKLM\SOFTWARE\ODBC\ODBC.INI\<system_dsn> key.
可以在MSDASQL提供程序连接字符串的驱动程序"属性下使用的可用ODBC驱动程序是HKLM\SOFTWARE\ODBC\ODBCINST.INI
The available ODBC drivers that can be used under Driver property of the MSDASQL provider connect string are subkeys of HKLM\SOFTWARE\ODBC\ODBCINST.INI
显然，Sybase登录密码不区分大小写，我觉得这很有趣.
Apparently Sybase login passwords are case insensitive which I find quite hilarious.
欢呼
</wqw>
推荐答案
哇，我相信我实际上是在上个千年写的那篇文章.
Wow, I actually wrote that article in the last millennium, I believe.
让我一点一点地讲这一点.
Let me take this point by point.
-
OLEDB提供程序可以很好地工作，我记得从前就使用它们.只需按照此处的说明进行操作即可: http://www.vbrad.com/article.aspx?id = 81 关于如何创建连接字符串.
OLEDB provider works fine for it, I remember using them from back in the day. Just follow instructions here: http://www.vbrad.com/article.aspx?id=81 on how to create a connection string.
对于ODBC，从未访问过 http://www.connectionstrings.com/使我失败.他们在wazoo上获得了连接字符串.
For ODBC, going to http://www.connectionstrings.com/ has never failed me. They got connection strings up wazoo.
这篇关于适用于旧版Sybase Adaptive Server Anywhere的无DSN的ODBC连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
