Alpha Video Training
Results 1 to 8 of 8

Thread: connection not being stored in projects.settings file when published

  1. #1
    Member
    Real Name
    Robert Earl Allin
    Join Date
    Apr 2009
    Location
    Toronto, Ontario
    Posts
    241

    Default 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

  2. #2
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,834

    Default Re: connection not being stored in projects.settings file when published

    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.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  3. #3
    "Certified" Alphaholic
    Real Name
    Frank Bicknell
    Join Date
    Feb 2010
    Location
    39.1915° N, 84.4348° W
    Posts
    2,467

    Default Re: connection not being stored in projects.settings file when published

    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.

  4. #4
    Member
    Real Name
    Robert Earl Allin
    Join Date
    Apr 2009
    Location
    Toronto, Ontario
    Posts
    241

    Default Re: connection not being stored in projects.settings file when published

    Frank,

    Thanks - that definitely worked for me.

    Earl

  5. #5
    VAR
    Real Name
    Bill Parker
    Join Date
    Apr 2000
    Location
    Dallas, TX
    Posts
    1,709

    Default Re: connection not being stored in projects.settings file when published

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

    Bill.

  6. #6
    Guest
    Real Name
    Kate Patrick
    Join Date
    Mar 2011
    Location
    Shreveport, LA
    Posts
    26

    Default Re: connection not being stored in projects.settings file when published

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

  7. #7
    Alpha Software Employee Lenny Forziati's Avatar
    Real Name
    Lenny Forziati
    Join Date
    Nov 2001
    Location
    Alpha Software
    Posts
    4,682

    Default Re: connection not being stored in projects.settings file when published

    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.

    Lenny Forziati
    Vice President, Internet Products and Technical Services
    Alpha Software Corporation

  8. #8
    Member leetv's Avatar
    Real Name
    Lee Taylor-Vaughan
    Join Date
    Aug 2010
    Location
    Hillsborough, NJ/Avondale, AZ/Sheffield, UK
    Posts
    352

    Default Re: connection not being stored in projects.settings file when published

    Quote Originally Posted by Steve Wood View Post
    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!

Similar Threads

  1. Where are connection strings stored
    By cFlat7 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 4
    Last Post: 11-09-2010, 01:31 PM
  2. Web projects published to an remote server using sub projects do not work.
    By MichaelCarroll in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 12-05-2009, 04:42 AM
  3. active link table connection settings
    By martinwcole in forum Alpha Five Version 9 - Desktop Applications
    Replies: 0
    Last Post: 06-17-2009, 06:28 PM
  4. File extensions and default directory settings
    By keithwilhoit in forum QReportBuilder
    Replies: 2
    Last Post: 05-29-2008, 11:20 PM
  5. Settings in a text file
    By richkerr in forum Alpha Five Version 6
    Replies: 2
    Last Post: 01-03-2005, 05:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •