{"id":67022,"date":"2015-01-02T01:33:27","date_gmt":"2015-01-01T17:33:27","guid":{"rendered":"http:\/\/www.xiaoyebailong.com\/?p=67022"},"modified":"2015-01-02T01:41:22","modified_gmt":"2015-01-01T17:41:22","slug":"sybase-ase%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%ad%e7%9a%84odbc%e9%a9%b1%e5%8a%a8windows-odbc%e7%af%87","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2015\/01\/02\/67022.htm","title":{"rendered":"Sybase ASE\u6570\u636e\u5e93\u4e2d\u7684ODBC\u9a71\u52a8(Windows ODBC\u7bc7)"},"content":{"rendered":"

\u8fd9\u91cc\u4e3b\u8981\u4ecb\u7ecd\u4e00\u4e0b\u8fd9\u4e9b\u9a71\u52a8\u7684\u6ce8\u518c\u65b9\u6cd5\uff1a<\/p>\n

1. \u9488\u5bf912.5.x\u7684ASE\u5b89\u88c5\uff0c\u4f60\u53ef\u80fd\u4e00\u76f4\u5728\u4f7f\u7528\u8fd9\u4e48\u8001\u7684\u9057\u7559\u7cfb\u7edf\uff0c\u53c8\u820d\u4e0d\u5f97\u653e\u5f03\uff0c\u53ef\u80fd\u5176\u4e2d\u7684\uff2f\uff24\uff22\uff23\u9a71\u52a8\uff0c\u4f60\u8fd8\u5e0c\u671b\u5b83\u80fd\u7ee7\u7eed\u670d\u5f79\uff0c\u4f46\u662f\u5ba2\u6237\u673a\u5df2\u7ecf\u5347\u7ea7\u523064\u4f4d\u7cfb\u7edf\uff0c\u6bd4\u598264\u4f4d\u76842003, win7\u6216\u8005win2008<\/p>\n

\u6709\u529e\u6cd5\u4f7f\u7528\u5417\uff1f<\/p>\n

\u56de\u7b54\u662f\u6709\uff0e\u4f60\u53ea\u8981\u628a\u670d\u52a1\u4e0aASE12.5.x\u5b89\u88c5\u597d\u7684ODBC\u76ee\u5f55\uff0c\u6bd4\u5982c:\\sybase\\ODBC\u5b8c\u6574\u6253\u5305\u590d\u5236\u5230\u5ba2\u6237\u673a\u7684\u56fa\u5b9a\u76ee\u5f55\uff0c<\/p>\n

\u6bd4\u5982\uff0c\u6211\u4e3a\u4e86\u56fe\u65b9\u4fbf\uff0c\u653e\u5230c:\\Sybase\u76ee\u5f55\u4e0b\u8fb9\uff0c\u5f62\u6210\u76ee\u5f55c:\\Sybase\\ODBC\u8fd9\u6837\u7684\u7ed3\u6784\uff0c\u6240\u6709\u7684odbc\u76f8\u5173\u7684dll\u90fd\u5728ODBC\u5b50\u76ee\u5f55\u4e0b\u8fb9\uff0e<\/p>\n

\u4f59\u4e0b\u7684\u5de5\u4f5c\u5c31\u662f\u7b80\u5355\u7684\u4e3a\u6ce8\u518c\u8868\u6dfb\u52a0\u5185\u5bb9\u4e86\uff1a<\/p>\n

\u5b8c\u6574\u7684\u6ce8\u518c\u8868\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n

Windows Registry Editor Version 5.00<\/p>\n

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ODBC\\ODBCINST.INI\\ODBC Drivers]
\n“SYBASE ASE ODBC Driver”=”Installed”
\n[HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ODBC\\ODBCINST.INI\\Sybase ASE ODBC Driver]
\n“AltDefaults”=”1”
\n“APILevel”=”1”
\n“ConnectionFunctions”=”YYY”
\n“CPTimeout”=”60”
\n“DriverODBCVer”=”04.10”
\n“FileUsage”=”0”
\n“SQLLevel”=”0”
\n“Driver”=”c:\\\\Sybase\\\\ODBC\\\\SYODASE.DLL”
\n“Setup”=”c:\\\\Sybase\\\\ODBC\\\\SYODASES.DLL”
\n“HelpRootDirectory”=”c:\\\\Sybase\\\\ODBC\\\\help”<\/p>\n

\u6ce8\u610f\uff0c\u4f60\u5982\u679c\u590d\u5236\u7684\u76ee\u6807\u8def\u5f84\u4e0d\u662fc:\\\\Sybase\uff0c\u90a3\u4e48\u4e0a\u8ff0.reg\u6587\u4ef6\u4e2d\u7684driver\u4ee5\u53casetup\u7684\u8def\u5f84\uff0c\u5c31\u8981\u505a\u76f8\u5e94\u8c03\u6574\uff0e<\/p>\n

\u6267\u884c\u5b8c\u8fd9\u4e2a.reg\u6587\u4ef6\uff0c\u4f60\u6253\u5f00\u547d\u4ee4\u884c\uff1a<\/p>\n

c:\\windows\\syswow64\\odbcad32\uff0c\u5c31\u53ef\u4ee5\u5728\u9a71\u52a8\u5217\u8868\u91cc\u770b\u5230Sybase ASE ODBC Driver\u8fd9\u4e2a\u9a71\u52a8\u4e86\uff0e<\/p>\n

\u6ce8\u610f\uff0c\u56e0\u4e3a\u662f\uff16\uff14\u4f4d\u7cfb\u7edf\uff0c\u6240\u4ee5\u6ce8\u518c\u9879\u8def\u5f84\u91cc\u591a\u4e86\u4e2aWow6432Node\uff0c\u5982\u679c\u662f\uff13\uff12\u4f4d\u5ba2\u6237\u673a\uff0c\u628a\u8fd9\u4e2a\u53bb\u6389\u5c31\u53ef\u4ee5\u4e86\uff0e\u5728CMD\u4e0b\u8f93\u5165odbcad32\u5373\u53ef\u51faODBC\u754c\u9762<\/p>\n

\"\"<\/p>\n

12.5 ODBC\u9a71\u52a8\u7684\u914d\u7f6e\u56fe.<\/p>\n

2. \u5982\u679c\u662f15.0\u4ee5\u53ca\u4ee5\u540e\u7684\u7248\u672c\uff0c<\/p>\n

odbc\u9a71\u52a8\u662f\u653e\u5230\u4e86c:\\Sybase\\DataAccess\\ODBC\\dll\u91cc\u5934\u4e86\uff0e(\u5047\u5b9ac:\\sybase\u662f\u4f60\u7684ASE\u5b89\u88c5\u76ee\u5f55\u7684\u6839\u8def\u5f84)<\/p>\n

\u4f60\u8981\u5728\uff16\uff14\u4f4d\u5ba2\u6237\u673a\u4e0a\u53d1\u5e03\u8fd9\u4e2a\u9a71\u52a8\uff0c\u4e5f\u53ea\u9700\u8981\u628ac:\\Sybase\\DataAccess\\ODBC\u590d\u5236\u5230d:\\\\SybaseASE_ODBC\\DataAccess\\ODBC\u4e0b\u8fb9\uff0e<\/p>\n

\u6267\u884c\u4e0b\u8fb9\u7684\u6ce8\u518c\u8868\u9879\uff1a<\/p>\n

Windows Registry Editor Version 5.00
\n[HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ODBC\\ODBCINST.INI\\Adaptive Server Enterprise 15.x]
\n“Driver”=”c:\\\\Sybase\\\\DataAccess\\\\ODBC\\\\dll\\\\sybdrvodb.dll”
\n“Setup”=”c:\\\\Sybase\\\\DataAccess\\\\ODBC\\\\dll\\\\sybdrvodb.dll”
\n[HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ODBC\\ODBCINST.INI\\ODBC Drivers]
\n“Adaptive Server Enterprise 15.x”=”Installed”<\/p>\n

\u5c31\u53ef\u4ee5\u628a\u76f8\u5e94\u7684\u9a71\u52a8\u6ce8\u518c\u4e3a\uff1aAdaptive Server Enterprise 15.x.<\/p>\n

\u5f53\u7136\uff0c15.0\u53ca\u4ee5\u540e\u7248\u672c\uff0c\u5982\u679c\u6709\uff16\uff14\u4f4d\u7684ODBC\u9a71\u52a8\uff0c\u4e0a\u8ff0\u8def\u5f84\u4e2d\u7684Wow6432Node\u5c31\u53ef\u4ee5\u4e0d\u8981\u4e86\uff0e<\/p>\n

\"\"<\/p>\n

\u5b9e\u9645\u4e0a\uff0c\u9488\u5bf915.0\u53ca\u4ee5\u540e\u7684ODBC\u9a71\u52a8\uff0c\u4f60\u53ef\u4ee5\u4e0d\u7528\u624b\u5199\u76f8\u5173\u6ce8\u518c\u8868\u9879\uff0c\u76f4\u63a5\u4e00\u4e2a\u547d\u4ee4\uff1a
\nc:\\>regsvr32 “c:\\Sybase\\DataAccess\\ODBC\\dll\\sybdrvodb.dll”<\/p>\n

\u5373\u53ef\u5b8c\u6210\u6ce8\u518c\uff0e\u8fd9\u6837\u6ce8\u518c\u5b8c\uff0c\u5f97\u5230\u7684\u9a71\u52a8\u540d\u662f\u5b98\u65b9\u6807\u51c6\u540d\uff1a”Adaptive Server Enterprise”.<\/p>\n

 <\/p>\n

\u9644\u4ef6Sybase.12.5.1.ODBC\u4e0b\u8f7d<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u8fd9\u91cc\u4e3b\u8981\u4ecb\u7ecd\u4e00\u4e0b\u8fd9\u4e9b\u9a71\u52a8\u7684\u6ce8\u518c\u65b9\u6cd5\uff1a 1. \u9488\u5bf912.5.x\u7684ASE\u5b89\u88c5\uff0c\u4f60\u53ef\u80fd\u4e00\u76f4\u5728\u4f7f\u7528\u8fd9\u4e48\u8001\u7684\u9057\u7559\u7cfb\u7edf\uff0c\u53c8\u820d\u4e0d\u5f97\u653e\u5f03\uff0c\u53ef\u80fd\u5176\u4e2d\u7684\uff2f\uff24\uff22\uff23\u9a71\u52a8\uff0c\u4f60\u8fd8\u5e0c\u671b\u5b83\u80fd\u7ee7\u7eed\u670d\u5f79\uff0c\u4f46\u662f\u5ba2\u6237\u673a\u5df2\u7ecf\u5347\u7ea7\u523064\u4f4d\u7cfb\u7edf\uff0c\u6bd4\u598264\u4f4d\u76842003, win7\u6216\u8005wi…<\/p>\n","protected":false},"author":1,"featured_media":67016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,7],"tags":[96,50,147],"topic":[],"class_list":["post-67022","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","category-server","tag-sybase","tag-50","tag-server"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/67022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=67022"}],"version-history":[{"count":3,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/67022\/revisions"}],"predecessor-version":[{"id":67032,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/67022\/revisions\/67032"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media\/67016"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=67022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=67022"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=67022"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=67022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}