Frequently
Asked Questions (F.A.Q.)
|
Enterprise
Software F.A.Q.
|
| |
|
Q.
We're using your Enterprise 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 downloaded
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 obtain the
DB-Library DLL from SQL Server version 6.5, SQL Server 7.0, or SQL
Server 2000. For MS SQL Server 2005 and higher you should
connect using ADO instead.
|
|
Q.
I'm using Microsoft SQL server with your Enterprise edition
software. I'm having a problem and want to send you our data so you can
try to reproduce it and fix it. How can I send you our data?
|
|
A. Unlike other
large database servers, MS SQL Server does not have a
function to backup data to a SQL INSERT script. You will need to use a
third party utility to backup the data to a SQL script. Alternatively
you could export each table to CSV format. Sending in a MS SQL Server
backup file will not work.
|
|
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.
|
