jdbc error while connecting oracle 12c in Coldfusionmx7

-

we have set of applications in coldfusion mx7 oracle 11g database.

connected datasources in coldfusion using jdbc thin driver. coldfusion server has ojdbc14.jar in c:\coldfusionmx7\lib

 

 

the oracle version has been upgrade 12c.

the application throws "ora-28040: no matching authentication protocol"

 

 

we googled , found jdbc driver used not compatible , suggested

1. change ojbc14.jar ojdbc6.jar in c:\coldfusionmx7\lib, restart coldfusion server , start mapping datasources.

2. set sqlnet.allowed_logon_version_server=8 in oracle/network/admin/sqlnet.ora file.

 

 

please give clear suggestion

1. whether downloading ojdbc6.jar oracle website , placing in c:\coldfusionmx7\lib instead of ojdbc14.jar

will work properly- compatible mx7?

2. adding server version "sqlnet.allowed_logon_version_server=8" in sqlnet.ora file or

do have specify sqlnet.allowed_logon_version_client=8 also. if so, have restart database

server make effective?

 

 

thanks

i doubt working intend. 12c support available on cf11. older version have had luck getting working talking cf9/10. mx7 may have further complications.

 

generally think way older version add sqlnet.allowed_logon_version_client=8 sqlnet.ora. think people using trick using version of cf supports 11g though. mx7 supports 10g.

 

you have try ojdbc6.jar or ojdbc7.jar see if makes difference when trying cf. ojdbc7.jar 12c jdbc driver.

 

any changes make require service restarts.



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Soustraire une selection

-
Image
bonjour,   une image sera plus parlante pour expliquer mon problème : je souhaite appliquer une couleur/texture pour mes routes, j'ai donc utiliser l'outil plume pour délimiter le contour qui m'intéresse. or celui-ci comprend les terres pleins, auxquels je souhaite appliquer une autre couleur/texture, même problème pour le rond point par exemple. comment puis-je soustraire une sélection (pas sur du terme) pour retrouver un terre plein blanc svp ?   sur photoshop cela correspondrait soustraire une selection     en espérant avoir été clair !   merci bcp ! More discussions in Illustrator adobe
Read more

After Effects: could not find dvaeve_dialogs.txt

-
hello,   i getting error message when trying launch application:   after effects warning: file 'c:\program files\adobe\adobe after effects cs6 \supportfiles\dvaeve_dialogs.txt' not found.   the application working fine without issues until today. there has been no system changes on computer either.   any ideas on how resolve issue?   thank reinstall prgram.   mylenium More discussions in After Effects adobe
Read more

Illustrator cs6 "Invalid Serial Number"

-
i trying re-install adobe illustrator cs6 on new machine users old machine being retired. when enter serial no invalid message. i work ministry of transportation, ontario , purchased volume licensing. make things better, original person deployed doesn't work here anymore. have following if needed:   order number end user purchase number reseller purchase order number agreement number   please help chris for licencing issues have contact adobe support directly no 1 in forum can or here. More discussions in Adobe Licensing adobe
Read more