The problem

On Windows 2003 Web Edition, I set up PHP correctly, but keep getting the following error:

Test Database Could not connect to the specified database. The following error was returned: Error in ConnectToDB: . You said: .. For help, please consult the User Guide or http://support.envent.co.za.

Why does it occur?

Well, usually the solution would be to load Microsoft SQL Server 2000 client tools onto the web server that PHP is on and be done with it, but according to Microsoft's Knowledge Base, this version of Windows doesn't allow the client tools to be loaded...

The proposed solution

Before going any further, please make sure that you have copied the latest client driver file (ntwdblib.dll) from the database server's SYSTEM32 directory (either C:\WINDOWS\SYSTEM32 or C:\WINNT\SYSTEM32) into the Windows 2003 Web Edition's SYSTEM32 directory. If that doesn't solve the problem, continue with these steps:

1. Go to Start > Programs > Administrative Tools > Data Source (ODBC) and you will see:

2. Click on add

3. Now fill in the details as per the screen shot, and select your database either through the drop down or by putting its name in place. Then click Next >.

4. Enter all the correct usernames and passwords and click on Client Configuration.

5. Enter your server's alias (use the server name), then click on TCP/IP, enter the computer's name and make sure Port number is set to 1433. Now hit OK and Next >.

6. Tick Change the default database to, and select or type in your DB's name. Click Next > and on the next screen click Finish.

7. A little box will popup with all the details of the connection you have made, click Test Data Source, and if all is well, click OK and then OK again.

8. Now in Ensight, select the options as above and put the server alias/IP of server as per client configuration and then click Next >> to test.

Have a question about Ensight's functionality? Drop us a line using the form below and we'll get back to you with feedback within 24 to 48 hours (or 72 hours on weekends)

First Name

Surname

E-mail Address

Type of comment -------Question Bug Feature Suggestion Other

Comment

Enter the word displayed above: