Alpha Video Training
Results 1 to 5 of 5

Thread: publish grid w/ different connection string from Project Named AlphaDAO connection

  1. #1
    Member
    Real Name
    Ken
    Join Date
    Jun 2010
    Posts
    115

    Default publish grid w/ different connection string from Project Named AlphaDAO connection

    How do you publish another grid with a different connection string from the Named AlphaDAO connection string in the project?

    Error opening Grid table/view: Internal Error - Can't find named connection
    'sqlSDSv4' - while converting named connection to connection string

    This worked fine when I did live preview.

    my connection string for grid is
    {A5API='SQLServer',A5DBVersion=2008,Server='(local)',A5ANSINullPadWarn=Default,Trusted_connection=yes,Database='SDSv4'}

    my project profile was created using Named AlphaDAO connection strings
    {A5API=Access,FileName='C:\Local\CMA2010.mdb',UserName='Admin'}

    How do you publish another grid with a different connection string from the Named AlphaDAO connection string in the project?

  2. #2
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,656

    Default Re: publish grid w/ different connection string from Project Named AlphaDAO connectio

    In the Query (alphaDAO), under Connection Type, you can choose specify connection string rather than Named Connection.
    Your error states it cannot find sqlSDSv4 whereas your connection string lists just SDSv4. Is that a typo perhaps?

    Stephen

  3. #3
    Member
    Real Name
    Ken
    Join Date
    Jun 2010
    Posts
    115

    Default Re: publish grid w/ different connection string from Project Named AlphaDAO connectio

    Thanks for the reply

    sqlSDSv4 is the named connection string :{A5API='SQLServer',A5DBVersion=2008,Server='(local)',A5ANSINullPadWarn=Default,Trusted_connection=yes,Database='SDSv4'}

    My project profile started with ALphaDAO on the name Connection String CMA which is an MS Access database.
    SDSv4 is SQL Server 2008

    Can you use both MS Access and SQL Server in the same Project Profile?

  4. #4
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,656

    Default Re: publish grid w/ different connection string from Project Named AlphaDAO connectio

    Sorry Ken, I misunderstood.
    I just did a quick test and added a Northwinds Access table as a grid to my SQL project and it seems to work fine.
    At least when published to localhost.

    Stephen

  5. #5
    Member
    Real Name
    Ken
    Join Date
    Jun 2010
    Posts
    115

    Default Re: publish grid w/ different connection string from Project Named AlphaDAO connectio

    I appreciate that.

    I went back and republished again.
    I saw this from Frankbicknell

    http://msgboard.alphasoftware.com/al...when-published

    I followed this:
    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. "

Similar Threads

  1. Error converting named connection to connection string
    By michaelxcampbell in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 09-21-2011, 03:38 PM
  2. Custom Connection String vs Named CS
    By marvinbase in forum Alpha Five Version 10 - Desktop Applications
    Replies: 1
    Last Post: 02-17-2011, 06:08 PM
  3. Named Connection String
    By TheMobileGuru in forum Alpha Five Version 10 - Desktop Applications
    Replies: 1
    Last Post: 09-23-2010, 07:20 PM
  4. Named connection string in runtime
    By joellustigman in forum Alpha Five Version 10 - Desktop Applications
    Replies: 2
    Last Post: 07-14-2010, 10:50 PM
  5. Named Connection string
    By urskumark in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 11-11-2008, 07:08 AM

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
  •