SQl server 7.0 and Powerbuilder 9.0
Hello 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 problem
Hi 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.0
Hi, 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.0
I 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.0
Hi, 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.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 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.0
Hi: 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.0
Hi: 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
I 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 Connection
We'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 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...

Connection of PB 6.0 to SQL Server 7.0 & Version B/W PB 6.0 and PB 7.0
Can 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.0
Can 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.0
I 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...