Hi,
I upgraded our SQL server database for Primavera from v7 to 16R2. No problem connecting to the database from Management Studio.
Installed P6 Professional R16.2-64bit on my laptop Win 7 OS. When I tried to configure database connection, I got a Runtime error R6034 An application has made an attempt to load the C runtime library incorrectly. Please contact the application's support team for more information. This error was encountered after the step when Host Name and database name was entered and clicking next.
Anyone encountered similar issue?
Thanks for any help.
here is the p6 fix
#include <sqlca.h>
#include <oci.h>
int __declspec(dllexport) get_empno(OCIExtProcContext *epctx)
{
int empno=0;
EXEC SQL REGISTER CONNECT USING :epctx;
EXEC SQL SELECT empno INTO :empno FROM emp where ename='KING';
return(empno);
}
set MSVCDIR="D:\Program Files\Microsoft Visual Studio 9.0\VC"
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to load DLLERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to load DLL
First, however, it will need to have the manifest incorporated into it or the following error will result at runtime:
==================================
Runtime Error!
Program: d:\oracle\product\11.2.0\dbhome_1\bin\extproc.exe
R6034
An application has made an attempt to load the C runtime library incorrectly.
Please contact the application's support team for more information.
To create the manifest, move the VS2010 command prompt into the MSVCRT redistributable folder and issue the following:
mt.exe -manifest Microsoft.VC90.CRT.manifest -outputresource:msvcr90.dll;2
for further information, refer to MSDN Documentation
and create the library, create the procedure wrapper, and test it by running the code below
/
create library empnolib as 'D:\oracle\product\11.2.0\dbhome_1\bin\getempno.dll';
/
create or replace function get_empno
return binary_integer as
external library empnolib
name "get_empno"
language C
with context
parameters(context);
/
select getempno from dual;
https://msdn.microsoft.com/en-us/library/ms235560(VS.80).aspx