PowerBuilder Problem

Mar 2, 2007

Hello,

I am trying to modify my MS SQL 2005 database by PowerDesigner model using PowerDesigner built-in Modify feature.

PD however seems to have problems reverse engineering the database.

I get tons of errors like this:
Reverse engineering tables...
Table _MyTable
Unable to list the columns.
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
SQLSTATE = 37000

It also seems that it generates incompatible SQL code when modifying the database. E.g. (Parentheses after nonclustered violates syntax)...


create table _H_IpNetworkToVlanNetwork (
ipNetAddress bigint null,
vpnNetId int null default 0,
vlanId int null,
_ChangeDate datetime null,
_ChangeType int null,
constraint PK__H_IPNETWORKTOVLANNETWORK primary key nonclustered ()
)
go

What may be wrong? Do I have badly configured PowerBuilder? Or maybe badly configured ODBC data source?

Thanks for any help.

I have PowerBuilder 12.1 and MS SQL 2005

View 6 Replies


ADVERTISEMENT

SQL 7 With PowerBuilder 5,6

May 20, 1999

Has anyone connected from PowerBuilser 5 16 bit ODBC to SQL Server 7??
(PowerBuilder 6.x work)
In PB 5 I get message "name_column"'S DATA TYPE IS NOT SUPPORTED


THANK'S
BEST WISHES ,LEONID
20/05/99

View 1 Replies View Related

Powerbuilder 6.5 With DB2 8.1 On AIX

Oct 7, 2005

hi,
we are maintaining a powerbuilder 6.5 application which uses IBM DB2 8.1 as backend. The database is currently on Solaris server. We are moving this to AIX box. Could someone guide me regarding the settings to be given in pbodb60.ini file for AIX to support remote procedure calls?

The current entry for the SUN OS is as follows:

; IBM DB2/SUN 2.1 DB2CLI
[DB2/SUN]
PBCatalogOwner='PBCATOWN'
PBSyntax='DB2CS_SYNTAX'
PBDateTime='ISO_DATETIME'
PBFunctions='DB2CS_FUNCTIONS'
DelimitIdentifier='YES'
PBSystemOwner='SYSIBM,SYSSTAT,SYSCAT'
IdentifierCase=3
PBSupportBindSelect='NO'
PBSupportBindUpdate='NO'
PBSupportDBBind='YES'
PBTrimCharColumns='YES'
BlobSegmentSize=32767
ForeignKeyDeleteRule='Disallow if Dependent Rows Exist (RESTRICT),Delete any Dependent Rows (CASCADE),Set Dependent Columns to NULL (SET NULL)'
TableListType='ALIAS'

View 1 Replies View Related

Updating Image In SQL Server 6.5 Using Powerbuilder 4

Jul 5, 1998

How do I update and retrieve data which is of type image into/from SQL Server database in Powerbuilder 4.0.06 scripts? I`ve tried using SELECTBLOB and UPDATEBLOB, but it doesn`t work. I wanted to use WRITETEXT, UPDATETEXT and READTEXT in stored procedure, but SQL Server doesn`t allow datatype image to be passed in as a parameter. I also tried using the WRITETEXT directly in Powerbuilder scripts as follows:
WRITETEXT tablename.colname :ptr :graphics;

where ptr and graphics are local variables in PB scripts. ptr is supposed to be of type varbinary in SQL Server syntax. However, there is no equivalent datatype in PB. graphics is of type BLOB in PB scripts which is equivalent to image in SQL Server syntax.

Please advise. Thank you.

View 1 Replies View Related

Error 10005 On SQL 2005 Server Running Powerbuilder Application

Feb 22, 2008

We are having problems with users getting the 10005 error when running the application.

This is a new sql2005 server. The DB's are in sql2000 format as the vender is not ready to upgrade application totally to 2005.
The users will have 3 instances of the application open and just one fails.

Any ideas on where to start would be great.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved