|
The following article[^] should help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
thanks alot..really very nice....bye
|
|
|
|
|
Hello All,
I am using SSRS 2005. How do I do forms authentication based on user's role. I have searched on web and applied the code. I have used msdn supplied codes but no progress. I am struggling from many days over this issue. Can anyone help me please by giving me proper code wise solution?
Hello Paul M.,
Can you help me please. I have modified the code. I have put one another message, please help me for that also. Please give me any clue. so that I do the required settings with my reporting server and for client pc. If any setting require with cookie management and DCOM etc. please let me know.
Regards,
Manoj Sinha
-- modified at 11:03 Wednesday 28th November, 2007
|
|
|
|
|
i need solution for this question.
the question is given below :
Print the information of invoice table in the following format for all records –
The Invoice No. of Customer Id. {cust_id} is {inv_no} and Movie
No. is {mv_no)
|
|
|
|
|
SELECT 'The Invoice No. of Customer Id. ' + Cast(cust_id AS Varchar(100)) + ' is ' + Cast(inv_no AS Varchar(100)) + ' and Movie No. is ' + Cast(mv_no AS Varchar(100)) FROM TableA
Assuming all the three columns are are numeric (Cust_id, Inv_no, mv_no
Regards
KP
|
|
|
|
|
Hello,
I have executed a stored procedure written in SQL Server by calling it through VC++.
It was done through ODBC APIs SQLConnect(),SQLBindParameter(),SQLExecDirect() etc.
Now I want to pass parameters to the procedure I know the syntax that I am suppose to write in VC++.
But what changes should I make in the procedure in SQL Server.
I have the following stored procedure in SQL in which I want to accept 'LPG' and 'Mumbai' as parameters
CREATE PROCEDURE tryproc AS
SET @first = 0;
( SELECT SUM(t) AS first FROM demand WHERE product = 'LPG' AND LOCATION = 'Mumbai' )
create table abc (demandsum int);
insert into abc (demandsum) values (@first);
Is this the right forum to ask this question ?else direct me to the right forum.
Thanks
Prithaa
|
|
|
|
|
Read the documentation[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
CREATE PROCEDURE tryproc(@product varchar(10),@LOCATION varchar(50))
AS
SET @first = 0;
SELECT SUM(t) AS first FROM demand WHERE product = @product AND LOCATION = @LOCATION
create table abc (demandsum int);
insert into abc (demandsum) values (@first);
N.Rajakumar B.E.,
Application Developer
|
|
|
|
|
prithaa wrote: Is this the right forum to ask this question ?
Yes it is.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hello All,
I am using SSRS 2005. I have problem on logon page, when cookie is not available. This should generate new cookie: But I am getting error and control returns.
I am getting following error: [System.NullReferenceException] = {"Object reference not set to an instance of an object."}
This comes with the 4th line of the code:
Following is the code:
internal static void RelayCookieToClient(Cookie cookie)
{
// add the cookie if not already in there
if (HttpContext.Current.Response.Cookies[cookie.Name] == null)
{
HttpContext.Current.Response.Cookies.Remove(cookie.Name);
}
HttpContext.Current.Response.SetCookie(TranslateCookie(cookie));
//HttpContext.Current.Response.AppendCookie(TranslateCookie(cookie));
}
-- modified at 1:13 Wednesday 28th November, 2007
|
|
|
|
|
There's 3 problems with your post.
1. Your title is too vague. Read the forum guidelines.
2. You haven't asked a specific question.
3. You've posted too much code. There's too much stuff to wade through. Again, identify what your problem specifically is and post only the code that is relevent.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hello Paul,
Can you help me please. I have modified the code. I have put one another message, please help me for that also. Please give me any clue. so that I do the required settings with my reporting server and for client pc. If any setting require with cookie management and DCOM etc. please let me know.
Regards,
Manoj Sinha
|
|
|
|
|
I'm not really sure what the problem is. I can see that you have lifted the code from a Microsoft sample application though. In the Microsoft sample, they use SetCookie rather than AppendCookie . However I'm not sure whether this is significant.
Is the code actually falling over on this line, or it it failing in TranslateCookie ?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I am installing a new server, created my database with a script, loaded my database with my data. Using Enterprise manager, right click a table return all rows works fine, everything looks normal.
Now, go to SQL Query analyzer and run a select * from the table and I get no rows.
Create and ODBC connection and link the table in Access and I see my data, run a query from a simple web page and get no data.
any ideas?
Thanks in advance....
|
|
|
|
|
No-e wrote: Now, go to SQL Query analyzer and run a select * from the table and I get no rows.
Is it running in the same security context?
|
|
|
|
|
hi
i have a problem that is cause of my amfusing
i cannot login to my sql database account from query analyzer.
but my site work correctly.
the error is:
unable to connect to ??????? server:
error: msg 11,level 16,state 1
general network error,check your documentation network.
please help me
nobody help you...
you have to help you yourself
and this is success way.
|
|
|
|
|
hi
its Either your password is wrong , or you are Connecting to a wrong Server, that has no User that you want to Exit, remember that the useer does not roam, if you have create a user for a certain server , it will not work in other servers, i suggest you try to create a new user with the same name as the one you are saying, you have, if it says it exists, them the user does not exists in that server.
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hello,
I am new to ADO and have to learn it for work so im playing aroud with it...my problem is that I have a blank datagrid on my form. I am trying to make a connection to an oracle database and create an SQL statement to retrieve the data I want and then display this in my datagrid...this is my code:
Dim dsWorkGroup As New DataSet 'New data set
'New connection string and variable to hold connection string ( i am sending the actual user name and password in the string)
Dim connectionString As String = "Data Source=PIDBDEV;User ID=######; Password=######;Unicode=True"
Dim connection1 As New OracleClient.OracleConnection(connectionString)
'Sql statement to retrieve the fields to fill the dataset
Dim selectStatement As String = "SELECT Group_Name FROM BASE_CALC_CODES"
Dim selectCommand As New OracleClient.OracleCommand(selectStatement, connection1)
Dim daWorkGroup As New OracleClient.OracleDataAdapter(selectCommand)
daWorkGroup.Fill(dsWorkGroup)
also I do have a datasourse attached to the datagrd. What am I doing wrong??? It isnt displaying the results from the query...it displays the entire table.
Erica
|
|
|
|
|
hi Erica
i have never connected to an Oracle DB, but now, you did not bind the datagrid to your dataset.
after the last line in your code, put the following line
Datagrid1.DataMember = "BASE_CALC_CODES"
Datagrid1.DataSource = dsWorkGroup
.
and i have an article, that has something like this, it might help you understand some of this and dont forget to vote.
http://www.codeproject.com/useritems/N-Tier_Application_VB.asp[^]
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hello All,
First, I did try to search for the answer to this one and I either didn't use the correct keywords or something because the system didn't return any hits; so here I am.
Simply, I know there is a way to insert the same data into 2 different tables but I need to do it within 2 different databases. I am using a stored procedure but I am not sure how to set it up in the procedure. I know I need to enclose it in a transaction but how do I direct the insert to populate the second table in the other database?
Any assistance would be greatly enjoyed.
Fred
|
|
|
|
|
Are your two databases on the same server? If so, you can reference tables in the other database using the syntax database.owner.mytable .
If the two databases are on different servers, you can set up one of the servers as a linked server in your other server.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Paul,
Thanks for the quick response. I gave it a try on some test tables I created and executed the SP and had a return value of '0' which is good. The only problem is that the information I tried to insert was not in either table
Below is what I created, could you take a look and see if I am missing something.
-- Insert statements for procedure here
BEGIN TRANSACTION
INSERT INTO ff_test(TestInput, TestInputCode)
VALUES('INSERTED','1')
IF @@ERROR <> 0 BEGIN
ROLLBACK TRANSACTION
RETURN 2
END
INSERT INTO [FEDEX].[dbo].ff_test(TestInput, TestInputCode)
VALUES('INSERTED','1')
IF @@ERROR <> 0 BEGIN
ROLLBACK TRANSACTION
RETURN 3
END
COMMIT TRANSACTION
RETURN 0
|
|
|
|
|
Your code looks OK, so I'm not sure what the problem is. I would try running the SQL Profiler to determine which statements in your stored procedure are actually being executed.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Not sure what was going on there but the information is now in the tables, and representative of each time I tried to execute the program. Weird but now ok. I will futz around some more to clean it up but again "THANKS" for the pointer. It works.
F
|
|
|
|
|
I would like to import my HOST file into a DB Table and the periodically run a script to verify if all the entries are the same, changed, deleted, etc.
|
|
|
|