Calling dbtools API from Powerbuilder or Visual Basic

Hello,

I have read (here on the newsgroup) about the "wrapper" dll
in c / c++ needed to call the dbTools api from powerbuilder.

Has somebody written such a dll? Is there an example on
sybase codexchange. Has sombody got such a template in c /
c++ ready for coding. Can somebody please explain the bare
basics of writing such a dll.

It would be nice to know the status in powerbuilder which
table is currently being backed up or which table is being
unloaded with the percentage progress rather than have to
see a dos box.

Is it possible to call the dbTools api from visual basic ?

All help will be highly appreciated and many thanks in
advance.

I'am using PB 10.5, Asa9.x, VB 6 and also havs VS 2005

Regards
Hasan Kasamali
hasan.kasamali@ekwilliams.co.uk
0
Hasan
6/1/2007 3:06:17 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

3 Replies
562 Views

Similar Articles

[PageSpeed] 14

I am not aware of any wrapper DLLs implemented for use in PB. It is 
possible to use DBTools in PB but you will not be able to use the 
callbacks. It is the callback mechanism that allows for status updates.

VB supports calls to external functions. Based on this link, it looks 
like it supports callbacks.

	http://www.thevbzone.com/secrets.htm
-- 

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer 
Edition =and try out the market-leading database for mobile, embedded 
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions  http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************
0
Chris
6/1/2007 7:58:41 PM
No - we did this with ASA7 and PB7...    Unfortunately, I don't have access 
to that code anymore, but I remember it being very straightforward.

Paul Horan[TeamSybase]

"Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in 
message news:46607a71$1@forums-1-dub...
>I am not aware of any wrapper DLLs implemented for use in PB. It is 
>possible to use DBTools in PB but you will not be able to use the 
>callbacks. It is the callback mechanism that allows for status updates.
>
> VB supports calls to external functions. Based on this link, it looks like 
> it supports callbacks.
>
> http://www.thevbzone.com/secrets.htm
> -- 
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> *****************************************************************************
>
> Sign up today for your copy of the SQL Anywhere Studio 10 Developer 
> Edition =and try out the market-leading database for mobile, embedded and 
> small to medium sized business environments for free!
>
> http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
>
> *****************************************************************************
>
> iAnywhere Solutions  http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
> ***************************************************************************** 


0
Paul
6/2/2007 2:41:40 AM
A sample in C/C++ is provided in the Samples\ASA\DBTools directory of the 
ASA 9 installation.

Regards
Arthur

<Hasan Kasamali> wrote in message news:466035e9.d14.1681692777@sybase.com...
> Hello,
>
> I have read (here on the newsgroup) about the "wrapper" dll
> in c / c++ needed to call the dbTools api from powerbuilder.
>
> Has somebody written such a dll? Is there an example on
> sybase codexchange. Has sombody got such a template in c /
> c++ ready for coding. Can somebody please explain the bare
> basics of writing such a dll.
>
> It would be nice to know the status in powerbuilder which
> table is currently being backed up or which table is being
> unloaded with the percentage progress rather than have to
> see a dos box.
>
> Is it possible to call the dbTools api from visual basic ?
>
> All help will be highly appreciated and many thanks in
> advance.
>
> I'am using PB 10.5, Asa9.x, VB 6 and also havs VS 2005
>
> Regards
> Hasan Kasamali
> hasan.kasamali@ekwilliams.co.uk 


0
forums
6/2/2007 7:05:45 AM
Reply:

Similar Artilces:

Calling DBTool functions from Visual Basic
I'm trying to call DBtool functions from within Visual Basic. If there's anyone out there who has tried this kind of stuff from VB I would like to hear from you richter_bernhard@hotmail.com ...

Calling Groupwise From Visual Basic/Visual FoxPro
Hi; I am a software developer and one of our clients is using Groupwise for sending e-mail. They would like to automaticall send PO's, Invoices, etc. from within our custom application. Is it possible to use OLE Object in order to do a function call to Groupwise to send email such as with Outlook? If so, could you please let me know the Object and available paramaters. For example, In Visual FoxPro and Outlook, you would do the following: oOutLookObject = Createobject("Outlook.Application") oEmailItem = oOutLookObject.CreateItem(0) oemailitem.To = "Whoeve...

Better to use API fn call/Powerbuilder fn call ...
I have a rather elementary question. Is there any difference in application performance if I use an API call rather than a PowerBuilder function call ? eg Suppose there is PowerBuilder function 'X' which will bring a window to the foreground. An API function 'Y' does the same. Assuming that I need not prepare/initialize any structure etc to be passed to the API function 'Y', does it make any difference to the app performance if I make an API call instead of the PowerBuilder function call 'X' ? Thx Ganesh The difference would be virtually i...

API Calls from PowerBuilder.
Hi all, I have a problem with API calls. I'd like to now how to call api functions in a DLL that have some functions with parameters like this: DLL: function x ( stru_a ) Structure stru_a { char * name, integer * value_1, Double * value_2, .... } I hope somebody can help me. Thank's. Luiz Paes. Search the Help file for Declaring External Functions and then Calling External Functions. This will explain how (and where) to declare and call your API functions. Zane Knight. ...

Converting Visual Basic 6 to Visual Basic .NET
Hi, I found this program that would get the mac address of a computer given its IP. I converted it into vb.net and it gave 2 errors. It said that I couldn't use "any" in declarations, so I found out what variable it was tryign to pass and changed the any to that data type. Now, the program will start in vb.net... but when I click the button, it returns the wrong mac address, while the one in vb6 returned the correct one.All you have to do is add 2 textboxes to the form and 1 button, dont change their names.::::::::::VB6 CODE::::::::::Option ExplicitPrivate Const NO_ERROR = 0Private Declare F...

PowerBuilder API-Call Problem
I have a PowerBuilder application running under PB 6.5 and Win NT. I am running a WinAPI function, GetWindowsDirectory. It is initialized by the following declaration: Function long GetWindowsDirectory(String lpBuffer, Long nSize) LIBRARY "kernel32.DLL" Alias For "GetWindowsDirectoryA" In a window function I make a call to GetWindowsDirectory like this: string sWinDir long lReturn long iSysPath lSysPath = 256 sWinDir = space(lSysPath) lReturn = GetWindowsDirectory(sWinDir, lSysPath) lReturn returns 8, but sWinDir is empty. The code works in Visual...

Visual Basic and PowerBuilder 9
We have an application that was working with PB7. This particular line of code works in PB7 but not in PB9 ( the pbappl.reg has been run and all pb9 dlls are in the path). Dim ole_pb as object fuction createobject() as boolean ..... Set ole_pb = CreateObject("PowerBuilder.Application") <-- error in here .... end function Check your registry to make sure there is still a VersionIndependentProgId with that value. You also might try "PowerBuilder.Application.9" Ariel Gaspar wrote: > > We have an application that was working with ...

Perl calling Visual Basic
Hi, I am thoroughly lost and do not know how to do this, or even if it is possible to do. We want to have an activestate perl program running on one of our NT gateways call a Visual Basic application. The return code from the VB app will then control the path the Perl program takes. I have searched the internet for anything about Perl calling VB and can find nothing. Any help would be appreciated! Thank you - Joanne Kowalinski Joanne Kowalinski wrote: > Hi, > > I am thoroughly lost and do not know how to do this, or even if it is > possible to do. ...

Powerbuilder
Does anybody have a cross reference list of the PowerBuilder powerscript to obsolete windows API calls?? Has anybody created new functions to handle the new windows API calls?? Thanks, Denise ---== Posted via the PFCGuide Web Newsreader ==--- http://www.pfcguide.com/_newsgroups/group_list.asp ...

How to call MSMQ API from Powerbuilder
Hi all, can someone point me to a site/newsgroup, etc. that explains/shows how to get Powerbuilder to communicate with MSMQ? I am working in a legacy App that now requires to send messages to a MSMQ queue. Any help very appreciated! Don't know about MSMQ, but here's one for MQSeries: http://www.rgagnon.com/howto.html Click on PowerBuilder --> What's New --> Use MQSeriers HTH Greg <Gabriel Gutierrez> wrote in message news:3fa7c6b2.653e.846930886@sybase.com... > Hi all, > > can someone point me to a site/newsgroup, etc. that > e...

Powerbuilder vs Visual Basic
As title... www.deja.com ad nauseam -- Simon Caldwell Get Real Systems Ltd Holtby Manor, Stamford Bridge Road, York, YO19 5LL Tel 01904 481999 Fax 01904 481666 Visit us at www.getrealsystems.com Specialists in e-Procurement and supply chain technology <Ray> wrote in message news:3DCED9B3A846924E00398D6985256A0E.00398D9985256A0E@webforums... > As title... That's now http://groups.google.com Simon Caldwell wrote in message ... >www.deja.com ad nauseam > >-- >Simon Caldwell >Get Real Systems Ltd >Holtby Manor, Stamford Bridge Road,...

PowerBuilder vs. Visual Basic
My client is considering converting all of our PowerBuilder 5.x and 6.x applications to Visual Basic. Does anyone have any white papers that compare and contrast both products? Thanks in advance. Tim Kelly Timothy_Kelly@mail.amsinc.com www.microsoft.com has document comparing VB to PB written by a MS guy.... www.sybase.com has document comparing VB to PB written from Sybase point of view... Funny thing - both are using the SAME arguments as per why should you buy their product :) Tell your client to wait a bit - if Micrsoft get his butt kicked with the anti-trust trial they ar...

Visual Basic COM with PowerBuilder
I'm looking for documentation covering how to use a Visual Basic COM object with PowerBuilder. Thanks <Jerry> wrote in message news:4399a246.3cce.1681692777@sybase.com... > I'm looking for documentation covering how to use a Visual > Basic COM object with PowerBuilder. > > Thanks You would use OLEObject and the ConnecttoNewObject() function. Or, if your components are running in COM+ component services, ConnecttoNewRemoteObject() -- Paul Horan[TeamSybase] ...

Integrating Visual Basic and Powerbuilder
How would I be able to open a Powerbuilder window via a Visual Basic application? How would I be able to open a Visual Basic form via a Powerbuilder application? Thanks, Charles Sustek There are several ways: 1) Use DDE. PB can be a DDE client and server. 2) Use OLE Automation. 3) Use the FindWindowA API Call, then do a Send() to send a message to a hidden window. 4) Run('myvbpgm.exe') Hope that helps. ...

Web resources about - Calling dbtools API from Powerbuilder or Visual Basic - sybase.sqlanywhere.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 11/28/2015 10:19:03 PM