SQLAnywhere, PowerBuilder, and version conflicts

 Please excuse the dual post -- as you'll see, this pertains to both groups
equally.

My explaination is probably less than coherent, as I'm getting frantic and a
little wired.

We're developing an application in PowerBuilder 5.0.02 and are currently in
the final testing stages. We're testing on Windows '95 and NT4.0. We
recently noticed that we have multiple versions of SQLAnywhere on the
network.

When running the compiled program, our windows 95 workstation testers get
errors if they use SQLAnywhere version 5.0.03. However, the developers on
the same platform can only use the 5.0.02 version. My neighbor on NT 4.0 can
only use 5.0.02, and I , on the same platform, can only use 5.0.03.

When I say "can only use", I mean that the database performs strangely.
Simple queries, such as "Select domain_name from domain where descr = 'ITK',
do not return a value in the executable program. However, if I execute the
same query in ISQL on the same database, I get the expected result set.

This is further complicated by the fact that when we run the program in
PowerBuilder everything works fine.

If anyone has any advice, except for "gasoline and a match", I'd be very
grateful.


Regards,

Dan Terrill
(soon to be ex-) Network Administrator
Connecticut Community Care, Inc.



0
Daniel
9/26/1997 4:00:16 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

4 Replies
931 Views

Similar Articles

[PageSpeed] 14
Get it on Google Play
Get it on Apple App Store

Daniel Terrill wrote:
> 
>  Please excuse the dual post -- as you'll see, this pertains to both groups
> equally.
> 
> My explaination is probably less than coherent, as I'm getting frantic and a
> little wired.
> 
> We're developing an application in PowerBuilder 5.0.02 and are currently in
> the final testing stages. We're testing on Windows '95 and NT4.0. We
> recently noticed that we have multiple versions of SQLAnywhere on the
> network.
> 
> When running the compiled program, our windows 95 workstation testers get
> errors if they use SQLAnywhere version 5.0.03. However, the developers on
> the same platform can only use the 5.0.02 version. My neighbor on NT 4.0 can
> only use 5.0.02, and I , on the same platform, can only use 5.0.03.
> 
> When I say "can only use", I mean that the database performs strangely.
> Simple queries, such as "Select domain_name from domain where descr = 'ITK',
> do not return a value in the executable program. However, if I execute the
> same query in ISQL on the same database, I get the expected result set.
> 
> This is further complicated by the fact that when we run the program in
> PowerBuilder everything works fine.
> 
> If anyone has any advice, except for "gasoline and a match", I'd be very
> grateful.
> 
> Regards,
> 
> Dan Terrill
> (soon to be ex-) Network Administrator
> Connecticut Community Care, Inc.


This is a dumb theory, but as long as you're desperate ... the problem
may actually be that you are not connecting to the DB you think you are,
so you are actually seeing data from another installation.  This can
happen in a networked environment if you don't provide the ENG
(EngineName) and DBN (DatabaseName) connection parameters, and if you
are using TCPIP, the additional {HOST=machinename} parameter.

If you don't provide ENG, SQLA will just ask "Any servers out there?"
and take the first one it finds.  Same concept for DBN.  By supplying
all three params, you will be very sure of where you are connecting. 
ISQL does not use ODBC to connect; and your app and PB design-time
environments could both use different ODBC DSN's; so this is a
reasonable explanation of your problem, although unlikely.

We had this problem once upon a time -- everyone used the same server
and DB names, and the client connection did not specify machine name,
and as a result people would connect more or less at random to any
server on their network segment -- wow.

You can use the server console window, or DBWATCH, to carefully monitor
who connects where.

Good luck
-- Chris


�������������������������������������
Chris Johnson � mailto:cjohnson@pulte.com 
Data Architect, Pulte Home Corporation
0
Chris
9/26/1997 8:25:45 PM
I agree with the other responder - my first guess is that you aren't
connecting to the db that you think you are connecting to.  

If not that, for further diagnosis I would set sqlca.dbms= "trace
odbc" to generate an odbc trace file and see what is really happening
at the sql level.  

HTH

Leo Tohill - Team Powersoft
0
72330
9/27/1997 7:30:59 PM
 Thanks for the response, Chris.
Unfortunately, each client has his own local copy of the database, and we're
still getting problems. Hmmm

Chris Johnson wrote in article <342C1A49.F57@pulte.com>...

>Daniel Terrill wrote:
>>
>>  Please excuse the dual post -- as you'll see, this pertains to both
groups
>> equally.
>>
>> My explaination is probably less than coherent, as I'm getting frantic
and a
>> little wired.
>>
>> We're developing an application in PowerBuilder 5.0.02 and are currently
in
>> the final testing stages. We're testing on Windows '95 and NT4.0. We
>> recently noticed that we have multiple versions of SQLAnywhere on the
>> network.
>>
>> When running the compiled program, our windows 95 workstation testers get
>> errors if they use SQLAnywhere version 5.0.03. However, the developers on
>> the same platform can only use the 5.0.02 version. My neighbor on NT 4.0
can
>> only use 5.0.02, and I , on the same platform, can only use 5.0.03.
>>
>> When I say "can only use", I mean that the database performs strangely.
>> Simple queries, such as "Select domain_name from domain where descr =
'ITK',
>> do not return a value in the executable program. However, if I execute
the
>> same query in ISQL on the same database, I get the expected result set.
>>
>> This is further complicated by the fact that when we run the program in
>> PowerBuilder everything works fine.
>>
>> If anyone has any advice, except for "gasoline and a match", I'd be very
>> grateful.
>>
>> Regards,
>>
>> Dan Terrill
>> (soon to be ex-) Network Administrator
>> Connecticut Community Care, Inc.
>
>
>This is a dumb theory, but as long as you're desperate ... the problem
>may actually be that you are not connecting to the DB you think you are,
>so you are actually seeing data from another installation.  This can
>happen in a networked environment if you don't provide the ENG
>(EngineName) and DBN (DatabaseName) connection parameters, and if you
>are using TCPIP, the additional {HOST=machinename} parameter.
>
>If you don't provide ENG, SQLA will just ask "Any servers out there?"
>and take the first one it finds.  Same concept for DBN.  By supplying
>all three params, you will be very sure of where you are connecting.
>ISQL does not use ODBC to connect; and your app and PB design-time
>environments could both use different ODBC DSN's; so this is a
>reasonable explanation of your problem, although unlikely.
>
>We had this problem once upon a time -- everyone used the same server
>and DB names, and the client connection did not specify machine name,
>and as a result people would connect more or less at random to any
>server on their network segment -- wow.
>
>You can use the server console window, or DBWATCH, to carefully monitor
>who connects where.
>
>Good luck
>-- Chris
>
>
>�������������������������������������
>Chris Johnson � mailto:cjohnson@pulte.com
>Data Architect, Pulte Home Corporation


0
Daniel
9/29/1997 12:06:38 PM
 Thanks, I'll give that a shot.

Leo Tohill <72330.1134@compuserve.com> wrote in article
<342d4fbd.18270434@forums.powersoft.com>...

>I agree with the other responder - my first guess is that you aren't
>connecting to the db that you think you are connecting to.
>
>If not that, for further diagnosis I would set sqlca.dbms= "trace
>odbc" to generate an odbc trace file and see what is really happening
>at the sql level.
>
>HTH
>
>Leo Tohill - Team Powersoft


0
Daniel
9/29/1997 12:08:33 PM
Reply:

Similar Artilces:

Version of PowerBuilder (ref: Creating database for PowerBuilder)
I'm using PowerBuilder v8.0 and would like to create a notification system for my practiculum project. I'd like to use Access to create the database. Please enlighten me on what should I create (e.g. tables, queries) for the usage of it. Thank You. Regards, Yang Ashra Don't double post, it's bad etiquette. Unless you have a very good reason to do so, we recommend you don't use Access. Use SQL Anywhere instead - it's more stable - and a far better database in my opinion. PowerBuilder (enterprise) supports just about every database out there, so if you...

Conflict
I have PowerBuilder 8 enterprise in my system for my existing packages. I would like to test my packages in PowerBuilder 11 Beta version. Is there any problem if I download and install the Beta version of PowerBuilder 11, to the system which contain the PowerBuilder 8? Thanks... The beta is over, but the evaluation version is available at http://response.sybase.com/forms/WW_PB11_Eval There shouldn't be any problem with multiple versions of PB on the same machine - different folder and dll names. Many of us have run 3 or 4 different versions concurrently! <Jemson Kuriak...

Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information from a debug run. Will apprecaite any hints. Thanks Jim jimo@jdssc.com in ls_mod_string DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~", ~"inv_dtl~".~"orig_cost~", ~"inv_dtl~".~"last_cost~", ~"inv_dtl~".~"regular_cost~", ~"inv_dtl~".~"orig_price~", ~"inv_dtl~".~"current_price~", ~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~", ~...

Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information for a debug run. Will apprecaite any hints. Thanks Jim jimo@jdssc.com in ls_mod_string DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~", ~"inv_dtl~".~"orig_cost~", ~"inv_dtl~".~"last_cost~", ~"inv_dtl~".~"regular_cost~", ~"inv_dtl~".~"orig_price~", ~"inv_dtl~".~"current_price~", ~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~",...

Converting current code (Powerbuilder 6.5.1) to newest version of Powerbuilder?
Hi, can anyone tell me what you have to do in order to convert existing code (applications) (created under Powerbuilder 6.5.1) to the newest version of Powerbuilder (at least PB 8) and what it would take to use that code (applications) on the web, I do understand that the newer versions of PB have a web datawindow, is that all we would need to use to move our applications to the web? Thanks Look in this newsgroup aroung 01/08/02 for "Applications on the Web" (started by "John") for a good stream of information. JKerstens <John.Kerstens@gnb.ca> wrot...

Powerbuilder 5 to Powerbuilder 10
Hi all We have migrated our application from powerbuilder 5 to powerbuilder 10. after migration to version 10, alignment in most of reports disturbed. please advice me some solution. On Fri, 29 Feb 2008 12:45:01 +0100, Adnan Jamil <adnanjamil@nji.com.pk> wrote: > Hi all > > We have migrated our application from powerbuilder 5 to powerbuilder 10. > after migration to version 10, alignment in most of reports disturbed. > please advice me some solution. Adnan, Is this a SQL Anywhere question? If not, you have posted to the wrong forum. If yes,...

sqlanywhere and powerbuilder
hello!! when i try to connect to database sqlanywhere using ODBC, i get an error message: "Catalog tables could not be create and are not available for use" i put all rights to user dba. what i do? i wanna see all tables all data thanks... -- Cornelio Royer Gerente General WIN SOFT CORP., S.A. telefono: 317-0134 celular: 674-1218 When you connect for the first time, you need to connect with user id of SYS or SYSTEM, well I don't remember exactly which one. Anyway, it's a db default id that allows the PB catalog tables to be created and th...

PowerBuilder version
If I want to create COM objects using PowerBuilder, do I need the Enterprise edition? To build the com obejct directly from PowerBuilder I believe the only option is the Enterprise edition. See the lonk below and look at page 7. Component creation options are only available from the Enterprise Edition. http://www.sybase.com/content/1011619/pb_brochure.pdf - Joe Slawsky (NOSPAMFORME_jslawsky@planetdx.com) www.planetdx.com 2 things: One, you can always create COM components in VB or VC++ if you have access to either of those, and use them within PB. *Personally*, I think...

Use PowerBuilder DLL in PowerBuilder
We use PB6.5. We would want to use a DLL create from PB in a PB application. We compiled an a PBL as DLL. After we tried to use DLL in a user object external, but without success. How can we do to use DLL create from PB or use in a new PB application some object (visual and no) before compiled with PB? Any help will be appreciated. Saul.Convalle@mail.cec.it Thanks When you create a DLL from a PB library it is not really a standard Windows DLL. I'm not sure what the difference is. If you are making calls from PB then just use the standard PB calling syntax the ...

PowerBuilder version????
--------------947954884B40714F6729FCED Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I'm looking to by the powerbuilder enterprise software, platform windows, and someone offer it to me, but the only reference they provide is: Powersoft enterprise series Powerbuilder Code HA0003 Is this the right staff and the even it is, which version is that? Would you send yours answer to: ricoed@hotmail.com !please !! Thank you, in advance --------------947954884B40714F6729FCED Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bi...

Problem connecting to oracle database in powerbuilder 9.0 desktop version
I am not able to connect to oracle database using odbc in powerbuilder 9.0 desktop version.I am getting error message which says 'Inavlid or unsupported datasource' Ershad, Have you verified that you have the required Oracle ODBC drivers? The latest set of drivers is available at: http://www.oracle.com/technology/software/tech/windows/odbc/index.html\ Could you also please post the attributes of the transaction object (except the password) that you use to try and connect to the oracle db? Sanjiv. <Ershad Ali Mohammad> wrote in message news:41aea458.51d5...

PowerBuilder can't find the Version Manager project database on a renamed server.
We're having trouble updating PowerBuilder 11.5 source control on Windows XP clients for a change to our Serena Version Manager 8.1.4.2 File Service on a Windows 2003 server. The server machine was renamed over the weekend, so we updated its name in the Version Manager configuration files islv.ini and servers.ini. This restored our connection through the Version Manager Desktop Clients, but not through all of the PowerBuilder source- control (SCC) interfaces. Of the three PowerBuilder clients, one connected immediately to Version Manager with only the configuration-file update...

Oracle 10g Database connectivity in PowerBuilder 11.5 Desktop Version using ODBC
This is a multi-part message in MIME format. ---=_forums-1-dub4940f6b1 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit Hi, I have installed PB 11.5 Desktop version with all the EBF`s. I created a DSN for the Oracle 10g default ('Orcl') database through ODBC Administrator. I was successfully able to connect to the database through the DSN. Now I created a Database Profile in PowerBuilder 11.5 Desktop version for the DSN created above. When I tried testing the database connection I got the errors present in attached in document...

Web resources about - SQLAnywhere, PowerBuilder, and version conflicts - sybase.powerbuilder.database

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: 12/20/2015 5:09:29 AM