BUG!!!! ?? Using Stored Procedure with PB 6.5 and MS SQL Server 6.5.

I have some stored procedures on my DBMS, MS SQL Server 6.5. After upgrading
to PB 6.5 I cannot assign any of my stored procedures to a datawindow. What
the .... is wrong. Is it my installation? Is it PB 6.5? In fact it is
serious as my reports are not running.

Any comments are appreciated.

Thomas Door
Maersk Data AS


0
Thomas
8/21/1998 11:05:54 AM
sybase.powerbuilder.general 62418 articles. 17 followers. Follow

3 Replies
738 Views

Similar Articles

[PageSpeed] 54

What is the error you are getting, maybe we could help you then.

Randy

Thomas D��r <thd@maerskdata.dk> wrote in article
<CoL4foOz9GA.276@forums.powersoft.com>...
> I have some stored procedures on my DBMS, MS SQL Server 6.5. After
upgrading
> to PB 6.5 I cannot assign any of my stored procedures to a datawindow.
What
> the .... is wrong. Is it my installation? Is it PB 6.5? In fact it is
> serious as my reports are not running.
> 
> Any comments are appreciated.
> 
> Thomas Door
> Maersk Data AS
> 
> 
> 
0
Randy
8/21/1998 1:27:19 PM
I create a new datawindow using a stored procedure as data source and using
tabular presentation style.

I the get the following error message:

Cannot create datawindow.
SQLSTATE = 22005
[Microsoft][ODBC SQL Server Driver] Error in assignment.

I tried using native driver and that worked OK.

Thomas


0
Thomas
8/24/1998 8:26:45 AM
We've seen this same behavior with 6.5.  I beleive it is related to PB 6.5's
ODBC driver supplied with the install.  I didn't fic the problem, so this is
2nd hand...


Thomas D��r wrote:

> I create a new datawindow using a stored procedure as data source and using
> tabular presentation style.
>
> I the get the following error message:
>
> Cannot create datawindow.
> SQLSTATE = 22005
> [Microsoft][ODBC SQL Server Driver] Error in assignment.
>
> I tried using native driver and that worked OK.
>
> Thomas



0
B
8/25/1998 10:15:14 PM
Reply:

Similar Artilces:

Executing a MS SQL server 6.5 procedure with no result sets from PB 6.5...
Hi friends, I have a stored procedure created in MS SQL Server 6.5. The procedure has 4 arguments. The procedure will do some calculations & then finally will insert some data into a table. That's it. It won't return any resultset (no select statement). Now I need to execute the procedure from within a PB application(verion 6.5). Which is te best method for this. Dynamic SQL format 1/2/.... Thanks in advance. Thanks. Bye. With Regards, Jeinutheen Mohamed. In your PB script, declare the procedure : DECLARE sp_procedure PROCEDURE F...

PB 6.5 AND MS SQL SERVER 6.5
Hi, I have recently converted an 16-bit PB5.0 application to PB6.5. This application goes against a MS SQL SERVER 6.5 database. I have noticed now that the new application won't release locks on tables when I do an insert or update. This application has never had explicit commits coded and I haven't seen soo many locks on tables before until the recent powerbuilder upgrade. Does anyone have some insight on this situation? Chris Edwards Saks Incorporated 331 W. Wisconsin Ave Milwaukee, WI 53203 chris_edwards@saksinc.com ...

PB 6.5 Connection To MS SQL Server 6.5
We have three servers running MS SQL Server 6.5. PB 5.0 applications (both PB client apps and PB apps running on the servers at night as part of batch jobs) have been running on them for a long time. Native drivers are used. I'm starting to replace these apps with PB 6.5 versions of them. With respect to two of the servers, I can connect to the databases from all the new apps - both client PC apps and batch apps. On the third server, I can connect to the databases using the client PC apps only. When the apps in the night job run, the CONNECT statement gets the following error ...

PB 6.5 and MS SQL Server 6.5 SP5a
We are currently running apps in PB 5.0.04 and PB 6.5 with a MS SQL Server database, ver 6.5 SP4. Our DBA wants to apply SP5a to the database. I see many issues regarding a required update for PB 5.0.04. Fine, we'll deal with that. Is there any documentation in existence that verifies that PB 6.5 is compliant with MS SQL Server 6.5 SP5a? Also, does anyone have test results using the new MS SQL Server ODBC driver ver 3.7? Thanks! If its of any help, I couldn't find any hits in the infobase on service pack 5 or ODBC driver 3.7. Either nobody is having problems wit...

PB 5.0 cursor fetch error using MS SQL Server 6.5 (Service Pack 5)
We have PB5.0.02 and are upgrading to PB5.0.04 for Y2K compliance. Both are 16 bit. We have been using MS SQL Server 6.50.201 (the original release). Everything has been fine. We have just put MS SQL Server 6.50.415 (Service Pack 5) on a test server for Y2K compliance and are getting cursor fetch errors using either version of PB5.0. The error is 10037 "unexpected EOF from SQL Server." In looking at the SQL error log we see an EXCEPTION_ACCESS_VIOLATION error message involving sp_cursorfetch. Does this rings any bells with anyone? Is there an upgraded dll (or dlls) ...

PB 6.5 Apps Connection to MS SQL Server 6.5
We have three servers running MS SQL Server 6.5. PB 5.0 applications (both PB client apps and PB apps running on the servers at night as part of batch jobs) have been running on them for a long time. Native drivers are used. I'm starting to replace these apps with PB 6.5 versions of them. With respect to two of the servers, I can connect to the databases from all the new apps - both client PC apps and batch apps. On the third server, I can connect to the databases using the client PC apps only. When the apps in the night job run, the CONNECT statement gets the following error ...

PB 5.0 (16 bit) cursor fetch error using MS SQL Server 6.5 (Service Pack 5)
We have PB5.0.02 and are upgrading to PB5.0.04 for Y2K compliance. Both are 16 bit. We have been using MS SQL Server 6.50.201 (the original release). Everything has been fine. We have just put MS SQL Server 6.50.415 (Service Pack 5) on a test server for Y2K compliance and are getting cursor fetch errors using either version of PB5.0. The error is 10037 "unexpected EOF from SQL Server." In looking at the SQL error log we see an EXCEPTION_ACCESS_VIOLATION error message involving sp_cursorfetch. Does this rings any bells with anyone? Is there an upgraded dll (or dlls) ...

PB 6.5 / MS SQL 6.5 / Stored Procedue dw creation problem
We are beginng to have trouble creating stored procedure datawindows that us an argument in an if statement. Powerbuilder is returning an error message: "Requested result set number 1 not found". The whole message from the trace file is: "PROCEDURE PREPARE: execute dbo.trf_sm_ltl_orders_to_route;1 @as_all = '0' (30 MilliSeconds) Error 999 (rc -1) : Requested result set number 1 not found" If you comment out the IF @as_all = "N" then it will create the dw fine. We can't figure out why this just started because we have been doing this...

PB 6.5, MS SQL Server Stored Procedures
We are using MS SQL Server 7.0 and PowerBuilder 6.5. Up until now, we have never had need to invoke database stored procedures from within our PB apps. Now I wish to invoke sp_setapprole to assist with security. I am having no luck following the clear instructions under the topic "Using Transaction objects to call stored procedures" in Application Techniques in Books Online: - I created the u_trans_database object - I declared a Local External Function defining the procedure function long sp_setapprole(string rolename,string password,string encrypt) RPCFUNC ALIAS FOR ...

PB 5.02 and MS SQL 6.5, stored procedure, SQLDBCode = 3
Hi, I'm having a problem using a cursor based on a stored procedure. When I call the sp via isql it works fine. I get approx 185 lines back. When I use PB and try to loop though the resultset I get SQLCA.SQLDBCode = 3 and SQLCA.SQLCode = 100 after a couple of iterations. No text in SQLCA.SQLErrText. How come the resultsets doesn't match? I have read to MS SQLServer manuals, but the errorcode 3 doesn't exist. Different retrival arguments gives different number of loops. I have looked at the resultset in ISQL, but I haven't found anything suspect. Anyone recognize this...

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

PB 6.5 & MS SQL 6.5
This is probably an MS SQL issue but I figured it was worth presenting here for some possible insight. Any help is greatly appreciated. - I have two tables: BATCH & EMPLOYER_GROUP - BATCH is a child of EMPLOYER_GROUP - EMPLOYER_GROUP_ID is the primary key column in EMPLOYER_GROUP and a foreign key column in BATCH - The EMPLOYER_GROUP_ID column in BATCH may be null - There is current only one record in BATCH. The EMPLOYER_GROUP_ID column is null in that record. The following SELECT does not (in my opinion) work correctly: SELECT * FROM BATCH, EMPLOYER_GROUP ...

Microsoft SQL Server 6.x (PB 6.5) VS ODBC (PB 10.5) ...
Hi everybody, After migrating my application from PB 6.5 which uses Microsoft SQL Server 6.x as a DB connection and having to set up ODBC for PB 10.5 I am getting the following error: "SQLSTATE = 22005, Invalid character value for cast specification" This happen for absolutely every single dw that is created based on an Store Procedure. What could be happening? How can I fix this? Thank you, Gabriela ...

PB 5.0 and MS SQL Server 6.5
I am migrating from SQL Server 6.0 to 6.5 and am wondering if there are any new drivers needed. The current driver is PBMSS050.DLL. Regards Chris Wilson chris.wilson@entex.com In article <35411705.278D@entex.com>, chris.wilson@entex.com says... > I am migrating from SQL Server 6.0 to 6.5 and am wondering if there are > any new drivers needed. The current driver is PBMSS050.DLL > The latest PBMSS050.DLL driver is the one in the 5.0.04 maintenance release. I don't believe there is a new driver specific for 6.5. WHat version of PB are you using? -- ...

Web resources about - BUG!!!! ?? Using Stored Procedure with PB 6.5 and MS SQL Server 6.5. - sybase.powerbuilder.general

Parliamentary procedure - Wikipedia, the free encyclopedia
... of the House of Commons of the Parliament of the United Kingdom , from which it derives its name. In the United States, parliamentary procedure ...

Rushed cosmetic procedures a 'recipe for disaster'
&#8203;When Chanelle O'Hare went searching online for a deal on potential cosmetic procedures, she could not have imagined that what she ended ...

Jetstar procedures under investigation after planes took off too heavy
Jetstar's procedures for calculating the weight of its aircraft are under review by the Australian Transport Safety Bureau after two of its planes ...

Old Lady Lawyer: Uncivil Procedure
What is some of the worst behavior you've witnesses by attorneys?

NFL Announces Changes to Officiating Procedures for Playoffs - Bleacher Report
The NFL formally approved changes to its postseason officiating procedures to allow referees the opportunity to consult Vice President of Officiating ...

We need to reform the culture of law enforcement, not just the procedures
We need to reform the culture of law enforcement, not just the procedures by digby I have a new piece up at Salon this morning about police ...

Will Paul Ryan Make His Mark As Speaker By Instituting Impeachment Procedures Against President Obama ...
Wisconsin Ayn Rand devotee Paul Ryan just started his new job as Speaker of the dysfunctional House Republicans. And he's already headed for ...

Rescued tiger cub "Himmel" dies during medical procedure - CBS News 8 - San Diego, CA News Station ...
Alpine animal rescue sanctuary Lions, Tigers & Bears is sadly reporting Himmel, the tiger cub found roaming the streets of Hemet and rescued ...

Catholic hospital allowed to deny sterilization procedure, judge says
Hospital in California argued that the procedure known as ​tubal ligation would violate its religious freedom

TSA Updates Screening Procedure, Will Mandate Some Passengers Use Full-Body Scanners
... Imaging Technologies, or AIT, in favor of full-body pat-downs by TSA agents. Under the new mandate, not everyone can opt for the pat-down procedure. ...

Resources last updated: 1/22/2016 6:36:19 AM