connection not being stored in projects.settings file when published

We added a new Alpha DAO connection to our existing project.

Whenever we publish (either to a totally new location, or an existing location), this connection is not written to the a5_application.a5i file.

Does anyone know how to get this to update?

Thanks,

Earl

Make sure the connection is defined properly in the publishing Profile, not just under the Tools or Edit menu options. The connection string under the Profile can be different than the same connection defined elsewhere. That is because you might have a different connection parameters for the server than for your Development machine.

I had trouble with this for a long time. This works for me every time.

In your Web Project Profiles
Open Named Alpha DAO Connection Strings
Select the connection string then click edit connection string
Select Build Connection string
Re-build the connection string then save.
Publish your project
Stop and restart the server.

Frank,

Thanks - that definitely worked for me.

Earl

This was helpful to me as well. Particularly the "restart server"!

Bill.

Frank - Thanks! That solved it for my as well.

The V10 server caches the contents of the A5I file and does not watch the filesystem for updates. In order to get the server to recognize an updated A5I file, you must either use Server.ClearA5ICache() or restart the server.

Among the many enhancements for the V11 server is a greatly improved cache that not only performs much faster but also monitors the filesystem for any changes, negating the need to restart the server or manually clear the cache.

Quote:

---

Originally Posted by Steve Wood

Make sure the connection is defined properly in the publishing Profile, not just under the Tools or Edit menu options. The connection string under the Profile can be different than the same connection defined elsewhere. That is because you might have a different connection parameters for the server than for your Development machine.

---

This worked for me too.. wow. thanks. (fought with this for ages before finding this solution). THANK YOU!