I made a WEBservice pb11.5, complete the function of the client query a DW, if by ds2 create (dwsyntax, ls_error), you can succeed, and can return data, but if I use the ds2 dataobject='d_aa' way to different environment results,
I installed the pb11.5 local, web service deployed in the local, can extract the data; If the service deployment to other machines and other machines installed pb11.5 environment, but not installed pb11.5, success is the first one, the second failure,

1, ds2. Create (dwsyntax ls_error)
Ds2. Settransobject (sqlca)
I=ds2. Retrieve ()
If I=1 then
MSG="extraction failure"
End the if
2,
Ds2. Dataobject='d_aa'
Ds2. Settransobject (sqlca)
I=ds2. Retrieve ()
If I=1 then
MSG="extraction failure"
End the if
Environment that is should be I feel wrong, but I've been on the server will I know the relevant DLL files are copied to the bin directory,

CodePudding user response:

What is the relationship between this code and webservice you? It should not be this problem

CodePudding user response:

After debugging, obviously results: ds2 dataobject='d_aa' this statement is, in fact don't succeed, don't know why, and local deployment can be successful, deploy to other machines is not successful,

CodePudding user response:

Do you have a couple of PBL ws? Traverse the list it all data window object

CodePudding user response:

As a group, are DW need to separate a PBL?

CodePudding user response:

I mean, I just give you the code, ds2. Dataobject='d_aa' successful or not, and whether webservice should it doesn't matter, you still watch this' d_aa 'does not exist, pb8 is also one of the means, so let you traverse all of the data window object

CodePudding user response:

Exist, this is very sure, after all I was testing, there is not much stuff, and local deployment can success, so there must be, otherwise also retrieve out, but after deployment to other machines, we can not successful, so I guess is not complete can lead to a DLL, or the environment, the difference of my machine and other machine is a pb environment problem, under the share I copy all the DLL, or no, very strange,

CodePudding user response:

And as a group, will not forget to copy a PBD problems

CodePudding user response:

If you want to use ds2 dataobject='d_aa'
You need to create a PBR resource file, the content is as follows:
Aa. PBL (d_aa)
Then add resource files in the project file and then compile

CodePudding user response:

Let me answer your question, but I did not find very good solution, can discuss together, because you are pb11.5 d_aa data sources, using getsqlselect () may have a look, to return to the SQL statement is a select "tablea". "columna" from "tablea" format, if you are one of the quotes on to remove, then perform certainly can succeed,

CodePudding user response:

Well, just meet the problem, has been solved,
See is less a pbdwe90. DLL files,,,

CodePudding user response:

PB webservice needs to use the.net environment. You of the.net environment

CodePudding user response:

Should be a corresponding PBD file is not copied to the release of the directory server xxx_root/file/.. Folder, released in native directory search PBD file can be found,