Alpha Video Training
Results 1 to 2 of 2

Thread: Custom Connection String vs Named CS

  1. #1
    Member
    Real Name
    Jeff
    Join Date
    May 2008
    Posts
    149

    Default Custom Connection String vs Named CS

    I have function in an Ajax callback that pulls data from an MSSQL server. I need to have the connection string set in code, rather than from a named connection string.

    I created a named connection string for testing, and it works fine. When I copy and paste the connection string from the named connection string, it fails. Any ideas?

    This works:
    Code:
    csBW = "::name::marietta"
    This doesn't:
    Code:
    csBW = "{A5API='SQLServer',A5DBVersion=2008,Server='M-MARIETTA',A5ANSINullPadWarn=Default,UserName='a5reader',Password='XXXXXXXX',Database='KCWeb'}"
    The callresult.text from the failed attempt is this:
    Code:
    18456-'[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'a5reader'.
    SQL State is: 28000

  2. #2
    Member
    Real Name
    Jeff
    Join Date
    May 2008
    Posts
    149

    Default Re: Custom Connection String vs Named CS

    Never mind, appears that the encrypted password is not decrypted in the custom string. Entering the password in clear text works.

    Also my apologies, meant to post this in the web forums.

Similar Threads

  1. SQL Named Connection String Alias not replaced
    By christappan in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 11-28-2010, 10:39 PM
  2. cant find named connection
    By Steve Wood in forum Application Server Version 10 - Web/Browser Applications
    Replies: 16
    Last Post: 10-11-2010, 05:09 PM
  3. Named Connection String
    By TheMobileGuru in forum Alpha Five Version 10 - Desktop Applications
    Replies: 1
    Last Post: 09-23-2010, 06: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, 09:50 PM
  5. Named Connection string
    By urskumark in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 11-11-2008, 06: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
  •