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
installed. If these
libraries are not installed the
clients will not be able to
the database server.
SQL Server 2005 and higher you
connect using ADO instead of
MSSQL. The following video shows
how to setup ADO to work our
SQL ADO Setup
older versions of Microsoft SQL
Server you can just install the
MS SQL client software or just
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.