Porting Ms Sql Server 6.5 database to Ms Sql Server 7.0Hi,
We have developed a product using PowerBuilder7.0, Ms Sql Server 6.5 and
connecting them using powerbuilder native driver. Now we are thinking of
porting Ms Sql Server 6.5 database to Ms Sql Server 7.0.As we feel, we could
achive new features of Sql server 7.0.e.g row level locking.
Actually i want to know, what things i have to do.e.g what sort of
connection i have to use? what new features i will able to use?.will Stored
procedures work properly.
Is there anyting i have to chang in my application(at front end)e.g
datawindows or any embeded sql, external functions.
Should i po...
Porting Ms Sql Server 6.5 Database to Ms Sql Server 7.0Hi,
We have developed a product using PowerBuilder7.0, Ms Sql Server 6.5 and
connecting them using powerbuilder native driver. Now we are thinking of
porting Ms Sql Server 6.5 database to Ms Sql Server 7.0.As we feel, we could
achive new features of Sql server 7.0.e.g row level locking.
Actually i want to know, what things i have to do.e.g what sort of
connection i have to use? what new features i will able to use?.will Stored
procedures work properly.
Is there anyting i have to chang in my application(at front end)e.g
datawindows or any embeded sql, external functions.
Should i po...
Powerbuilder 6.5 & SQL-server 6.5 <> 7.0Hi everyone,
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...
MS SQL 6.5 and PowerBuilder 6.5I 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 :
datastore lds_datastore
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 ...
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,
in powersoft.public.powerbuilder.database
A-B-C <a-b-c@163.net> wrote:
>
---
Bruce Armstrong [TeamPS] | Romac/Source International
mailto:Bruce.Armstrong@eudoramail.com | mailto:jobs@sourcela.com
| http://www.romac-sou...
problem when connecting MS SQL Server 7.0 with powerbuilder 6.5Dear All,
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:
parent.dw_1.SettransObject(SQLCA)
parent.dw_1.retrieve()
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
connected.
...
PowerBuilder 4.0.3 & MS SQL server 6.5From Enrique Rosales,
Unisys Uruguay.
Please, I need to know if is it compatible PowerBuilder 4.0.03 with
Microsoft SQL Server 6.5?
Thanks for your help.
email: enriquerosales@unn.unisys.com
>Please, I need to know if is it compatible PowerBuilder 4.0.03 with
>Microsoft SQL Server 6.5?
>Thanks for your help.
>
With the native drivers, I don't believe so. PB4.03 was compatible
with MS SQL 6.0 with native drivers. When 6.5 came out, there were
problems that were not fixed until I believe 4.07 (check with PS
support to be sure about the release).
Larry Cerm...
SQL 6.5 + PowerBuilder 6.0Hi,
I would like to know if there will be performance (or other) problems if
I run the SQL server with client written by PowerBuilder on a machine
using NT4 server. Will it be stable enough or I must have the client and
server separate.
Thanks for your help.
Hello, MK...
Based on my experience, this is what we are having in some production
environments in our company. In one example, we are having a user who has a
PowerBuilder 6.0 client application with a SQL Server together on a single
machine, with NT 4 Workstation installed. If the machine is having 64 MB,
there is no p...
PowerBuilder 6.5.1; MS SQL Server 7.0; ODBC; Text ColumnPowerBuilder 6.5.1
ODBC
MS SQL Server 7.0
Text Column
I can't seem to insert a String with a length of 66,000 char to a Text
Column.
I get a to big (999) error
I've change this in the pbodb60.ini
PBMaxTextSize='2147483647'
and I've added DBTextLimit='100000' to my SQLCA.DBParm
Any Ideas?
Best Regards,
Adri�n Galv�n
Adrian,
Do you have this problem if you use the UpdateBlob statement as well, or
just with Insert ?
Sanjiv.
"Adrian Galvan" <Nospam_agalvan@audisys.com> wrote in message
news:40896004$1@forums-1-d...
PowerBuilder 5.0.01 and MS SQL 6.5 Slowest than everI 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.
...
Problems with db-library and ODBC using with MS SQL Server ver 7.0 PowerBuilder ver 6.5. And OLE-DB for Microsoft OLAP ServicesThere 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
Services ?
Carlos Lara
darsa@solnet.com.mx
...
Outer Joins, ANSI syntax and MS SQL Server 6.0, 6.5, 7.0 BetaHi
We would like to make our powerbuilder program avaible on multible DB
platforms, but one big problem is OUTER JOINS !
We started on Oracle, no problems.
// Oracle 7.3.4
SELECT *
FROM TABLE1,
TABLE2,
TABLE3
WHERE ( TABLE1.NUMMER_N06 = TABLE3.NUMMER_N06 (+)) and
( TABLE3.NUMMER_I = TABLE2.NUMMER_I (+)) ;
Then , for the smaller companies, we tried SQL AnyWhere 5.0, no problems.
// Sybase SQL Anywhere 5.5
SELECT *
FROM {oj {oj TABLE1 LEFT OUTER JOIN TABLE3 ON TABLE1.NUMMER_N06 =
TABLE3.NUMMER_N06}
LEFT OUTER JOIN...
PowerBuilder Upgrade 5.0 -> 6.0/6.5 for PowerFrame?Has anyone upgraded PowerFrame (Metasolv's old framework) from PB 5.0
to PB 6.0/6.5? Did you run into any major problems? ANY upgrade
advice (PowerFrame or not) would be appreciated. Should I just wait
for 7.0? What's the latest on its release?
Please respond here or email to eleuschner@levi.com.
Thanks in advance,
Ellen
(The last living person not using PFC. IT'S NOT MY CHOICE!)
Ellen,
Have you tried calling MetaSolv? I know that they dropped support for
PowerFrame in favor of Cornerstone but they may still be willing to help.
Rey Bango
Team Powersoft.....
PowerBuilder 6.5 and Adaptive Server Anywhere 6.0.2I have installed ASA 6 recently and trying to upgrade my SQL Anywhere 5.5.3
database to this new version. My existing run well on this new version of
database, but I am having trouble using PowerBuilder with the new database.
I don't seems to be able to view the tables in the database correctly. All
I get is the table with column, but the primary key, index doesn't show.
The name of the object had become all in lower case, while my original
object name are in mix case.
I have no problems with SQL Anywhere 5.5.3
...