MYOB ODBC 连接错误
我最近得到了一个预构建应用程序,它使用 MYOB ODBC 连接到 MYOB 文件。 ODBC 连接在该应用程序中运行良好。
我在另一个应用程序中使用相同的 ODBC 连接字符串,但无法在该应用程序中打开。连接字符串完全相同,但在那里不起作用。
我收到的错误是:
错误 [IM002] [Microsoft][ODBC 驱动程序管理器] 未找到数据源名称且未指定默认驱动程序
Visual Studio 2008 中的服务器资源管理器可以正常连接相同的连接字符串。
这是一个受信任的应用程序问题,因为我的新应用程序目前尚未进行数字签名吗?
OdbcConnection odbc = new OdbcConnection("Driver=MYOAU0901;TYPE=MYOB; UID=Administrator; PWD=; DATABASE=C:\\Premier125\\Clearwtr.MYO; NETWORK_PROTOCOL=NONET; DRIVER_COMPLETION=DRIVER_NOPROMPT;;KEY=****");
odbc.Open();
连接字符串中使用的密钥绝对有效。
请帮助我。
I recently got a prebuild application which is uses a MYOB ODBC connection to a MYOB file.
The ODBC connection works perfectly in that application.
I'm using the same ODBC connection string in another application but it failed to open in that application. The connection string is perfectly identical but it won't work there.
The error I'm getting is:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The server explorer in Visual Studio 2008 connects without a problem with the same connection string.
Is it a trusted application issue because my new application is not digitally signed at the moment?
OdbcConnection odbc = new OdbcConnection("Driver=MYOAU0901;TYPE=MYOB; UID=Administrator; PWD=; DATABASE=C:\\Premier125\\Clearwtr.MYO; NETWORK_PROTOCOL=NONET; DRIVER_COMPLETION=DRIVER_NOPROMPT;;KEY=****");
odbc.Open();
The key used in the connection string is definitely valid.
kindly help me.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
MYOB ODBC 不需要对您的应用程序进行签名。公司文件必须注册 ODBC 才能允许读取,并且您必须安装许可证密钥才能允许写入。我假设您的新应用程序与公司文件和 MYOB 可执行文件在同一台计算机上运行,并且您的公司文件已正确注册。
MYOB ODBC does not require your application to be signed. The company file must be registered for ODBC to allow reads, and you must install a licence key to allow writes. I am assuming your new application is running on the same machine as the company file and MYOB executable, and that your company file is properly registered.