Pipe-object within PB-app

This is a multi-part message in MIME format.

---=_forums-1-dub4c514892
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

Hello! I try to pipe data between a SqlAnyWhere-db to a
MS-SqlServer-db but it won't work. It returns code -4 and
give me no clue what the problem is. The pipe-object is
encapsulated in a transaction-object. I do have a succesfull
connection in both source- and destination-connection but it
won't work anyway.
Anyway it works when executed from PB-painter (but not from
the app) I would highly appreciate if anyone has an idea
about the problem.

---=_forums-1-dub4c514892
Content-Type: text/plain; name="pipe_object.txt"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="pipe_object.txt"

Ly8gUGlwZS1vYmplY3QgcGlwZV9rb250b25fc2FfdG9fc3M6DQovLyBFY29u
b215IGlzIGEgU3FsQW55d2hlcmUtZGIsIE1TU19FQ09OT01ZIFNxbFNlcnZl
ci1kYg0KDQpQSVBFTElORShzb3VyY2VfY29ubmVjdD1FY29ub215LGRlc3Rp
bmF0aW9uX2Nvbm5lY3Q9TVNTX0VDT05PTVksdHlwZT1yZWZyZXNoLGNvbW1p
dD0xMDAsZXJyb3JzPTEwMCxrZXluYW1lPSJrb250b24iKQ0KU09VUkNFKG5h
bWU9ImtvbnRvbiIsQ09MVU1OKHR5cGU9dmFyY2hhcixuYW1lPSJrdG9fbnIi
LGRidHlwZT0idmFyY2hhcigxNSkiLGtleT15ZXMsbnVsbHNfYWxsb3dlZD1u
bykNCiBDT0xVTU4odHlwZT12YXJjaGFyLG5hbWU9Imt0b19iZXNrciIsZGJ0
eXBlPSJ2YXJjaGFyKDI1KSIsbnVsbHNfYWxsb3dlZD15ZXMpDQogQ09MVU1O
KHR5cGU9dmFyY2hhcixuYW1lPSJrdG9fdGZuciIsZGJ0eXBlPSJ2YXJjaGFy
KDE1KSIsbnVsbHNfYWxsb3dlZD15ZXMpDQogQ09MVU1OKHR5cGU9dmFyY2hh
cixuYW1lPSJrdG9fcGVyc19rb2QiLGRidHlwZT0idmFyY2hhcig2KSIsbnVs
bHNfYWxsb3dlZD15ZXMpDQogQ09MVU1OKHR5cGU9cmVhbCxuYW1lPSJpbmdf
YmFsYW5zIixkYnR5cGU9InJlYWwiLG51bGxzX2FsbG93ZWQ9eWVzKQ0KIENP
TFVNTih0eXBlPWRhdGUsbmFtZT0ic3RhcnRfZGF0dW0iLGRidHlwZT0iZGF0
ZSIsbnVsbHNfYWxsb3dlZD15ZXMpDQogQ09MVU1OKHR5cGU9ZGF0ZSxuYW1l
PSJyZWdfZGF0dW0iLGRidHlwZT0iZGF0ZSIsbnVsbHNfYWxsb3dlZD15ZXMp
DQogQ09MVU1OKHR5cGU9dmFyY2hhcixuYW1lPSJ0cmFuc19iZXNrciIsZGJ0
eXBlPSJ2YXJjaGFyKDI1KSIsbnVsbHNfYWxsb3dlZD15ZXMpDQogQ09MVU1O
KHR5cGU9cmVhbCxuYW1lPSJkZXBvc2l0IixkYnR5cGU9InJlYWwiLG51bGxz
X2FsbG93ZWQ9eWVzKQ0KIENPTFVNTih0eXBlPXJlYWwsbmFtZT0icGF5bWVu
dCIsZGJ0eXBlPSJyZWFsIixudWxsc19hbGxvd2VkPXllcykNCiBDT0xVTU4o
dHlwZT1yZWFsLG5hbWU9InV0Z19iYWxhbnMiLGRidHlwZT0icmVhbCIsbnVs
bHNfYWxsb3dlZD15ZXMpDQogQ09MVU1OKHR5cGU9bG9uZyxuYW1lPSJyYWRu
ciIsZGJ0eXBlPSJpbnRlZ2VyIixrZXk9eWVzLG51bGxzX2FsbG93ZWQ9bm8p
DQogQ09MVU1OKHR5cGU9dmFyY2hhcixuYW1lPSJrdG9fdHlwIixkYnR5cGU9
InZhcmNoYXIoNCkiLG51bGxzX2FsbG93ZWQ9eWVzKQ0KIENPTFVNTih0eXBl
PXJlYWwsbmFtZT0ieXRkX2JhbGFucyIsZGJ0eXBlPSJyZWFsIixudWxsc19h
bGxvd2VkPXllcykNCiBDT0xVTU4odHlwZT1kYXRlLG5hbWU9Inl0ZF9kYXR1
bSIsZGJ0eXBlPSJkYXRlIixudWxsc19hbGxvd2VkPXllcykpDQpSRVRSSUVW
RShzdGF0ZW1lbnQ9IlBCU0VMRUNUKFRBQkxFKE5BTUU9fiJrb250b25+Iikg
Q09MVU1OKE5BTUU9fiJrb250b24ua3RvX25yfiIpQ09MVU1OKE5BTUU9fiJr
b250b24ua3RvX2Jlc2tyfiIpQ09MVU1OKE5BTUU9fiJrb250b24ua3RvX3Rm
bnJ+IilDT0xVTU4oTkFNRT1+ImtvbnRvbi5rdG9fcGVyc19rb2R+IilDT0xV
TU4oTkFNRT1+ImtvbnRvbi5pbmdfYmFsYW5zfiIpQ09MVU1OKE5BTUU9fiJr
b250b24uc3RhcnRfZGF0dW1+IilDT0xVTU4oTkFNRT1+ImtvbnRvbi5yZWdf
ZGF0dW1+IilDT0xVTU4oTkFNRT1+ImtvbnRvbi50cmFuc19iZXNrcn4iKUNP
TFVNTihOQU1FPX4ia29udG9uLmRlcG9zaXR+IilDT0xVTU4oTkFNRT1+Imtv
bnRvbi5wYXltZW50fiIpQ09MVU1OKE5BTUU9fiJrb250b24udXRnX2JhbGFu
c34iKUNPTFVNTihOQU1FPX4ia29udG9uLnJhZG5yfiIpQ09MVU1OKE5BTUU9
fiJrb250b24ua3RvX3R5cH4iKUNPTFVNTihOQU1FPX4ia29udG9uLnl0ZF9i
YWxhbnN+IilDT0xVTU4oTkFNRT1+ImtvbnRvbi55dGRfZGF0dW1+IikpIikN
CkRFU1RJTkFUSU9OKG5hbWU9ImtvbnRvbiIsQ09MVU1OKHR5cGU9Y2hhcixu
YW1lPSJrdG9fbnIiLGRidHlwZT0iY2hhcigxNSkiLGtleT15ZXMsbnVsbHNf
YWxsb3dlZD1ubyxpbml0aWFsX3ZhbHVlPSJzcGFjZXMiLGRlZmF1bHRfdmFs
dWU9Ik5VTEwiKQ0KIENPTFVNTih0eXBlPWNoYXIsbmFtZT0ia3RvX2Jlc2ty
IixkYnR5cGU9ImNoYXIoMjUpIixudWxsc19hbGxvd2VkPXllcyxkZWZhdWx0
X3ZhbHVlPSJOVUxMIikNCiBDT0xVTU4odHlwZT1jaGFyLG5hbWU9Imt0b190
Zm5yIixkYnR5cGU9ImNoYXIoMTUpIixudWxsc19hbGxvd2VkPXllcyxkZWZh
dWx0X3ZhbHVlPSJOVUxMIikNCiBDT0xVTU4odHlwZT1jaGFyLG5hbWU9Imt0
b19wZXJzX2tvZCIsZGJ0eXBlPSJjaGFyKDYpIixudWxsc19hbGxvd2VkPXll
cyxkZWZhdWx0X3ZhbHVlPSJOVUxMIikNCiBDT0xVTU4odHlwZT1kb3VibGUs
bmFtZT0iaW5nX2JhbGFucyIsZGJ0eXBlPSJmbG9hdCIsbnVsbHNfYWxsb3dl
ZD15ZXMsZGVmYXVsdF92YWx1ZT0iTlVMTCIpDQogQ09MVU1OKHR5cGU9ZGF0
ZXRpbWUsbmFtZT0ic3RhcnRfZGF0dW0iLGRidHlwZT0ic21hbGxkYXRldGlt
ZSIsbnVsbHNfYWxsb3dlZD15ZXMsZGVmYXVsdF92YWx1ZT0iTlVMTCIpDQog
Q09MVU1OKHR5cGU9ZGF0ZXRpbWUsbmFtZT0icmVnX2RhdHVtIixkYnR5cGU9
InNtYWxsZGF0ZXRpbWUiLG51bGxzX2FsbG93ZWQ9eWVzLGRlZmF1bHRfdmFs
dWU9Ik5VTEwiKQ0KIENPTFVNTih0eXBlPWNoYXIsbmFtZT0idHJhbnNfYmVz
a3IiLGRidHlwZT0iY2hhcigyNSkiLG51bGxzX2FsbG93ZWQ9eWVzLGRlZmF1
bHRfdmFsdWU9Ik5VTEwiKQ0KIENPTFVNTih0eXBlPWRvdWJsZSxuYW1lPSJk
ZXBvc2l0IixkYnR5cGU9ImZsb2F0IixudWxsc19hbGxvd2VkPXllcyxkZWZh
dWx0X3ZhbHVlPSJOVUxMIikNCiBDT0xVTU4odHlwZT1kb3VibGUsbmFtZT0i
cGF5bWVudCIsZGJ0eXBlPSJmbG9hdCIsbnVsbHNfYWxsb3dlZD15ZXMsZGVm
YXVsdF92YWx1ZT0iTlVMTCIpDQogQ09MVU1OKHR5cGU9ZG91YmxlLG5hbWU9
InV0Z19iYWxhbnMiLGRidHlwZT0iZmxvYXQiLG51bGxzX2FsbG93ZWQ9eWVz
LGRlZmF1bHRfdmFsdWU9Ik5VTEwiKQ0KIENPTFVNTih0eXBlPWxvbmcsbmFt
ZT0icmFkbnIiLGRidHlwZT0iaW50IixrZXk9eWVzLG51bGxzX2FsbG93ZWQ9
bm8saW5pdGlhbF92YWx1ZT0iMCIpDQogQ09MVU1OKHR5cGU9Y2hhcixuYW1l
PSJrdG9fdHlwIixkYnR5cGU9ImNoYXIoNCkiLG51bGxzX2FsbG93ZWQ9eWVz
LGRlZmF1bHRfdmFsdWU9Ik5VTEwiKQ0KIENPTFVNTih0eXBlPWRvdWJsZSxu
YW1lPSJ5dGRfYmFsYW5zIixkYnR5cGU9ImZsb2F0IixudWxsc19hbGxvd2Vk
PXllcyxkZWZhdWx0X3ZhbHVlPSIoMCkiKQ0KIENPTFVNTih0eXBlPWRhdGV0
aW1lLG5hbWU9Inl0ZF9kYXR1bSIsZGJ0eXBlPSJzbWFsbGRhdGV0aW1lIixu
dWxsc19hbGxvd2VkPXllcyxkZWZhdWx0X3ZhbHVlPSJOVUxMIikpDQoNCi8v
IFBCLXNjcmlwdDoNCg0KCWl1b19waXBlX2xvZ2lzdGljcy5kYXRhb2JqZWN0
ID0gJ3BpcGVfa29udG9uX3NhX3RvX3NzJw0KDQogICAgICAgIGxpX3BpcGVf
c3RhcnQgPSBpdW9fcGlwZV9sb2dpc3RpY3MuU3RhcnQoaXVvX3NvdXJjZV9j
b25uZWN0aW9uLGl1b19kZXN0X2Nvbm5lY3Rpb24sICYNCiAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgZHdfcGlwZV9lcnJvcnMp
DQovLyBsaV9waXBlX3N0YXJ0IHJldHVybnMgY29kZSAtNCB3aGVuIHNvdXJj
ZSBhbmQgZGVzdGluYXRpb24gcmVzaWRlIG9uIGRpZmZlcmVudCBzZXJ2ZXJz
IG9yIGRiJ3MNCi8vIHJldHVybnMgMCA9IE9LIHdoZW4gc291cmNlIGFuZCBk
ZXN0aW5hdGlvbiByZXNpZGUgb24gc2FtZSBkYi4NCg0KLy8gV2hlbiBleGVj
dXRpbmcgdGhlIHBpcGUtb2JqZWN0IGZyb20gUEItcGFpbnRlciBpdCB3b3Jr
cyBldmVyeSB0aW1lIHdpdGggZGlmZmVyZW50IHNvdXJjZSBhbmQgZGVzdGlu
YXRpb24uDQo=

---=_forums-1-dub4c514892--
0
Bengt
7/29/2010 9:23:30 AM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

3 Replies
962 Views

Similar Articles

[PageSpeed] 23

Hi Bengt;

 A -4 means that the target table does not exist. So make sure in your PL 
that you set the "options" to Create/Add table vs replace that I think you 
have currently.

HTH

Regards ... Chris
President: OSUG / STD Inc.
Blog: http://chrispollach.pbdjmagazine.com
SourceForge: http://sourceforge.net/projects/stdfndclass



"Bengt Astrom" wrote in message news:4c514892.2c0a.1681692777@sybase.com...
> Hello! I try to pipe data between a SqlAnyWhere-db to a
> MS-SqlServer-db but it won't work. It returns code -4 and
> give me no clue what the problem is. The pipe-object is
> encapsulated in a transaction-object. I do have a succesfull
> connection in both source- and destination-connection but it
> won't work anyway.
> Anyway it works when executed from PB-painter (but not from
> the app) I would highly appreciate if anyone has an idea
> about the problem.
> 
0
Chris
7/30/2010 12:41:17 AM
> Hi Bengt;
>
>  A -4 means that the target table does not exist. So make
> sure in your PL  that you set the "options" to Create/Add
> table vs replace that I think you  have currently.
>
> HTH
>
Hi Chris,
My options are Refresh-Delete/Insert which I consider as
correct.
I started this pipe-operation the very first time from
PB>DB>painter with Create - Add Table so the target-table is
there for sure. The first PB-app pipe-operation is all
together the second one. Still try with Create - Add in the
app?
/Bengt
> Regards ... Chris
> President: OSUG / STD Inc.
> Blog: http://chrispollach.pbdjmagazine.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
>
>
>
> "Bengt Astrom" wrote in message
> > news:4c514892.2c0a.1681692777@sybase.com... Hello! I try
> > to pipe data between a SqlAnyWhere-db to a
> > MS-SqlServer-db but it won't work. It returns code -4
> and give me no clue what the problem is. The pipe-object
> > is encapsulated in a transaction-object. I do have a
> > succesfull connection in both source- and
> > destination-connection but it won't work anyway.
> > Anyway it works when executed from PB-painter (but not
> > from the app) I would highly appreciate if anyone has an
> > idea about the problem.
> >
0
Bengt
7/30/2010 11:54:04 AM
Next I will check application Destination Connection is same as PB 
Destination connection (Server, Database, Login/User)

<Bengt A> wrote in message news:4c52bd5c.4fca.1681692777@sybase.com...
>> Hi Bengt;
>>
>>  A -4 means that the target table does not exist. So make
>> sure in your PL  that you set the "options" to Create/Add
>> table vs replace that I think you  have currently.
>>
>> HTH
>>
> Hi Chris,
> My options are Refresh-Delete/Insert which I consider as
> correct.
> I started this pipe-operation the very first time from
> PB>DB>painter with Create - Add Table so the target-table is
> there for sure. The first PB-app pipe-operation is all
> together the second one. Still try with Create - Add in the
> app?
> /Bengt
>> Regards ... Chris
>> President: OSUG / STD Inc.
>> Blog: http://chrispollach.pbdjmagazine.com
>> SourceForge: http://sourceforge.net/projects/stdfndclass
>>
>>
>>
>> "Bengt Astrom" wrote in message
>> > news:4c514892.2c0a.1681692777@sybase.com... Hello! I try
>> > to pipe data between a SqlAnyWhere-db to a
>> > MS-SqlServer-db but it won't work. It returns code -4
>> and give me no clue what the problem is. The pipe-object
>> > is encapsulated in a transaction-object. I do have a
>> > succesfull connection in both source- and
>> > destination-connection but it won't work anyway.
>> > Anyway it works when executed from PB-painter (but not
>> > from the app) I would highly appreciate if anyone has an
>> > idea about the problem.
>> > 


0
Arul
7/30/2010 1:24:50 PM
Reply:

Similar Artilces:

finding database objects used by PB app
Is there any easy way to find all tables and stored procs used by a PowerBuilder app? Other than looking at all of the source code, or doing searches on all the source code, etc. Using PB 6.5 with ASE 12 Thanks Take a look at PBDoc from www.PBDR.COM . It produces an excelent cross reference for your application and you databse and it is FREE to try and a modest fee to purchase. Make sure you configure the databse xref in order to take advantage of the database cross reference materials. - Joe Slawsky (NOSPAMFORME_jslawsky@planetdx.com) www.planetdx.com PBL Pee...

Can a PB App use a COM object not built by PB?
I have seen a few posts regarding using PB to build COM and Active-X, and the Sybase site mentions the wizards, etc. But, there is no mention of a PB app being able to use a COM object built outside of PB. Is there any restriction, and if PB is able to use them is there a version where this capability began? Yep... see the following link for an example: http://home.earthlink.net/~regansizer/powerbuilder/source/pbzip.htm -Charles http://www.puterwerks.com Laurence Fitzsimons wrote: > I have seen a few posts regarding using PB to build COM and Active-X, > and the Sy...

call a second instance ofa powerbuilder app from within first app
Hi , I want to open a second powerbuilder application from within my application (I am in NVO) and get a handle for it so that I can open a window. Then close the first app. Can I simply use a run command.... Thanks, Alon Baadani You won't be able to just execute an Open() against another instance of an app. You might want to look at making your app DDE aware, then sending your second instance a DDE command that will tell it to open the window itself. Good luck, Terry [TeamSybase] and Sequel the techno-kitten On 19 Aug 2005 13:31:33 -0700, in sybase.public.powerbui...

Drag documents to a PB App from a non-PB App?
PB 10.5 This would be like 'dragging' an email from Outlook into PB (onto a datawindow?). Something the users would like. Which is to say, the document itself would be saved to a specific folder, and that information saved to the database. Currently they save the email to the desktop, then in PB, GetFileOpenName() is called to select the document, then the document is saved to a different folder determined by the app, .... and the doc name is listed on a datawindow. The users would like to just 'drag' the document into the app. Any way to do this? KL ...

App runs in PB but App crashes outside of PB
I am using PB 6.5 on Windows NT 4.0 SP3. I have a button/script that works fine when I run my app in PB or if debug my app. But if I run app outside of PB and click on the same button it crashes. I have had the problem 5 different times with 5 different buttons/scripts. I would rebuild the entire app once or twice and the problem would go away. But this last time the problem will not go away. I put dialogue boxed in the script to try to find the line where it crashes, but depending on where I put the dialogue box code or the number of dialogue boxes I use, the script crashe...

Returning an object to PowerBuilder app
I have two simple classes, Widget and WidgetManager, which I deployed to Jaguar Server from PowerJ. The classes are both part of the same package, but in separate components called WidgetComp and WidgetManagerComp. I am trying to use these objects in a PowerBuilder app. Everything works great until I call a function that uses an object rather than a scalar. Code for WidgetManager: final public class WidgetManager implements java.io.Serializable { public Widget getWidget() { Widget aWidget = new Widget(); aWidget.setWidgetName("Dummy"); aWidget.setW...

Ole object for powerbuilder app
I have developed an project management tool in pb. This app creates *.spp documents. I want to be able to embed this document in a word document in the same way you can embed excel in word. Is this possibe to do in pb? I just recorded a Word macro that inserts an MS project file into the current document. The generated VBA code looks like the following: Selection.InlineShapes.AddOLEObject ClassType:="MSProject.Project.9", _ FileName:="C:\Projects\UPS\UPS Rapid Implementation.mpp", LinkToFile:= _ True, DisplayAsIcon:=False I looks like ...

Returning an object in PowerBuilder app
I have two simple classes, Widget and WidgetManager, which I deployed to Jaguar Server from PowerJ. The classes are both part of the same package, but in separate components called WidgetComp and WidgetManagerComp. I am trying to use these objects in a PowerBuilder app. Everything works great until I call a function that uses an object rather than a scalar. Code for WidgetManager: final public class WidgetManager implements java.io.Serializable { public Widget getWidget() { Widget aWidget = new Widget(); aWidget.setWidgetName("Dummy"); aWidget.setW...

Corrupted PB app object
Occasionally our PB app object gets corrupted in when we are testing. We have not been able to detect a pattern - probably because we have a quick work around. What happens is that PB will GPF when we start the app, if we try to open the app object PB parially paints the open event of the app object and then GPFs. Our solution is to copy a good copy of the app object to our working PBL and everything is fine once again. Has anyone else experienced this? Can we avoid this pain? BTW, we have deployed our first app with PB7.0 clients and Jaguar3.0, we go production with it July 1st,...

Database migration of PB apps
Greetings to the powerbuilder community! Well I am relatively new to PowerBuilder and we are trying to establish a PoC on migrating a large Powerbuilder Application with a Sybase database to an Oracle Database. Specifically, I am looking for more info on the migration of the embedded SQL's within the PB codes. Is there an established methodology for the same? Currenlt , I am accomplishing the same by extracting the PBL codes into .srd and .srw files and then running tools to convert the embedded SQL's in them. Could anyone elaborate on the presence/absence of embedded...

PB and the Pur Object database
Hi, Has someone successfully connected PB with a Pure Object databases like ODI VERSANT O2. It is possible to do it when you define your objects in an another language like Java and C++. Using OCX Pb can access these objects. But I want to define the object through an Pb NVO. Thanks Paul ...

Objects at web.pb and database connection
Can I run events of the objects? Inherit is possible!?! I must have to test the database connection before run a function that read or write at database? Appreciate your answers. Jefferson - Logocenter's Programmer You cannot reference events from the URL but a function called from the URL can trigger any event. You can use inheritance in WEBPB. I'm sorry, but I can not understand your last question. Jefferson Luiz Castello Pereira wrote: > Can I run events of the objects? > Inherit is possible!?! > I must have to test the database connection before run a...

Database access from PB COM object
I want to keep all my business logic in PB COM objects, including all database access. I've been able to develop a small obect that reads the database and returns a predefined number of fields by passing the fields by reference to the PB COM object, but what if the calling program justs wants all the rows in a table, how do I code the PB COM function? I originally thought the PB COM object would return the data in arrays passed by reference, but those arrays cannot be unbounded. Can the PB COM object return a datastore (I got a GPF when I tried this)? I want to call the PB COM ...

Disconnect Object Crashes PB App
We've created a non-visual object used to invoke a Visual Basic 6.0 DLL that invokes the Crystal Reports Report Design Component to create a PDF file from a Crystal report. We are using the non-visual within a PowerBuilder 'batch' program, that is a program that is fired off when required and runs entirely without user intervention. When the batch program terminates, it crashed, Dr. Watson is invoked, and both the batch program and Dr. Watson executable stay in memory, but do nothing. I'm pulling my hair out trying to figure out why PB is crashing. I create the ...

Web resources about - Pipe-object within PB-app - sybase.powerbuilder.database

The mysterious object blocking Seattle tunnel was just a pipe
The mysterious, Thing-like object blocking Seattle tunnel-boring project has finally been revealed after weeks of investigation. Sadly, it wasn't ...

Resources last updated: 12/17/2015 10:19:08 PM