SQl server 7.0 and Powerbuilder 9.0Hello there.
I have this situation we,re working with Powerbuilder 9.0 and SQL Server 7.0
with an original application developed in Powerbuilder 6.5, this mean that
we made the update to 9.0, well after that in some SQL that involve string
field like char or varchar the values were evaluated with double quoted like
this example type in "1","2".
Select * from clients
Where tipo in " 1","2"
Well this syntax generated error because dont recognize del double quote,
now the syntax must use single quoted '1', '2' li...
Powerbuilder 9.0 Migration from powerbuilder 7.0.3 problemHi all,
i was trying an migrate an powerbuilder 7.0.3 application to powerbuilder
9.0(PFC BASED APPLICATION (PFC objects version PB 6.5) ) during migration i am
getting this error.
tcmborrower.pbl(w_cursor_check).w_cursor_check.open.2: Error C0163: The
definition of referenced global variable sqlca was improperly compiled in object
trcomps
Did anybody faced this kind of error?
Thx
Ashok
JPMORGAN
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
First error message which i got during the migration is :
tcmappl.pb...
PowerBuilder 5.0.3 strange problem with SQL Server 7.0Hi,
I am doing a simple select statment in a PB script, it works fine if
I am connected to a SQL Anywhere DB with odbc, but the same code will not
work if I am connected to MS SQL Server!
The code is something like:
int li_total
Select count(*) from sfref into :li_total;
I will not get an SQL error BUT li_total will not be updated!! Howerver the
same code will work fine with SQL Anywere!
Any help would be great!!
Don't know why it works at all, it's not standard syntax. Maybe something
that works in SQL Anywhere. Anyway, it should be:
Select count(*...
how do you do a select into using powerbuilder 8.0 connecting to sql server 7.0I have a powerbuilder app that used to connect to a sql anywhere database
that is now connecting to sql server. I have found an equivalent to the
today(*) function:
select substring(convert(char(10), getdate(), 120), 1, 10)
The problem with this is that it will not work in a select-into because sub
quereies are not allowed. So, what I want to do is a select-into using the
above conversion query, store it in a local date variable above but I keep
getting a syntax error(I have also tried using a local string variable and
I get the same error) . Here is the code that generates the...
PowerBuilder 5.0.3 strange problem with SQL Server 7.0Hi,
I am doing a simple select statment in a PB script, it works fine if
I am connected to a SQL Anywhere DB with odbc, but the same code will not
work if I am connected to MS SQL Server!
The code is something like:
int li_total
Select count(*) from sfref into :li_total;
I will not get an SQL error BUT li_total will not be updated!! Howerver the
same code will work fine with SQL Anywere!
Any help would be great!!
Don't know why it works at all, it's not standard syntax. Maybe something
that works in SQL Anywhere. Anyway, it should be:
Select count(*...
Connect MS-SQL 7.0 in PowerBuilder 7.0In 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
Masun wrote:
> 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 ?
...
PowerBuilder 7.0 & SQL Server 7.0Hi:
I've develop an application that connect to and MS SQL SERVER 7.0 database
via ODBC. When i make the .exe file and run it in Win95 or Windows NT
Workstation it works fine, but when i run it in a Win98 client the following
error apears.
SQLSTATE=22005 - "Invalid character value for cast specification."
Any clues about this.
The exe was build in PowerBuilder 7.0 over a Windows NT Workstation 4.0
Thanks in advance.
Jorge,
Try adding to the dbparm - CallEscape='No'. Here is an example:
SQLCA.DBParm = "Connectstring='DSN=<your ...
PowerBuilder 7.0 & SQL Server 7.0Hi:
I've develop an application that connect to and MS SQL SERVER 7.0 database
via ODBC. When i make the .exe file and run it in Win95 or Windows NT
Workstation it works fine, but when i run it in a Win98 client the following
error apears.
SQLSTATE=22005 - "Invalid character value for cast specification."
Any clues about this.
The exe was build in PowerBuilder 7.0 over a Windows NT Workstation 4.0
Thanks in advance.
Jorge,
Try adding to the dbparm - CallEscape='No'. Here is an example:
SQLCA.DBParm = "Connectstring='DSN=<your ...
POWERBUILDER 7.0I am having problems getting updates to commit through powerbuilder. We
have a few layers of stored procedures which make the queries a little
long. Have tried MSS, ODBC, OLE DB connections, we've been messing with
connection options for weeks, nothing seems to work. ODBC traces show
success.
This may not help you much; but, we have been using PB 7.0 with MS SQL Server
7.0 for months in a production application and have never had a problem with
commits on updates (using native MSS drivers). So, I would look at your own
code.
Where do you issue the commits?
regards
...
pb 7.0.3 build 10089 and sql server 7.0 : Slow ConnectionWe've got the same problem as earlier mentioned by Ken Freeman (see message
below),
but we're using pb version 7.0.3 Build 10089 and sql server 7.0?!!?
Can anyone help us?
"Ken Freeman" <kfreeman@ems.jsc.nasa.gov> wrote in message
news:p1fXadCIBHA.201@forums.sybase.com...
> We've recently upgraded from PB 6.5 to PB 7.0.2 (Build 8003).
> Before the upgrade, a connection in development mode took a few seconds.
> Now it takes several minutes.
>
> Does anyone know what might be cause the slowdown?
>
> Thanks,
> Ken
>
>
...
Powerbuilder 5.0/7.0 and MS SQL 7.0 Performance issuesWe 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...
Connection of PB 6.0 to SQL Server 7.0 & Version B/W PB 6.0 and PB 7.0Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please
remember we are not planning to upgrade both software. When I was trying to
connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003".
OS=NT 4.0 Server
PB=6.0 Enterprise Edition
SQL SERVER=7.0 Corporate Edition
I also want to know the versions between PB 6.0 to PB 7.0
If your are using the ODBC, which I assume you are, include Disablebind=1 in
your DBParm. If your deployment environment is also NT, you will have to
turn SQLSPY=1 using PFC services. Autocommit=FALSE and SetTransObject()
ra...
Help me about connecting PB 6.0 to SQL Server 7.0 & Versions B/W PB 6.0 and PB 7.0Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please
remember we are not planning to upgrade both software. When I was trying to
connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003".
OS=NT 4.0 Server
PB=6.0 Enterprise Edition
SQL SERVER=7.0 Corporate Edition
I also want to know the versions between PB 6.0 to PB 7.0
I don't believe this is going to be possible without at least upgrading to the
latest maintenance release of 6.x.
On Mon, 23 Aug 1999 00:59:56 -0700,
in powersoft.public.powerbuilder.database
Abdul Lateef <abdul_lat...
PowerBuilder 5.0.04 and Microsoft SQL Server 7.0I am having problems with a powerbuilder 5.0.04 application that uses
pipeline objects. The only thing that has changed is the destination
database has recently been upgraded from Microsoft SQL Server 6.5 to
7.0. We connect via ODBC. After upgrading to 7.0, we get the -4
error code (i.e. Table Not Found).
Does anyone know if any new drivers are needed to support Microsoft
SQL Server 7.0?
Thanks,
Victoria
I am not sure but there is a 3.70 ODBC Driver from Microsoft. I am not
sure the older driver works ok with MS 7.0.
pv
Victoria Kelsey wrote:
>
> I am having...