Frequently
Asked Questions (F.A.Q.)
| Enterprise
Software F.A.Q.
|
| |
| Q.
We're using your Enterrpise software with Microsoft SQL Server. On some
of the client machines when we try to connect why do we get a
Ntwdblib.dll not found error?
|
A.
Each client needs special connectivity libraries installed. If these
libraries are not installed the clients will not be able to connect to
the database server. These libraries are available from the vendor of
the database server you are planning to use. An easy way to get these
libraries is to install the database client software. This client
software should be available on their install CDs or can be downloded
from the vendor's web site. For Microsoft SQL Server you can just copy
the Ntwdblib.dll file to the Windows System folder (\winnt\system32 on
XP). Note that MS SQL Server 2005 does not have this dll. You must have available the DB-Library DLL from SQL Server version 6.5, SQL Server 7.0, or SQL Server 2000.
|
| Q.
I'm trying to use your Enterprise edition
with MySQL version 5. When trying to connect I get the error: "SQL
Error: Client does not accept authentication protocol requested by
server. Consider upgrading MySQL client". Does your software not work
with MySQL v5?
|
A. This
software will run on MySQL v5. However, it connects as a v4 client.
This means you will have to convert the connection password to the
older style. You can do this with a query like the following:
SET
PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('magic');
See
also: http://dev.mysql.com/doc/refman/5.0/en/old-client.html
|
| Q.
what permissions should be given to the Database
Server Account for the clients?
|
A. The user
needs SELECT, INSERT, UPDATE and possibly CREATE_TMP_TABLE privileges.
|
