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