I have a server with a dozen connections on the SQL*Server 2008 adapter, but I'd like to move them to the SQL*Server 2012 Adapter. Is there an easy way to do this? If I recall correctly the 2012 version disappears once you choose the 2008 version.

The result is that I can't configure a connection for 2012 unless I delete all my connections for 2008. I guess I could comment them out in the edasprof and then swap out? What config file holds where the adapter choice is recorded?

This message has been edited. Last edited by: <Emily McAllister>,

Its in your edaserve.cfg

[Adapters]
jvm_rel = 16
ora_access = y
ora_rel = 11
ora_oci = y

you'll see

mss_access = y
mss_rel = 2008

Via the console, if you comment out your connections in edasprof, you can remove the MS SQL 2008 adapter (the server will restart the running/idle agents, but not the server), and then add the MS SQL 2012 adapter, you'll see

mss_access = y
mss_rel = 2012

Thank you very much!

Fair warning to those following this path -- if you comment out your connections in edasprof and then remove the adapter, the commented-out lines will be deleted! You will lose all your connection strings even if they are commented out. Make a copy to another file before performing this trick.

re "the commented-out lines will be deleted" - Thanks for the warning!