Development environment for a 64 - bit windows2008 R2, a 64 - bit oracle 11 g, development tools for the original concept 9, original concept through 32 instant client connection, now must run run in PB (' a. at ') to perform SQLLDR import large quantities of data, but in the process of running, an error:
The Message 2100 not found; No message the file for the product=RDBMS, facility=ULMessage 2100 not found; No message the file for the product=RDBMS, facility=UL

How do you deal with? In this thanked!

CodePudding user response:

Should be you a. ats has a problem, or is a question of authority, can also be a 64 - bit

CodePudding user response:

reference 1st floor lzp_lrp response:

should be your a. ats has a problem, or is a question of authority, also can is a question of 64

Why will have so many to be the problem? Ha ha, I directly executed under windows2008 a. there is no question of the at, not just write PB applications, and don't know is why

CodePudding user response:

refer to the second floor marsmq response:

Quote: refer to 1st floor lzp_lrp response:

Should be you a. ats has a problem, or is a question of authority, also can is a question of 64

Why will have so many to be the problem? Ha ha, I directly executed under windows2008 a. there is no question of the at, not just write PB applications, and don't know why is

Try the shellexecute the API function

CodePudding user response:

reference lzp_lrp reply: 3/f

Quote: refer to the second floor marsmq response:

Quote: refer to 1st floor lzp_lrp response:

Should be you a. ats has a problem, or is a question of authority, also can is a question of 64

Why will have so many to be the problem? Ha ha, I directly executed under windows2008 a. there is no question of the at, not just write PB applications, and don't know why is

Try using the API shellexecute function performs

How to write the function in the PB scripts?

CodePudding user response:

This should be the problem of unable to connect to the database, the first two weeks, I use oracle 11 g 64, PB11, PB12.5 also unable to connect to the database, change to return to oracle 11 g 32-bit only, it is indifference,

CodePudding user response:

reference 5 floor PaulPaul reply:

this should be the problem of unable to connect to the database, the first two weeks, I use oracle 11 g 64, PB11, PB12.5 also unable to connect to the database, change to return to oracle 11 g 32-bit only, it is called flints,

PB connect DB Profile itself without any problem, just put the wrong in the program execution SQLLDR

CodePudding user response:

API declaration

The Function ulong ShellExecuteA (ulong HWND, ref string lpOperation, ref string lpFile, ref string lpParameters, ref string lpDirectory, int iShowCmd) Library "Shell32. DLL" ALIAS FOR "ShellExecuteA; ANSI
"

String ls_path, ls_file
The integer li_pos, li_value
String ls_appl_file ls_temp, ls_data
String ls_syspath, ls_win16_path

String ls_Operation, ls_exe
String ls_Parm
The Integer li_cmd

Ls_path="a. at"
SetNull (ls_Parm)
Li_cmd=1//Normal=1, Minimize=2, Maximize=3
Ls_Operation="Open"
Li_value=https://bbs.csdn.net/topics/gnv_base.ShellExecuteA (Handle (This), ls_Operation, ls_path, ls_Parm, ls_Parm, li_cmd)

CodePudding user response:

Are too busy this week, next week to try upstairs warrior, thanks a lot!

CodePudding user response:

refer to 6th floor marsmq response:

Quote: refer to the fifth floor PaulPaul reply:

This should be the problem of unable to connect to the database, the first two weeks, I use oracle 11 g 64, PB11, PB12.5 also unable to connect to the database, change to return to oracle 11 g 32-bit only, it is called flints,

PB connect DB Profile itself without any problems, just in the program execution SQLLDR put the wrong

I passed the test, to install Oracle 11 g 32-bit client, connection Oracle, was no problem,
PB12.5, it seems, is still a 32-bit system, will not be able to use 32 bit Oracle client