Copy that file to a file called php. Easysoft provided excellent support and advice on the launch of our new data infrastructure. I just wanted to let you know about the exemplary service I received from one of your support staff yesterday. Comments Sign in or register to add and subscribe to comments. In the Database Name and Database Alias fields, enter mosql.

Uploader: Tejora
Date Added: 7 October 2004
File Size: 40.24 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 15909
Price: Free* [*Free Regsitration Required]

Your configuration for Odc is now complete, now let’s execute a simple script from the command line to test our set up. We highly recommend Easysoft, their technical support is outstanding and the service we have received from then is both professional and efficient. This port number is set in the Configuration Manager.

Configuring the ODBC Driver – Operations Center SQL Views Guide

To reconfigure the driver: This derb shows how to provide all this information by cataloging the node. Now make sure php. Copy the contents of Listing 1 into a file called test.

You also need to provide a name for this node; for example purposes, call it CNS. Version Platform Distribution v1.

Apache Derby Users – ODBC Driver for Derby?

Open a db2cmd window and catalog the CNS node to access localhost on portas shown below:. Use the following commands to uncatalog the database and node in DB2. The general set up process involves setting up a database and node in the DB2 database catalog. Moira Casey Published on September 30, Been using your drivers for many years now and we are impressed with the quality and price of them. First, identify the host and port that the remote database is running on. If ij doesn’t work, your PHP connection isn’t likely to work either.


Easysoft Derby ODBC Driver

You’ll see a window appear similar to the image below. Copy the file test.

Sign in or register to add and subscribe to comments. At the time of the release of Operations Center 5. Finally, catalog the database as an ODBC data source.

Connecting PHP Applications to Apache Derby

The Easysoft driver was indeed excellent, easy and reliable. Whenever we need them for assistance or advice, the team at Easysoft is always a phone call away and ready to help.

Enter the user name for a user account with admin privileges dsrby the User ID field and the corresponding password in the Password field. Once you add these entries you will need to stop and start Apache for the changes to take affect.

In the Host name field, specify the host name of the Operations Center server. This section tests your PHP connection to Derby.

The following commands use the database name mosql and the node name fnode:. As always, our support team is on hand to help you with any difficulties or questions you may have with this driver. The integration into our databases and the assistance given with bulk uploads and a general helpful attitude was outstanding. To check if the previous steps worked correctly to create the ODBC data source for the DB1 database, issue this command:. Go edrby the DB2 command prompt and enter the Uncatalog db mosql command: It translates application data queries into commands understood by the DBMS.


After reinstalling Operations Center, it is sometimes necessary to reconfigure the command line driver. ODBC provides the middle link that lets you do exactly that.

If necessary, replace these with the names used in your system. The commands shown above will fail if the node or database is ddrby catalogued.