Posts by Ramy Mahrous

Sure you must upgrade the server not the client :) read the URL content again they solved the problem.

I've tried to set the EnableHeadersVisualStyles to false and it's working.

I didn't change any property and it's working without any problem!!
+ EnableHeadersVisualStyles = true and it's also working...

Analysis and Reporting doesn't mean anything, but it's important to know the cause, did you look to the URL?

Strange :| It works with me...

From your last reply I see something like that before at http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/7e5da9e1-3520-492c-bbe1-3516f0ccecaa/

Try to ask in Microsoft SQL Server forum there's may be a hotfix or trick..

OK, I don't need you to develop something with Integration service, red X because you're missing something (don't care about that right now) you didn't tell me. Does Service Agent work?
Second take a screen shot to the error, and attach it here.

Please mark both threads as solved, if it's :)

It works my friend, I just put the answer here too because it's also related to VB.NET

Dim r As SqlClient.SqlDataReader
r = SQLComm.ExecuteReader()
dgCustomers.DataSource = r

It works fine

Dim r As SqlClient.SqlDataReader
r = SQLComm.ExecuteReader()
dgCustomers.DataSource = r

I'm sure you using SQL Server 2000
So, the error is you didn't give some permission to ASP.NET user who trying access SQL instance, therefore it blocked.
From server security in SQL Server Enterprise Manager, logins right click and add ASPNET user with windows authentication type.
Try running the application again then tell me what happened.

If you traced the SQL Command sent, you'll find it doesn't surround the state within single quotes '
What you need is to modify it Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion & "')", conn)

If you traced the SQL Command sent, you'll find it doesn't surround the state within single quotes '
What you need is to modify it Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion & "')", conn)

Integration services from Start->Microsoft SQL Server 2005->SQL Server Business Intelligence Development Studio try to create new Integration services project
To check Agent Service you'll find it in SQL Server Management Studio SQL Server Agent

From Form properties make Key preview property true, in case your answer to Lizr question is YES.

Integration services work fine? and check if Agent service running or not.

OOH, I thought it's like 2005, I suggest to search in SQL forums, I'm downloading it right now and I'll see...

Please, write the answer here to help others who face the same problem to find its solution.
Then mark it as solved.

Did you automate it?

Did you install any version of reporting service before 2008? and this error comes when you configure reporting service or when you access it use internet browser?

So, tell me the problem you face and when it raises!

Microsoft SQL Server 2008->Configuration Tools->Reporting Services Configuration

Windows service run an executable with an silly interface which doesn't allow a user to max, mini, or close it.
Executable will do its job for authentication.

If you col1 not primary key you can use trigger to check on the columns in inserted table(read about it in triggers) if col1 data already exists don't insert it in the destination table.

If it's not confidential, you can show us the SP to see if we can optimize it. I think in connection string you can specify the time out value play with it, it may solve the problem on the first machine.

Yes :) you're right

If you have string like that in table "lmlmlaa,lmlmlaa, lmlmlaa, lmlmlaa" and need to return it as table
ID text
1 lmlmlaa
2 lmlmlaa
3 lmlmlaa
4 lmlmlaa
and you may also do some operation on this table, what do you see is to handle this in C# or UDF?

1- Depends on your version but it doesn't make any difference.
2- Yes calling UDF like SP, search how to use it in .net
3- Pre-compiled queries, you can use some logic (splitting strings, some calculations, etc..)
4- In some situations you'd better to write UDF than programming code.
haa, discuss me if you're convinced.

My friend I don't mean it's weak, I just concentrate on syntax similarities:)
And thanks for your great answer :)

NullReferenceException

I think you used an button without new it. and you have to because it's reference type.
[out of topic]
someone professional in Java, the next step should be C# not VB.NET:)

That's the same when you ask how to pass value to another class. fz.SomeMethodTakeStringAsParameter(fileName) haa??

Did you check my reply?

Very common mistake for who works with files, that they don't replace \n with \r\n
your text in textbox.Text = "lmlmalma\n lmlmla" that's wrong to do that File.WriteAllText(saveFileDialog1.FileName, textFile1); rather File.WriteAllText(saveFileDialog1.FileName, textFile1.Replace("\n", "\r\n"));

You're welcome, please mark this thread as solved to be used as reference for such question later :)

API viewer your savior...

Welcome, mark it as solved:)

It works, friend :)
Mark it as solved :)

How about using ComboBox instance then press "dot"....?

You need to get handler to the other form, usually made using windows libraries, read in....

Preferable to make it on your own! you need non-model + no beep, so?! but if you need to get how the user close the form without additional code you must use Model mode DialogResult

loooooooooooooool Salem I won't say and the other 9 :p because I know Binary :D

Whatever :) You should specify username and password, I don't know how to add the flavor of impersonation to your application but I don't know did you reply after reading the namespace or you just don't need and insist on running your application correctly because you're the administrator??

That's too logical to get error, if you didn't, for sure I was about to get another OS rather than Microsoft Windows, anyway, read in System.Security.Principal it helps you...

You can also do it in the event handler of the TabControl.SelectedIndexChanged

Hold current TabPageIndex in integral variable, and once the click done on any TabPage set the TabControl SelectedIndex = the integral value tabControl1.SelectedIndex = integral variable;

I use C#, some use Java.... AS YOU LIKE :) really select any of both, you don't develop business application to come with some features of language over else. try to read any tutorial of both and the one you feel rest with, use it.

Half of the world knows CS == C# or Java!

You should know OOP principles well. then come to the question Java or C#?. C# or Java?, you can spend all your life with people fighting to reach what the best. It's up to you. What you need to work with Microsoft technology (VS, WCF, WF, C#, Windows, SQL Server etc..) or Non-Microsoft technology??

OK. To close the Child window

Me.ActiveMdiChild().Close()

:O tell you what?, Didn't you tell that you did it and need to know how to close the child form?? or you didn't do it at all!!!!!