PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

HCM 8.9 / 8.47 MSSQL 2005 upgrading to HCM 9.1 / 8.52 / MSSQL 2008. SQL Server Native Client Compati

edited Feb 22, 2012 10:34AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓
HCM 8.9 / 8.47 MSSQL 2005 upgrading to HCM 9.1 / 8.52 / MSSQL 2008.    Issue, 8.49 Demo is on MSSQL 2005, new 8.52 demo is on MSSQL2008.    On my Client machine where Change assistant (8.52) is installed, I can connect to both databases using apps. designer, data mover, etc.   However when I try to use Change Assistant and configure the environment, the "test Connection" fails when I try to access the MSSQL 2005 environment.    Tracing gives the following message. 

 1-6      09.15.02    0.003000 Cur#0.1952.HCM89DMO RC=0 Dur=0.000000 XER rtncd=0 msg=Invalid SQL Server version (minimum is SQL Server 2008) (SQLSTATE PS078)

My question is, can you connect to both a MSSQL 2005 and 2008 using SQL Server Native Client 10.0?    I have installed a DSN for both the 32 bit version and 64 bit version, but it still doesn't work.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center