Alpha Video Training
Results 1 to 2 of 2

Thread: SQL Server 2012 Dynamic Connection

  1. #1
    Member
    Real Name
    Miles Nolan
    Join Date
    Jan 2008
    Posts
    270

    Default SQL Server 2012 Dynamic Connection

    Hi All

    has anybody any previous experience of SQL server 2012 and dynamic connections ?, we have recently ported a project to a windows 2008 server running SQL 2012 ,

    All works fine under a sql 2008 platform

    However now, when using any Dialog with a dynamic connection we get an "Function requested is not supported" error message, if we change the same dialog to a named connection that does not use the Dynamic connection all works well and the record updates.
    Additionally , when using grids we are now unable to insert any records , where as edit appears to work OK for us ...

    Any help greatly appreciated

    thanks
    john

  2. #2
    "Certified" Alphaholic
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    1,223

    Default Re: SQL Server 2012 Dynamic Connection

    Did you ever find a solution for this? I'm using SQL Server 2008. This is the first time I've tried to use a grid to call a dialog to edit. When I use dynamic connection it fails with "cannot connect to database". Of course this dynamic connection string works on over 35 components. Just not on the dialog. When I change the connection string so that it is NOT dynamic it works perfectly. Another thing that makes it hard to track down is that it works in test, but not on my server.

    Is anyone using dynamic connection strings that calls a grid to edit a dialog? So the connection works for the grid, but fails at the dialog.

    Miles did you ever figure this out?
    Last edited by lvasic; 06-20-2013 at 12:02 PM.

Similar Threads

  1. Microsoft SQL Server 2011 or 2012
    By BillWFG in forum Application Server Version 11 - Web/Browser Applications
    Replies: 3
    Last Post: 01-14-2013, 08:42 AM
  2. SQL Server 2012 Connection Problem
    By Scott B in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 10-03-2012, 12:33 PM
  3. AlphaDAO & Upsize Genie Support for SQL Server 2012
    By Tarek in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 03-09-2012, 12:19 PM
  4. unable to attach sql connection string to grid ver 2418-3872 (01/20/2012)
    By gdcorp in forum Application Server Version 11 - Web/Browser Applications
    Replies: 2
    Last Post: 02-15-2012, 03:23 PM
  5. SQL connection string for server
    By Pat Bremkamp in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 10-02-2008, 11:15 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
  •