My 1997 honda civic ex has no spark at spark plugs but has power in the distribbutor I have changed distributor,mainrelay,crankshaftposition sensor, and still no spark if any one knows what it may let me know

Replace the ignitor and coil:

https://www.askmehelpdesk.com/cars-trucks/faq-how-troubleshoot-repair-maintain-hondas-selected-other-vehicles-46563-4.html#post265896

Here's what the ignitor looks like:

http://shop.advanceautoparts.com/ProductDetail.aspx?MfrCode=BOR&MfrPartNumber=CBE619&PartType=194&PTSet=A

Here's what the coil looks like:

http://shop.advanceautoparts.com/ProductDetail.aspx?MfrCode=BAR&MfrPartNumber=1788171&PartType=190&PTSet=A

I have tried three different distributors I'm guessing that's not it but I will try changing it

Test all underdash and underhood fuses with a test light or multimeter.

Does the CEL come on for 2 seconds and then go off, when the ignition switch is turned to ON?

Many people on this site have had problems with even new aftermarket distributors for Hondas.

The cel light comes on and stays on

Perform K-Test on the ECM:

The K-Test: Remove the MAP Sensor connector and turn the ignition switch to ON (not start). Using a multimeter, check for 5 volts going between the MAP Sensor connector's reference wire (+) and ground. As you look at the connector, this is the socket on the right. Really press the black test lead into a cleaned main ECM ground on the thermostat housing. If the voltage is low, it's probably indicating ECM failure. Most failed ECMs will record a fraction of a volt. To me, the K-Test is simple, elegant, and accurate.

Likely, the ECM is bad, which explains why there's no spark.