problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
I have some problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
The error message is:
Database transaction information not availiable.
Call SetTrans or SetTransObject function.
I have a window with 1 button and 1 datawindow
The datawindow inside contain a SQL statement
in the click event of the botton, the script is:
Can anyone tell me what is the problem? And how to solve it???
Thank You Very Much!!!
It seems that the database connection is not available or not successfully
...Powerbuilder 5.0/7.0 and MS SQL 7.0 Performance issues
We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app in
PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0.
Now we are migrating the database from MS SQL 6.5 to 7.0 SP2. We
successfully converted the databases in a testing environment, but now the
app runs terribly slow! I don't think it's a hardware issue -- the test box
is a Compaq 8500 quad Xeon 500 w/1GB Ram. We experimented running the app
as a PB 5.0 app against MS SQL 7.0 and the problem is the same. When we
execute SQL directly against the DB outside of PB, we see no perf...Connect MS-SQL 7.0 in PowerBuilder 7.0
In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but
in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ?
Please post to the powersoft.public.powerbuilder newsgroups
This is dedicated to PB issues when used within Jaguar
> In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but
> in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ?
...How to connect to Ms Sqlserver 7.0 with powerbuilder 6.5
I want to connect to Ms Sqlserver 7.0 with powerbuilder 6.5.
Would you please tell me where I can download the native database driver?
Thank you very much!
I have not been able to find a native driver anywhere. We are having no
real problems using the SQL 6.5 drivers with PB 6.5.1. You have to upgrade
to PB 6.5.1 or there are some issues. (Like you can't paint a DW off of a
stored proc) Hope this helps....Paul
Fang Jing <email@example.com> wrote in message
...Connectivity of PowerBuilder 6.5 and SQL Server 7.0
I need help regarding connectivity with PB 6.5 and SQL Ser. 7.0. I am
getting an error message "DBMS MS Sql Server ... not supported in current
installation' or 'Unable to load the requested database interface".
I have required files for both the system and for PB i.e., NTWDBLIB.DLL
PBMSS60.DLL but still i am not able to connect to the database.
Check the sybase site, there is useful infor about the matter.
"mahesh" <firstname.lastname@example.org> wrote in message
new...Powerbuilder 6.5 & SQL-server 6.5 <> 7.0
I'm using PB 6.5 with SQS 6.5
Everything is normal until I port the program build in this environment to
a similar environment with the only difference that the database is SQS 7.0
This database is slightly different - in some tables, the fields are larger
than in the SQS 6.5 database (but the same type - char).
When the program retrieves rows in that environment I get the error message
'Data conversion resulted in overflow ...'
I have several other environments with sqs 6.5 with the same difference
(larger fields) where the program doesn't rep...Connection problem with PowerBuilder 5.0.02 to MS SQL 7
I am having a problem connecting PowerBuilder 5.0.02 to MS SQL 7. The
application connects fine. The problem is when I try to create a new
datawindow with a stored procedure on SQL 7. I can view all the names of
the stored procedures but I can't see any of the code. I am using the odbc
driver 3.07.08.20 . When I try to look at the stored procedures I get the
message 'The database does not currently support retrieval of procedure
text.' Everything worked fine in SQL 6.5.
any help appreciated,
---== Posted via the PFCGuide Web Newsreader ==---
ht...PowerBuilder 6.5.1; MS SQL Server 7.0; ODBC; Text Column
MS SQL Server 7.0
I can't seem to insert a String with a length of 66,000 char to a Text
I get a to big (999) error
I've change this in the pbodb60.ini
and I've added DBTextLimit='100000' to my SQLCA.DBParm
Do you have this problem if you use the UpdateBlob statement as well, or
just with Insert ?
"Adrian Galvan" <Nospam_agalvan@audisys.com> wrote in message
news:40896004$1@forums-1-d...MS SQL 6.5 and PowerBuilder 6.5
I have an application in PB6.5 that interfaces with MSSQL 6.5 database.
I can run this app WITHIN PB to make a connection the database and
retrieve data without a problem, but after I built the EXE file and
trying to run from that EXE file, I get a "-1" as the return code from
the SetTransObject statement. Sample code is like :
lds_datastore = CREATE datastore
lds_datastore.DataObject = "d_test"
li_return = lds_datastore.SetTransObject(SQLCA)
The d_test datawindow object consists of a simple SQL SELECT statement.
Has anyone seen this ...Problems with db-library and ODBC using with MS SQL Server ver 7.0 PowerBuilder ver 6.5. And OLE-DB for Microsoft OLAP Services
There are many problems when running the aplication using the new ODBC
driver for SQL ver 7. Simple, does not work.
It�s any patch to this problem ?
Using DB Library makes poor query plans in some case using SQL Server 7.0.
It�s any path ?
It�s any patch or utility to use OLE-DB for connecting Microsoft OLAP
...PowerBuilder 5.0.01 and MS SQL 6.5 Slowest than ever
I have a program developed in PB 5.0.01 connected to a MS SQL 6.5 databse, i
have problems using cursors, i lost some information when i used, using in
the DBParm the parameters CursorScroll an CursorLock solve the problem but
the time of response is very slow.
Have some one of you had the same problem or already worked with those
parameters, Thanks in advance. This only onccurs with MS SQL Server , with
Sybase, Oracle doesn't.
...Calling a MS-SQL-Server 6.5 StoredProcedure from PowerBuilder 6.0
Does anyone know if there is a difference from PB 5.0 to PB 6.0 in the
native MSS SQL-Server driver by calling StoredProcedures with OUTPUT
I do have the following problem:
- I've got a StoredProcedures with a char, varchar(50) or even with a
datetime OUTPUT argument.
- In PowerBuilder I do:
DECLARE sp_test PROCEDURE FOR schsp_test_char
@psReturn = :sReturn OUTPUT
FETCH sp_test into :sReturn;
- If I execute this statement I get the following error:
Implicit conversion from datatype 'varch...ASA and PowerBuilder 6.0, 6.5, or 7.0
I am currently running PB 5.0 with an Oracle 7.3 database. However,
there is a great
demand for our remote users to gain access to the app. Therefore, I was
using ASA to deploy to our remote users. The problem is that stored
procedures are not
supported with the run-time version of the database engine that gets
deployed with the
deployment kit. My question is: Does PB 6.0, 6.5, or 7.0 and/or
deployment kit allow
the run-time engine to support stored procedures. If not, what are some
Any guidance will be greatly appreciated. Thanks.
>My ...How do i upgrade PowerBuilder 5.0's native driver for MS SQL Server 6.5?
If you have the 5.0.04 patches, you have the latest stuff that I know of.
Tech Support might have something as a private EBF, but you would have to
contact them directly to determine that. Are you having a particular
problem with the drivers you have now?
On Tue, 9 Feb 1999 11:38:18 +0800,
A-B-C <email@example.com> wrote:
Bruce Armstrong [TeamPS] | Romac/Source International
mailto:Bruce.Armstrong@eudoramail.com | mailto:firstname.lastname@example.org