Frequently Asked Questions (F.A.Q.)

If you have a technical question that we have not answered here, please email us and we will get back to you within 48 hours.


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.

For MS SQL Server 2005 and higher you should connect using ADO instead of MSSQL. The following video shows how to setup ADO to work our software: MS SQL ADO Setup

For older versions of Microsoft SQL Server you can just install the MS SQL client software or just copy the Ntwdblib.dll file to the Windows System folder (\winnt\system32 on XP).

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.