|
you are bad, you may be the worst of us all.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
He is, indeed. Intentionally didn't mention the or's at all
|
|
|
|
|
And I thought Luc was bad
|
|
|
|
|
No way.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
r.kh wrote: please send me the er of codeproject.com
I assume by 'er' you really mean Entity-relationship model? Correct? There used to be a site similar in setup to Code Project (not written by Chris), not sure what ever happened with it though. You might go looking around the web development articles and find something interesting to learn from.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
When a variable in my stored procedure contains an apostrophe, it returns me an error.
CREATE PROCEDURE sp_GetEZQueryList @@sUser as nchar(500), @@sSupervisor as char(1), @@sAllowed as varchar(8000) AS
--set @@sUser = REPLACE(@@sUser, '''''','''''')
IF @@sSupervisor <> 'Y'
SELECT
EzqDateMod, EzqFlxID, EzqUserName, EzqName, EzqData, EzqDescrip
FROM EZQuery
WHERE (EzqUserName=@@sUser)
OR (EzqUserName='SYSTEM' AND Cast(EzqFlxID as varchar(10)) IN (select * FROM intlist_to_tbl(@@sAllowed)))
ELSE
SELECT
EzqDateMod, EzqFlxID, EzqUserName, EzqName, EzqData, EzqDescrip
FROM EZQuery
GO
The SP is retrieving @@sUser from VB and its getting the value Do'Sullivan.
When I ran a trace I found it is executing the SP like this
exec sp_getezquerylist 'DO' + CHAR(39) + 'SULLIVAN', 'n', '100'
Think + CHAR(39) + is causing the error
Thanks
Waiting for your suggestions
|
|
|
|
|
You have already posted this message in this forum. Repeating it will only annoy the people who might otherwise give you a solution.
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Hi
I want to generate alpha numeric no like this:
If I say length is 4 it generates like
0001
0002
0003
---
---
---
9999
A001
A002
---
---
---
A999
B001
---
---
zzzz
Please help
Thanks in advance
|
|
|
|
|
You might be able to do something like this with two columns. Put a normal running number in one column and then populate the other column based on the value in the first one:
Col 1 Col 2
1 0001
...
999 0999
...
9999 9999
10000 A001
etc.
My advice is free, and you may get what you paid for.
|
|
|
|
|
|
SELECT CAST(RAND() * 1000 AS VARCHAR) AS [Random_Number]
|
|
|
|
|
I'm trying to display an SSRS report in a ReportViewer control in a WinForms application. Here's the Form_Load...
private void Form1_Load(object sender, EventArgs e)
{
reportViewer1.ServerReport.ReportServerUrl = new Uri("http://192.168.2.5/reportserver");
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = CredentialCache.DefaultCredentials;
string reportFile = @"C:\Report Project1\Report1.rdl";
reportViewer1.ServerReport.ReportPath = reportFile;
reportViewer1.ProcessingMode = ProcessingMode.Remote;
reportViewer1.ServerReport.DisplayName = "Corporate View Report";
ReportParameter[] parameters = new ReportParameter[3];
parameters[0] = new ReportParameter("@ProjectId", "6");
parameters[1] = new ReportParameter("@PrimaryWhseId", "8293");
parameters[2] = new ReportParameter("@SecondaryWhseId", "8290");
reportViewer1.ServerReport.SetParameters(parameters);
try
{
reportViewer1.RefreshReport();
}
catch(Exception ex)
{
throw ex;
}
}
With the reportViewer1.ServerReport.SetParameters(parameters); line uncommented, at this point the form pops ups, the repot is blank, and nothing else happens after that.
If I comment out the parameters and run it the form runs and in the viewer control I get "The request failed with HTTP status 401: Unauthorized".
I can't find any examples of displaying a SSRS report in a WinForms application.
I could really use some help here.
Thanks
Everything makes sense in someone's mind
|
|
|
|
|
|
Hello All ,
I am trying to connect my server with oracle database. but getting the following error--
Can anyone suggest me what to do ----
=====================================================
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 13 20:23:32 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> set head off
SQL> grant dba to msdp;
grant dba to msdp
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> startup
ORACLE instance started.
Total System Global Area 566231040 bytes
Fixed Size 1291772 bytes
Variable Size 243272196 bytes
Database Buffers 314572800 bytes
Redo Buffers 7094272 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error
SQL>
Thanks
Ish Kumar Kapila
|
|
|
|
|
Check what error messages you have in the alert.log after the startup command (easiest to start to read the log from the end).
|
|
|
|
|
Hi , I am unabel to find the alert.log in oracle installation folder.
Can u help me where to relocate it.
Thanks
Ish Kumar Kapila
|
|
|
|
|
it should be in a directory like
<oracle root>/admin/<instancename>/bdump
You can also search for a file named alert*.log
|
|
|
|
|
Hello Buddy ....!!!
Sorry , dear unable to find the file.
any other way around ...
Thanks
Ish Kumar Kapila
|
|
|
|
|
I hope this is a stupid question.
But you are looking on the server, right?
|
|
|
|
|
Well Buddy ,
I am new to oracle and did what ever was possible ... but no luck
Thanks 4 the help
Ish Kumar Kapila
|
|
|
|
|
Without finding the alert.log, it's quite hard to find out the cause for the error.
If the server is windows, open a command prompt on the server where the Oracle is installed, go to each of your drives root (for example c:\, d:\, e:\) and try find the file with dir:
dir /s alert*.log
|
|
|
|
|
Sorry .........
Ish Kumar Kapila
|
|
|
|
|
Then I'm afraid there's not much to work with. The error you got can be caused because of several different reasons. I'm sorry to say, but without getting the details, it's just wild goose chase.
|
|
|
|
|
Sorry for the rant, but even WinXP has a 'search' function in it's Explorer, so you should easily able to locate the file - if it exists ...
{Addition] www.giyf.com
the 4th result (from ora-00603) leads to a response like:
???\oracle\admin\aso\udump\aso_ora_1360.trc
HTH
modified on Wednesday, April 13, 2011 6:10 PM
|
|
|
|
|
We are running SQL 2008 R2 Enterprise server with ASP Persistent sessions and our main data DB on the same 2008 R2 Enterprise server. We're currently experiencing random freezes where all websites and applications accessing the DB become un-responsive.
Has anyone same problem and how you solved it.
Any suggestion?
Thx
We live in a Newtonian world of Einsteinian physics ruled by Frankenstein logic
|
|
|
|