{“ERROR [08004] [ODBC firebird driver]不可用数据库”}问 [英] {“ERROR [08004] [ODBC firebird driver]unavailable database”} ask

问题描述

有一个odbc连接，连接到WMS数据库（我相信它们仅支持odbc），并且在连接打开时获得异常{ERROR [08004] [ODBC Firebird Driver]不可用数据库}。 WMS服务器&客户端组件安装在我的代码也运行的机器上。下面的连接字符串



DRIVER = Firebird / InterBase（r）驱动程序; UID = SYSADMIN; PWD = MASTERKEY; DBNAME = C：\ Sample \Db.FDB ;



我对如何继续无能为力。一些已经看到的答案说，一次只有一个应用程序可以访问数据库。在这种情况下，我如何找到其他人试图访问此数据库并停止？



我的应用程序是一个Windows窗体应用程序，现在代码在调试模式下运行。 />


谢谢

Nishitha



我的尝试：



在不同网络中的另一台计算机上尝试，其中WMS正确安装在网络中的其他计算机上。连接失败。

Have an odbc conenction, to connect to a WMS database (I believe they support odbc only) and on connection open gets the exception {"ERROR [08004] [ODBC Firebird Driver]unavailable database"}. The WMS Server & Client components are installed on the machine where my code also runs. Conenction string below

"DRIVER=Firebird/InterBase(r) driver; UID=SYSADMIN; PWD=MASTERKEY; DBNAME=C:\Sample\Db.FDB;"

I am clueless on how to proceed. Some of the already seen answers says, only one application can access the db at a time or so. In that case how I find who else trying to access this db and stop?

My application is a windows forms application and now the code runs in debug mode.

Thanks
Nishitha

What I have tried:

Tried on another machine in a different network, where WMS is installed correctly on a different machine in the network. There as well connection fails.

推荐答案

你必须安装 Firebird： ODBC驱动程序 [ ^ ]

必须使用'localhost：'为dbpath添加前缀，密码为小写。这帮助我连接。但是由于我必须获得在ODBC中受限的模式信息，所以转移到使用FireBirdClient，即Firebird Ado.Net提供程序。

Had to prefix dbpath with 'localhost:' and password was in lower case. That helped me to connect. But since I had to get schema info, which was limited in ODBC, moved to using FireBirdClient, that is Firebird Ado.Net provider.

这篇关于{“ERROR [08004] [ODBC firebird driver]不可用数据库”}问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！