PB 8.0.0.1 - MS SQL Server 7 Question using OLE DB.

We have a module whereby we insert/update records using a SP. We grab all
the datawindow column values into variables and execute the SP using those
variables.

The SP has 90 parameteres. I get a GPF when calling this SP using OLE DB.
The same thing works fine using native driver.

I am using PB 8.0.1 ( Build 8004 ) and MS SQL Server 7.0 on a Windows 2000
computer.

Any help in this matter will be appreciated.

Thanks,

Ashish.



0
Ashish
4/9/2002 6:52:54 PM
sybase.powerbuilder.database 9855 articles. 1 followers. Follow

4 Replies
661 Views

Similar Articles

[PageSpeed] 6

Are any of those parameters OUT parameters?  Are you calling the stored
procedure in embedded SQL or as via RPCFUNC on the transaction object?

On Tue, 9 Apr 2002 11:52:54 -0700,
 in powersoft.public.powerbuilder.database
Ashish Parekh <aparekh@ladco.com> wrote: 
>We have a module whereby we insert/update records using a SP. We grab all
>the datawindow column values into variables and execute the SP using those
>variables.
>
>The SP has 90 parameteres. I get a GPF when calling this SP using OLE DB.
>The same thing works fine using native driver.
>
>I am using PB 8.0.1 ( Build 8004 ) and MS SQL Server 7.0 on a Windows 2000
>computer.
>
>Any help in this matter will be appreciated.
>
>Thanks,
>
>Ashish.
>
>
>

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com
http://www.needhim.org

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Bruce
4/9/2002 7:34:43 PM
The SP does not have any OUT parameters. I am using
Powerbuilder's DECLARE & EXECUTE statements.

Thanks,

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
wrote in message news:QPbSZ2$3BHA.278@forums.sybase.com...
> Are any of those parameters OUT parameters?  Are you calling the stored
> procedure in embedded SQL or as via RPCFUNC on the transaction object?
>
> On Tue, 9 Apr 2002 11:52:54 -0700,
>  in powersoft.public.powerbuilder.database
> Ashish Parekh <aparekh@ladco.com> wrote:
> >We have a module whereby we insert/update records using a SP. We grab all
> >the datawindow column values into variables and execute the SP using
those
> >variables.
> >
> >The SP has 90 parameteres. I get a GPF when calling this SP using OLE DB.
> >The same thing works fine using native driver.
> >
> >I am using PB 8.0.1 ( Build 8004 ) and MS SQL Server 7.0 on a Windows
2000
> >computer.
> >
> >Any help in this matter will be appreciated.
> >
> >Thanks,
> >
> >Ashish.
> >
> >
> >
>
> Bruce Armstrong [TeamSybase]
> http://www.teamsybase.com
> http://www.needhim.org
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


0
Ashish
4/9/2002 8:00:13 PM
One big difference between the MSS driver and the OLEDB driver (among many)
is that the OLEDB driver - even when you call a stored procedure via
DECLARE/EXECUTE - implements it via an RPCFUNC call.  From what I can tell,
it's the OLEDB interface itself that is doing that, not the PB OLEDB driver.
That's why it causes problems, in particular, for string type OUT arguments.
When those are called using RPCFUNC, they have to be padded before they are
passed.

I'm not having problems with stored procedure calls to MS SQL Server using
OLEDB with either RPCFUNC or DECLARE/EXECUTE other than that, but I don't have
any that take 90 parameters.  Could I suggest your trying to create a test
case with 10 parameters, then modifying it to take 20, then 30, etc., until
your test case crashes.  I'm going to guess that there is some limit on the
number of parameters it can handle.

On Tue, 9 Apr 2002 13:00:13 -0700,
 in powersoft.public.powerbuilder.database
Ashish Parekh <aparekh@ladco.com> wrote: 
>The SP does not have any OUT parameters. I am using
>Powerbuilder's DECLARE & EXECUTE statements.
>
>Thanks,
>
>"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
>wrote in message news:QPbSZ2$3BHA.278@forums.sybase.com...
>> Are any of those parameters OUT parameters?  Are you calling the stored
>> procedure in embedded SQL or as via RPCFUNC on the transaction object?
>>
>> On Tue, 9 Apr 2002 11:52:54 -0700,
>>  in powersoft.public.powerbuilder.database
>> Ashish Parekh <aparekh@ladco.com> wrote:
>> >We have a module whereby we insert/update records using a SP. We grab all
>> >the datawindow column values into variables and execute the SP using
>those
>> >variables.
>> >
>> >The SP has 90 parameteres. I get a GPF when calling this SP using OLE DB.
>> >The same thing works fine using native driver.
>> >
>> >I am using PB 8.0.1 ( Build 8004 ) and MS SQL Server 7.0 on a Windows
>2000
>> >computer.
>> >
>> >Any help in this matter will be appreciated.
>> >
>> >Thanks,
>> >
>> >Ashish.
>> >
>> >
>> >
>>
>> Bruce Armstrong [TeamSybase]
>> http://www.teamsybase.com
>> http://www.needhim.org
>>
>> ---== Posted via the PFCGuide Web Newsreader ==---
>> http://www.pfcguide.com/_newsgroups/group_list.asp
>
>

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com
http://www.needhim.org

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Bruce
4/10/2002 4:33:48 PM
You might also consider the combined datalength of the parameters.  Probably
the total based on max possible.  I suspect that something bad may happen
when it passes the configured network block size or the max row size (8K)


"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
wrote in message news:UjWa91K4BHA.204@forums.sybase.com...
> One big difference between the MSS driver and the OLEDB driver (among
many)
> is that the OLEDB driver - even when you call a stored procedure via
> DECLARE/EXECUTE - implements it via an RPCFUNC call.  From what I can
tell,
> it's the OLEDB interface itself that is doing that, not the PB OLEDB
driver.
> That's why it causes problems, in particular, for string type OUT
arguments.
> When those are called using RPCFUNC, they have to be padded before they
are
> passed.
>
> I'm not having problems with stored procedure calls to MS SQL Server using
> OLEDB with either RPCFUNC or DECLARE/EXECUTE other than that, but I don't
have
> any that take 90 parameters.  Could I suggest your trying to create a test
> case with 10 parameters, then modifying it to take 20, then 30, etc.,
until
> your test case crashes.  I'm going to guess that there is some limit on
the
> number of parameters it can handle.
>
> On Tue, 9 Apr 2002 13:00:13 -0700,
>  in powersoft.public.powerbuilder.database
> Ashish Parekh <aparekh@ladco.com> wrote:
> >The SP does not have any OUT parameters. I am using
> >Powerbuilder's DECLARE & EXECUTE statements.
> >
> >Thanks,
> >
> >"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
> >wrote in message news:QPbSZ2$3BHA.278@forums.sybase.com...
> >> Are any of those parameters OUT parameters?  Are you calling the stored
> >> procedure in embedded SQL or as via RPCFUNC on the transaction object?
> >>
> >> On Tue, 9 Apr 2002 11:52:54 -0700,
> >>  in powersoft.public.powerbuilder.database
> >> Ashish Parekh <aparekh@ladco.com> wrote:
> >> >We have a module whereby we insert/update records using a SP. We grab
all
> >> >the datawindow column values into variables and execute the SP using
> >those
> >> >variables.
> >> >
> >> >The SP has 90 parameteres. I get a GPF when calling this SP using OLE
DB.
> >> >The same thing works fine using native driver.
> >> >
> >> >I am using PB 8.0.1 ( Build 8004 ) and MS SQL Server 7.0 on a Windows
> >2000
> >> >computer.
> >> >
> >> >Any help in this matter will be appreciated.
> >> >
> >> >Thanks,
> >> >
> >> >Ashish.
> >> >
> >> >
> >> >
> >>
> >> Bruce Armstrong [TeamSybase]
> >> http://www.teamsybase.com
> >> http://www.needhim.org
> >>
> >> ---== Posted via the PFCGuide Web Newsreader ==---
> >> http://www.pfcguide.com/_newsgroups/group_list.asp
> >
> >
>
> Bruce Armstrong [TeamSybase]
> http://www.teamsybase.com
> http://www.needhim.org
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


0
Tyler
4/14/2002 4:10:48 PM
Reply:

Similar Artilces:

Using OLE DB w/ PB 8 and SQL Server 7.0
We are currently using the native connection to access SQL Server. I have a couple of questions: 1. What version of MDAC is acceptable? 2. I dont believe we have applied any service packs to SQL Server. Do we need a certain level of updates applied to SQL Server? Thanks in advance Greg ...

superreview requested: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
Robert Kaiser <kairo@kairo.at> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ------- Additional Comments from Robert Kaiser <kairo@kairo.at> This is the 1.8.0 branch patch for bumping SeaMonkey version to 1.0.7 ...

superreview granted: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
neil@parkwaycc.co.uk <neil@httl.net> has granted Robert Kaiser <kairo@kairo.at>'s request for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ...

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

PROBLEM with PB 7.0.3 AND SQL SERVER 7.0 USING SQL CURSOR
I am having a problem running a sql command with a cursor with Native drivers for MS sql Server 7.0.If i use ODBC or take out the order by clause in the statement it works fine By the way I am running powerbuilder 7.0.3 build 10009 The error code is : (Error 10008 (DB-Library) DB-Library Severity Level 9 Message Text ad token from SQL Server: Datastream processing out of synchronization) here a sample of the code DECLARE cur_Sec1 CURSOR FOR SELECT DISTINCT COL1,COL2 FROM TABLE1 WHERE COL1 = ??? ORDER BY COL1 ASC ; <<<<<<<<<<< ...

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

Using Mobilink Server/Client 7.0.1(with Schduler Support) on Database 7.0.0(no Schduler support)?
I have a Problem that i can not upgrade my Database (7.0.0) to 7.0.1 becase it works with a Application that works only with the 7.0.0 Version can i use the Mobilink Syncr. Server and Client 7.0.1 with a Database Version 7.0.0 i need this because i need to use the Schduler for my Clients! i would like to know if this Possibe or not Thank you for Supporting Matani "Matani" <saleh@matani.net> wrote in news:O7$GB47SDHA.346@forums-2-dub: > I have a Problem that i can not upgrade my Database (7.0.0) to 7.0.1 > becase it works with a Application tha...

PB 6.5 with ASA 7.0.4 or ASA 8.0 using OLE DB
Can anybody send me the Syntax i wud use to connect to ASA using OLE DB drivers. Where wud i find this driver, i know sybase provides ASAPROV but how do i configure it. How do i go about setting an OLE DB datasource ?? Any suggestions will be greatly appreciated . Thanks Ravi You cannot use OLEDB in PB 6.5. You need PB 7 or later. /ck "Ravi" <ravinath@hotmail.com> wrote in message news:diBoke2eCHA.196@forums.sybase.com... > Can anybody send me the Syntax i wud use to connect to ASA using OLE DB > drivers. Where wud i find this driver, i know ...

PB 8 crashes when using Oracle 8.1.7.0.0 for large retrieve
When I run my PB 8 build 9506 application using Oracle 8.1.7.0.0 client, I get the following error. If I use Oracle 8.0.5 client, it works. Please advise as I need to be on Oracle 8i. Number 3120 Select error: ORA-03120: two-task conversion routine: integer overflow What version of the database are you connecting to? Don't use 8i client to go against 8.0 database. The client should never be a higher version than the database. I strongly suggest using 81726 instead of 81700, which is flaky. -- Terry Dykstra (TeamSybase) http://powerbuilder.co...

connecting to oracle 8.1.6 using PB 7.0.2 and native driver 8.0.4
I am having a problem with connecting our deployed application in PB 7.0.2 and connecting it to an Oracle 8.1.6 using the native 8.0.4/8.0.5 driver. We get the message that "The DBMS O84 is not supported in the current installation.999" We recently upgraded from Oracle 7.3.2 to Oracle 8.1.6 The development team is working great. I can connect to the database in PB and with the compiled exe. However, we just gave the first test exe to the testers and they cannot connect to Oracle 8.1.6 Here is the run-down of what I looked for: The testers did have the Oracle client in...

Synchronizing 7.0 ASA DB using 8.0 MobiLink Server
Hello, We are using MobiLink 8.0 to synchronize mutiple remote DBs. One of the DBs is a 7.0 ASA DB, and a project requirement is that it cannot be updated. Can you synchronize a 7.0 ASA Remote DB using a 8.0 MobiLink server? Someone told me they tried syncronizing a 7.0 ASA remote DB using an 8.0 MobiLink client and it failed. Any insight into this will be appreciated. Thanks, Bill Yes, this should work. If you are using a database that was dbinited with 7.x software then you would do the following: 7.x database --> 7.x dbmlsync --> 8.x mobilink serve -- D...

superreview granted: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246922] 1.8 patch: SeaMonkey version -> 1.1, localeVers
neil@parkwaycc.co.uk <neil@httl.net> has granted Robert Kaiser <kairo@kairo.at>'s request for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246922: 1.8 patch: SeaMonkey version -> 1.1, localeVersion -> 1.8.1 https://bugzilla.mozilla.org/attachment.cgi?id=246922&action=edit ...

superreview requested: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246922] 1.8 patch: SeaMonkey version -> 1.1, localeVe
Robert Kaiser <kairo@kairo.at> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246922: 1.8 patch: SeaMonkey version -> 1.1, localeVersion -> 1.8.1 https://bugzilla.mozilla.org/attachment.cgi?id=246922&action=edit ------- Additional Comments from Robert Kaiser <kairo@kairo.at> ...and here's the 1.8 branch patch, setting SeaMonkey version to 1.1 for final, and locale...

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

Web resources about - PB 8.0.0.1 - MS SQL Server 7 Question using OLE DB. - sybase.powerbuilder.database

West Lothian question - Wikipedia, the free encyclopedia
He illustrated his point by pointing out the absurdity of a Member of Parliament for West Lothian being able to vote on matters affecting the ...

Companies have tax questions to answer as working class taxpayers pay more tax than them
Why do working-class taxpayers pay more tax than large companies, in some cases literally and in many cases as a percentage of their income? ...

South Africa: Questions Raised Over Former Minister's Signature On Nuclear Procurement Notice
As questions are raised by opposition parties over former energy minister Ben Martins' signature on the recently gazetted notice to move ahead ...

Question Of The Day: Greatest hood scoop ever?
Filed under: Automotive History Just about every manufacturer has installed some sort of scoop, functional or not, to at least one vehicle hood. ...

Jack Dorsey reveals the most important question he asks when hiring new Square or Twitter employees
Jack Dorsey is a busy man. As part of the elite group of tech CEOs who have run two companies simultaneously, Dorsey works up to 18 hours a ...

Review: Ten Economic Questions for 2015
At the end of each year, I post Ten Economic Questions for the coming year. I followed up with a brief post on each question. The goal was to ...

A very important question: What are your Christmas food traditions?
Merry Christmas! I have an important question for you: What do you cook and/or eat on Christmas? Thanksgiving is easy. There’s a standard repertoire ...

Once Upon a Time bosses answer your burning season 5B questions in the EW Hot Seat - EW.com
Once Upon a Time bosses answer your burning season 5B questions in the EW Hot Seat - EW.

'Love & Hip Hop' Season 6: Amina Not Pregnant? 4 Burning Questions We Want Answered Episode 3
"Love & Hip Hop" season six has already gotten off to a rather dramatic start for just about all of the cast members. And after watching the ...

Five Questions With Advertising Executive Kitty Lun, CEO of Lowe China
By Linda Kerstin Kitty Lun, Chairman and CEO at Lowe China, is one of the most awarded and respected advertising professionals in Greater China. ...

Resources last updated: 12/27/2015 11:16:15 PM