What Airport Express network settings do i need for my iPad to work with Yamaha Stagemix App?

I don't actually have a Yamaha digital mixing console but I'm game to try to assist you with getting your iPad app working over the network.

First which Yamaha console do you have: LS9 or M7CL?

Regardless, the console by default, is a DHCP client and will attempt to get an IP address from the DHCP server built-in your router. If the AirPort Express is your main and only router than that is where it would be getting it from.

It this IP address that the iPad app needs to know in order to connect to the console. This is where I would strongly recommend that you configure the console with a static Private IP address instead so that the iPad can have an easier time "finding" it.

Yes the Airport Express is the only router in use and will not be connect to the internet as i only want to use it as a wireless access point.

Ok, so you will be using the Express as a standalone wireless network. By default, the Express will broadcast an unsecured wireless network with a network name (aka SSID) of something like: Apple Network NNNNNN. It will also have its DHCP server service enabled and providing IP addresses in the range of 10.0.1.2 - 10.0.1.200

The console is a M7CL and i can set its IP address on the console itself. By default it assigns itself 192.168.0.128 and also a subnet mask of 255.255.255.0 and has its own mac address of 00 A0 DE 6D C1 FA (with the IP and mac address required to be entered into the stagemix app settings). I assume the main problem is an IP address conflict?

That is correct! Both the console and the Express are on different network subnets. This can easily be resolved by either changing the console to be on the Express' subnet or change the Express to hand out IP addresses in the same subnet (192.168.0.n) as the console.

The wifi network (in the settings of the wifi network on my ipad) has a DHCP IP address of 10.0.1.2 and logging into Airport utility the Airport Express IP address is 169.254.96.172.

That would be the correct for the iPad when it connected to the Express' wireless network. The second address is normal if the base station is not connected to another router that is assigning it an IP address. This address is known as a "self-assigned" IP address. Again both of these would be "normal" in this situation.

The Airport Utility shows my Ipad as a wireless client but there is no sign of the wired console to the AE as a client.

Yep, and that would be because the console is configured to be on another network subnet.

Any idea what would be a better order and range of IP addresses? So as you said the network can find the console more easily.

You have two choices: 1) Use the DHCP Reservation feature of the Express to assign a static private IP address to the console in the 10.0.1.x subnet, or 2) Change the subnet that the Express is on to the same one that the console is using. I would recommend the former. Both of these can be done via the AirPort Utility.

You're very welcome! I'm glad you got it worked out.

Having the same issues. So at the end of this, what were the settings for your ipad, for your airport express and for the M7?