Can't base report on stored procedure--'Can't create Datawindow'I installed IM65 today to give it a try. I made a db config to our
local ASE 11.9.2 engine via Sybase' odbc driver that came with 11.9.2.
I start a new report, tell it to be tabular and to get data from a SP.
It asks which SP and I tell it. The result is an odbc error:
Cannot create DataWindow
Intersolv SQL ODBC driver: Incorrect syntax near '='.
1 execute dbo.sp_si_addressbest_;0 RETURN_VALUE = :RETURN_VALUE'
I can execute the SP fine from SQL Advantage or from Crytal Reports.
Thanks.
--
Frank Burleigh
Indiana University School of Law
Bloomi...
ODBC, ASE and PowerBuilder : can't use my Stored ProceduresHi,
I'm in trouble trying to use an ASE 11.5 database via ODBC in PowerBuilder 7.
With the native driver, everything run fine.
When I use ODBC instead of SYC, calls to stored procedure don't run as expected.
Depending of the ODBC driver I use, I get different error messages and I can't
use my stored procedure.
Here's the way SP is called:
DECLARE p_dsu_syslog02 PROCEDURE FOR @rv = dsu_acces01 128, @co_niv_hab =
:ls_buffer OUTPUT USING SQLCA;
EXECUTE p_dsu_syslog02;
If SQLCA.SQLCode <> 0 Then
return -1
End if
FETCH p_dsu_syslog02 INTO :code_retour, ...
I can't see my Procedure. Why? This is my first Stored Procedure.
Hello,I created the "MyDb" database using Microsoft SQL 2005 Server Management Studio and I added the table "dbo.Surveys".Then I right clicked on Store Procedures and created a new procedure.When I close it I am asked to save it. I save it and gave the file a name.However my stored procedure doesn't show in the Stored Procedures list.I can only access it by loading the file (File > Open > File). Why?When I open the File the Connect Window shows again.I believe the procedure is created because I used CREATE.When I execute it twice I got the message that there is already another procedur...
PowerBuilder and Oracle 10g: Invalid stored procedure parameter type 'BOOLEAN'Hi,
I am getting the following error message while executing a procedure
'update_status' in the package pkg_test.
Invalid 'Stored procedure parameter type of boolean on DDD'
Here is the signnature of the procedure.
pkg_test.update_status(AAA varchar2, BBB number, CCC number, DDD
varchar2, EEE boolean default false)=91
and the way of calling this procedure is
pkg_test.update_status ('TEST',12,2345,'PLEASEWORK',TRUE)
The communication between the powerbuilder 10.5 and oracle10g is
through the ORACLE 10g drivers. After the execution the SQLCA.SQ...
Powerbuilder Can't find Powerbuilder NVO on ServerI have been trying to get through the PB and Jaguar document, and
specifically I have been working with a Powerbuilder NVO and trying to
load it onto the server, and then access it from Powerbuilder.
I have constructed the Powerbuilder NVO from the oleobject. I placed
one function, with a return type of (NONE) as instructed, with a string
passed by reference. I use the OLE automation tool to compile the .tlb,
..reg files. I have tried this with both .PBD and .DLL with identical
results. Before I load the component on the server, I can see all the
packages and methods normally. A...
PowerBuilder Can't Open DatabaseHi,
I was using the database in PowerBuilder to connect to a SQL Anywhere 7.0
database. When I execute a SELECT statement, the program is aborted. After
I re-start the PowerBuilder and click the 'database icon', the following
error message box appears.
PB70.exe has generated errors and will be closed by Windows. You will need
to restart the program.
An error log is being created.
However, I found nothing on the event viewer. I also try to reinstall the
PowerBuilder but the error still occurs.
Configuratiion of my computer:
1. Windows 2000 Professional with S...
Can't see stored procedures
Hi,
Can anyone help me. I've created a stored procedure in sql server and I'm trying to run it from my asp.net page. On Database Explorer I can't see it, or any for that matter, however I can see tables in the same schema.
Also I can't see it when I build a table adapter either.
Can anybody help?
Thanks
Sam
My first suspicion is that you didn't succeed in creating the stored procedure as you think you have done. To allay that suspicion, can you see the proc in Sql Server Management Studio? Regards Mike [MVP - ASP/ASP.NET]M...
Can't see all of stored procedure....... in the database painter.
When I edit a stored procedure (MSS 7 or MSS 2000 or MSS 2005) in the
database painter, using either PB 9, only part of the stored procedure is
visible. Is there some setting that's causing this? Some buffer size or
something?
CANCEL this question. I'm getting mixed up between PB 11.5 and PB 9 and the
various database releases. Will re-post.
"Laurel" <FakeMail@Hotmail.com> wrote in message
news:4a4b58f5$2@forums-3-dub.sybase.com...
> ... in the database painter.
>
> When I edit a stored procedure (MSS 7...
Can't setfocus with Progress Database in PowerBuilderI'm working with Progress database on SCO-UNIX in PowerBuilder 5.0.03, and
when I run my application and
want to insert data in datawindow, the focus does'nt appear in the first
data area. But with and another database, like code is fonctionnal. Why I
can't setfocus in the Progress Database.
Thanks in advance
Val
Sigma Solutions informatiques inc.
...
Oracle Package can't call from PowerBuilderHi all!
Are there any one know how we can call Package Stored Procedure in
Oracle8.0.4 from PowerBuilder? When I called Package from PowerBuilder using
the following script, I got"Errors - Database C0038: ORA-2000":
date ld_stdate
string ls_stid
DECLARE proc00 PROCEDURE FOR dtms.rpt00_perm_detailPkg (:ls_stid,
:ld_stdate)
EXECUTE proc00;
However, I can call any stored procedure by using the above script. When I
read PowerBuilder and Oracle8 documentation, I saw it says,"You cannot call
these procedures directly from PowerBuilder because some of the arguments
...
Oracle Package can't call from PowerBuilderHi all!
Are there any one know how we can call Package Stored Procedure in
Oracle8.0.4 from PowerBuilder? When I called Package from PowerBuilder using
the following script, I got"Errors - Database C0038: ORA-2000":
date ld_stdate
string ls_stid
DECLARE proc00 PROCEDURE FOR dtms.rpt00_perm_detailPkg (:ls_stid,
:ld_stdate)
EXECUTE proc00;
However, I can call any stored procedure by using the above script. When I
read PowerBuilder and Oracle8 documentation, I saw it says,"You cannot call
these procedures directly from PowerBuilder because some of the arguments
...
Client can't see changes in database (Firebird)Hi,
All clients are connected to a Firebird Database using the
Interbase-components in C++Builder2010. If a client do inserting or
deleting, other clients can't see the changes. The changes are only in
database visible if the first client reconnect to the database. What I'm
doing wrong?
greetings,
johannes
Hi,
This is an InterBase newsgroup, not Firebird.
> All clients are connected to a Firebird Database using the
> Interbase-components in C++Builder2010. If a client do inserting or
> deleting, other clients can't see the changes. The changes are ...
Oracle Package can't call from PowerBuilder #2Hi all!
Are there any one know how we call Package Stored Procedure in
Oracle8.0.4 from PowerBuilder? When I called Package from PowerBuilder
using the following script, I got"Errors - Database C0038: ORA-2000":
date ld_stdate
string ls_stid
DECLARE proc00 PROCEDURE FOR mdtms.rpt00_perm_detailPkg (:ls_stid,
:ld_stdate)
EXECUTE proc00;
However, I can call any stored procedure by using the above script. When
I read PowerBuilder and Oracle8 documentation, I saw it says,"You cannot
call these procedures directly from PowerBuilder because some of the
arguments are...
I can't get no cache, I can't get no cache. 'Cause I try and I try and I try and, I can't get no, I can't get no cache.I have fiddled out for days tinkering with the setting in about:config
trying to get FireFox 12 to use the disk cache. I have NOT found the
trick. This One Trick Pony ain't doing it like it used to up until recently.
Pray tell anyone, What information can I share that will point a
knowledgeable person to aid me in getting FF to disk.cache?
I have also tried restarting FF with add-ons disabled, (There were NOT
too many to do this to, so it was quick and easy)
Here is my stab at trying to convey the information that MIGHT govern
matters
Using about:cache
Informatio...