PowerBuilder 6.5 issues with an ODBC connection to a Database

PowerBuilder 6.5 Build 444
Windows XP
********** ALSO SEE ATTACHMENTS ************

I am working on the project that we talked about in April. 
We are hoping the client will be convinced to go to
PowerBuilder 10.5, but at this moment I am stuck in the 6.5
world.

We are using a new database by HP in which it is a Non Stop
System.  It is an ODBC connection (ver. 3) with the drivers
developed by HP.  It is SQL '9x compliant ( ANSI SQL:99 ).

After connecting I get errors when trying to retrieve a
datawindow.  The first time when opening the Pre- View I get
data because of the automatic retrieval, but when I click on
the retrieve button I get an error.  When I open the
Database Painter I get an error.  I basically have no
tables, but they are there.

Could PowerBuilder 10.5 help correct this issue?  Am I doing
something wrong on the PowerBuilder side?  Can the
pbcatalog's reside in it's own schema?

FYI Note:  The pbcatalog's had to change.  The datatypes
varchar2 and number are not supported so they were changed
to varchar and LARGEINT (which translates to a LONG LONG).

I have also looked at my ODBC Database profile to see if I
did not setup something correctly.

Any help would be beneficial.

I can email screenshots of the errors and the ODBC
DBProfile.

trundo2000@yahoo.com

Thanks,

Tom Rundo
0
Thomas
8/17/2006 3:30:40 AM
sybase.powerbuilder.general 62418 articles. 18 followers. Follow

3 Replies
805 Views

Similar Articles

[PageSpeed] 40

Actually, I'm surprised you got as far as you did. PB6.5 is not 100% compatible
with ODBC v3.0 (which was introduced in a service pack for W2K, and came native
in XP). You need 6.5.01 to support that.

And, if you're going through the expense and bother of a full regression test to
upgrade to 6.5.01, you might as well... <beg>

Seriously, 6.5 was end-of-lifed before XP came into existance. Something like
8.0.3 was the first to officially be supported on XP. So, you *know* there are
issues with 6.5 on XP (otherwise Sybase would have supported XP sooner).
Honestly though, whether *your* app will run into those issues with 6.5 and XP
is harder to say. I have run 6.5.01 apps on XP. There are just fewer guarantees.

At the risk of self-promotion (and everyone here knows I *NEVER* do that <beg>),
I'd suggest going through the new features in PB 7 - 10.5, listed in the PB
History section of my web site (see below), and build yourself a shopping list
of things your app could use. Maybe PDF generation is what can sell your users,
or support of tables in the RTE, or a native LastPos() will fix a performance
bottleneck in a critical algorithm. Who knows? Some people warm up better to the
idea of being on a supported version. (Obviously, your management and users
don't fall into this category. <g>) Others are more attracted to more tangible
benefits.

Good luck,

Terry [TeamSybase] and Sequel the techno-kitten

On 16 Aug 2006 20:30:40 -0700,
 in sybase.public.powerbuilder.general
 <Thomas Rundo> wrote: 
>PowerBuilder 6.5 Build 444
>Windows XP
>********** ALSO SEE ATTACHMENTS ************
>
>I am working on the project that we talked about in April. 
>We are hoping the client will be convinced to go to
>PowerBuilder 10.5, but at this moment I am stuck in the 6.5
>world.
>
>We are using a new database by HP in which it is a Non Stop
>System.  It is an ODBC connection (ver. 3) with the drivers
>developed by HP.  It is SQL '9x compliant ( ANSI SQL:99 ).
>
>After connecting I get errors when trying to retrieve a
>datawindow.  The first time when opening the Pre- View I get
>data because of the automatic retrieval, but when I click on
>the retrieve button I get an error.  When I open the
>Database Painter I get an error.  I basically have no
>tables, but they are there.
>
>Could PowerBuilder 10.5 help correct this issue?  Am I doing
>something wrong on the PowerBuilder side?  Can the
>pbcatalog's reside in it's own schema?
>
>FYI Note:  The pbcatalog's had to change.  The datatypes
>varchar2 and number are not supported so they were changed
>to varchar and LARGEINT (which translates to a LONG LONG).
>
>I have also looked at my ODBC Database profile to see if I
>did not setup something correctly.
>
>Any help would be beneficial.
>
>I can email screenshots of the errors and the ODBC
>DBProfile.
*********************************
PowerBuilder for $95? No.
Personal use PowerBuilder Enterprise *AND* PocketBuilder *AND* DataWindow.NET
*AND* Sybase IQ as free benefits of am ISUG membership. See
http://www.isug.com/ISUG3/Membership_benefits.html for details.

*********************************
Click once a day to help the hungry
http://www.thehungersite.com
*********************************
User Manual
===========
TeamSybase <> Sybase employee
Forums = Peer-to-peer
Forums <> Communication with Sybase
IsNull (AnswerTo (Posting)) can return TRUE
Forums.Moderated = TRUE, so behave or be deleted
*********************************

Sequel's Sandbox: http://www.techno-kitten.com
Home of PBL Peeper, a free PowerBuilder Developer's Toolkit. 
Version 3.0.02 now available at the Sandbox
PB Futures updated Apr 24/2006
See the PB Troubleshooting & Migration Guides at the Sandbox
^ ^
o o
=*=
0
Terry
8/17/2006 2:12:31 PM
Thomas,

    Wow!!  A new database on a Non Stop System?  This wouldn't be NonStop
SQL would it?  That's been around since the late 80's (yeah that's right, I
was learning about it in 1990).

    I actually connected to it with PB Version 3.0 using DDE back in 1994,
just playing around.

    Not sure the state of the database since I left Tandem (the original
NonStop company) back in 1994, but it was a screamer.  It would embarrass
DB2 and ANY system that Oracle ran on at that time.

    Good luck, and I'd be interested in how it all works out.

Richard Coleman
Richard_Coleman <at> dre dot ca dot gov

<Thomas Rundo> wrote in message news:44e3e090.4cf2.1681692777@sybase.com...
> PowerBuilder 6.5 Build 444
> Windows XP
> ********** ALSO SEE ATTACHMENTS ************
>
> I am working on the project that we talked about in April.
> We are hoping the client will be convinced to go to
> PowerBuilder 10.5, but at this moment I am stuck in the 6.5
> world.
>
> We are using a new database by HP in which it is a Non Stop
> System.  It is an ODBC connection (ver. 3) with the drivers
> developed by HP.  It is SQL '9x compliant ( ANSI SQL:99 ).
>
> After connecting I get errors when trying to retrieve a
> datawindow.  The first time when opening the Pre- View I get
> data because of the automatic retrieval, but when I click on
> the retrieve button I get an error.  When I open the
> Database Painter I get an error.  I basically have no
> tables, but they are there.
>
> Could PowerBuilder 10.5 help correct this issue?  Am I doing
> something wrong on the PowerBuilder side?  Can the
> pbcatalog's reside in it's own schema?
>
> FYI Note:  The pbcatalog's had to change.  The datatypes
> varchar2 and number are not supported so they were changed
> to varchar and LARGEINT (which translates to a LONG LONG).
>
> I have also looked at my ODBC Database profile to see if I
> did not setup something correctly.
>
> Any help would be beneficial.
>
> I can email screenshots of the errors and the ODBC
> DBProfile.
>
> trundo2000@yahoo.com
>
> Thanks,
>
> Tom Rundo


0
Richard
8/17/2006 10:00:04 PM
Thomas,

I remember having worked with a PB 6.5.?? version on a Nonstop database  
some years ago, and normally it worked, until we had a configuration  
change on the Tandem server, and some CPUs were deprived of sorting  
memory. If you connected to the db and happened to hit one of these, the  
connect failed as it was not able to get back a sorted list of tables. You  
just had to re-try the connect attempt until you got a CPU with sorting  
memory configured correctly.

I am not sure if this applies to your situation. Just a guess.

Frank
0
Frank
8/22/2006 6:53:44 PM
Reply:

Similar Artilces:

ASA 6
Hello! I tried to install connection from PowerBuilder to ASA 6.02 Network Server without ODBC support. I described ASA-server as Open Server. In PB I use "SYT Sybase SQL server DBLIB" driver. Besides, I installed to the database stored procedures and tables which PowerBuilder install in ASE 11.5. I can connect across DB-profile, I can see data in tables, but I can not make DataWindow. Do exists others native drivers for PB and ASA 6. In ASE 11.5 such drivers work really fast than ODBC-drivers. With big respect Voronkov Nick. my email is voronkov@engineer.c...

Performance Issue with PowerBuilder 6.5 Native Drivers and MSSQL 6.5
Hi, I'm having a performance issue with the PB 6.5 Native driver with MSSQL 6.5, if i'm using the ODBC my request to the database are responding really fast, but i want to use to Native drivers. Before i was using the 16 bit Native drivers and it was working fine, but since i've changed to the 32 bit PB 6.5 native driver, most of my db request are really slow. I've search on the sybase infobase and i can't find anything... Could somebody give my advise.... Thanks Mark ...

Hung Up connecting to ASA7 ODBC from PowerBuilder 6.5
I am still having a peculiar problem on one particular machine (that was working) where a PowerBuilder 6.5 application hangs when attempting to connect to an ODBC ASA7 local database. It is hung on the Connect statement and no Error Log is generated. This application was working fine previously on this machine (all that happened is the user moved from one WG to another and Back) all other TCP services seem to work. I can connect to the database from the Test in the ODBC administration. The application can be found in the Tasks list as not responding. Help!!! Glenn ...

Connecting to an SQL Server 2000 Database from Powerbuilder 6.5
I have a WINDOWS 2000 SERVER on which the SQL SERVER 2000 (Standard=20 Edition) is running.. From a WINDOWS NT Workstation Client (on the same Network) I' trying from within Powerbuilder to connect to my SQL SERVER 2000 database via ODBC. I created and configured the ODBC driver for this=20 connection as well as the associated Powerbuilder DB-Profile. When then I try to connect (from the Database Profiles popup window) to my database, the sonnection is successfull but when the popup window of Powerbuilder appears (in the Database Painter Window) for selecting the tables of the d...

ODBC for Connecting Powerbuilder 6.5 on Sun Solaris to Oracle
Does Powerbuilder 6.5 support the following: ODBC to connect to Oracle 8.05 on a Sun Solaris machine? Yes, assuming you mean PB6.5 running on W95/NT. -- Terry Dykstra (TeamSybase) Canadian Forest Oil Ltd. joe wrote in message <37554C8A.2E3D4A6C@idfm.com>... >Does Powerbuilder 6.5 support the following: >ODBC to connect to Oracle 8.05 on a Sun Solaris machine? > ...

connecting to visual fox pro (dbc) database using powerbuilder 6.5
I am using Microsoft Visual Fox pro driver to connect to visual Fox pro database (DBC) The connection is fine. But when I create a datawindow, I do not see the capability to create outer join between two tables in the datawindow painter. But If I connect to visual fox pro (dbf) using fox pro driver. I can create outer join in the datawindow The problem is with Fox Pro DBC. I would appreciate if some one helps on this issue Thanks subramanyam ...

Powerbuilder 6.5.1 connecting to SQL Server 2000 using ODBC Dsn
Can anyone help in connecting by Powerbuilder 6.5.1 application talking to sql 2000 database. Our applications has a ini file which includes the following details [Database] DBMS=MSS Microsoft SQL Server 6.x ServerName=TestServer AutoCommit=true Database=pubs Lock=RL In case of ODBC dsn, what should go in ini other than these. Please suggest [Database] DBMS=ODBC AutoCommit=true Database=pubs Lock=RL In powerbuilder the profile is created using odbc dsn as the datasource The connection is successful in Powerbuilder IDE. But when I launch the application, I get ...

Powerbuilder 6.5.1 connecting to SQL Server 2000 using ODBC Dsn
Can anyone help in connecting by Powerbuilder 6.5.1 application talking to sql 2000 database. Our applications has a ini file which includes the following details [Database] DBMS=MSS Microsoft SQL Server 6.x ServerName=TestServer AutoCommit=true Database=pubs Lock=RL In case of ODBC dsn, what should go in ini other than these. Please suggest [Database] DBMS=ODBC AutoCommit=true Database=pubs Lock=RL In powerbuilder the profile is created using odbc dsn as the datasource The connection is successful in Powerbuilder IDE. But when I launch the application, I ge...

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...

Licensing issue: Powerbuilder 6.0 to 6.5
We have several licensed copies of Powerbuilder 6.0. Do we need to purchase upgrade licenses when we download the upgrade to PB6.5? And if so, why? (since it appears to be a maintenance release) dave AFAIK, no. PB6.5 is a maintenance release (6.0.01 + component generators). -- Met vriendelijke groet, - Eric Aling [TeamPS], Cypres Informatisering bv, The Netherlands Eric's Home & PB Site @ http://utopia.knoware.nl/users/cypr115 David Athey <athey@iname.com> wrote in message $nX3yqnd#GA.148@forums.sybase.com... >We have several licensed copies of Po...

Connecting PowerBuilder 6.5 with an Oracle 7.3 Database in a Novell Netware 3.12 Server
Ladies and Gentlemen: I didn't know if some of you have these problem, but I solve this one in a simple way. We have two servers in our company, one is a Windows NT Server and other is our Novell Netware 3.12 Server. Right know, our clients are accesing the data from the Netware 3.12 to the NT Server, but our clients are using in line the systems developed in PowerBuilder 4.0 Also we are migrating from PB 4.0 to PB 6.5 (How a jump), but we need the connection with the 3.12 server to recompile all our functions and so on.... I just update the Netware Client from Windows wi...

Moving from PowerBuilder 6.5 to PowerBuilder 10
Hi, I have an application developed in PB6.5 and due to changing requirements application has to be switched to PB10. There when I am trying to regenerate the contents of my PBL, it is giving error stating: C0042 : cannot compile without valid database signon. This error is coming for few windows but not for the functions I have made in my pbl. It is working perfectly fine for pb6.5. Can you please help me on this. Thanks in advance. Manich First you must to connect to the database by a profile, continue migrate your app. Karla <Manich Tripathi> escribi...

PowerBuilder 6.5 Issues
We have a PowerBuilder application that intermittently locks up (Windows 95 freezes and will not respond, user can still use apps which don't have db connectivity). It does not always happen in the same place. There are no database locks or blocks. File sizes of the pbls range from 4K to 6.2MB. Application is compiled into pbds. Any thoughts? Thanks Tim Achieve Run the application in trace mode (add /PBDEBUG as a command line parameter). It will create a file indicating what it is processing. When the app freezes, look at that file to see what was going on. On Tue,...

Migrating from PowerBuilder 6.5 to PowerBuilder 8.0
We are doing a feasibility study of migrating a PFC based PowerBuilder Application from v6.5 to v8.0. This application is heavily PFC depended and also includes many custom based core layers. If anybody has done (PFC based) powerbuilder migration prior kindly suggest the best approach on the following. 1) How to successfully migrate from PowerBuilder 6.5/PFC - PowerBuilder 8.0/PFC. 2) How to fix/resolve post migration errors etc... . Any help or suggestion will be appreciated. Thanks and Regards Vamsi ---== Posted via the PFCGuide Web Newsreader ==--- http://www.pfcguide....

Web resources about - PowerBuilder 6.5 issues with an ODBC connection to a Database - sybase.powerbuilder.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: 12/19/2015 6:34:58 AM