Re: 'integrated security' error - ASP.NET Discussion Boards

First Prev Next

Re: Gridview Number Format

Herman<T>.Instance20-Apr-09 3:18

Herman<T>.Instance

20-Apr-09 3:18

DataFormatString="{0:#,#}" is enough to make the trick hapen.

In Word you can only store 2 bytes. That is why I use Writer.

update panel problem

Abhishek Rana17-Apr-09 1:24

Abhishek Rana

17-Apr-09 1:24

I am developing a web application in which i have used a dropdown list on which update panel is applied ,and on list select event I'll set some cs file variable values that are not visible on my javascript function all though the values of cs variable getchanged is there any way to solve these problem ?

thanks

Re: update panel problem

Yusuf17-Apr-09 2:42

Yusuf

17-Apr-09 2:42

either you have no clue of what you doing or you did not explain your problem.

Abhishek Rana wrote:
I am developing a web application in which i have used a dropdown list on which update panel is applied

So far so good

Abhishek Rana wrote:
and on list select event I'll set some cs file variable values that are not visible on my javascript function

If all you want to do is handle the select changed event in javascript, why do you need updatepanel? Update panel is used/needed only if you have to process the event on the server, so you don't refresh the whole page.

Abhishek Rana wrote:
on list select event I'll set some cs file variable values that are not visible on my javascript function all though the values of cs variable getchanged

No there is no way you can access the variables from javascript.

Abhishek Rana wrote:
is there any way to solve these problem ?

Yes, Since you have update panel, forget about javascript and handle what ever you want on the server. Things will work for you magically.

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Re: update panel problem

ToddHileHoffer17-Apr-09 3:09

ToddHileHoffer

17-Apr-09 3:09

Yusuf wrote:
Abhishek Rana wrote:
is there any way to solve these problem ?

Yes, Since you have update panel, forget about javascript and handle what ever you want on the server. Things will work for you magically.

Funny.

But I agree with Yusuf. Unless you are writing a website that will be very high volume, it is always easist and cleanest to just write your code in C# and use the ajax panel. It is one thing if you are proficient with asp.net, html, javascirpt and it easy for you. But if you are not an expert, don't even bother trying to use a bunch of javascript. You will probably just shoot yourself in the foot.

I didn't get any requirements for the signature

'integrated security' error

sasan5617-Apr-09 1:17

sasan56

17-Apr-09 1:17

Hi Dear
I registered as ASPSpider.com member. I uploaded my Database and ASP.NET 2005 files in my space, but when i connected to the address http://aspspider.info/sasannaderi/ (you can see it online) this error occured :
Keyword not supported: 'integrated security'.

My connectionStrings is this :

<connectionStrings>
<add name=sasannaderi_maskan Data
Source=.\SQLExpress;Persist Security Info=True;Integrated
Security=SSPI;Initial Catalog=sasannaderi_maskan
providerName=System.Data.SqlClient/>
</connectionStrings>

Can anyone help me to solve the problem?

Re: 'integrated security' error

Ashfield17-Apr-09 2:03

Ashfield

17-Apr-09 2:03

Integrated Security=SSPI means using Windows Authentication. Does that give you a clue?

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: 'integrated security' error

sasan5617-Apr-09 2:32

sasan56

17-Apr-09 2:32

I set it to True, but it don't work!
the project on my local system work as well.

Re: 'integrated security' error

Arindam Tewary17-Apr-09 2:37

Arindam Tewary

17-Apr-09 2:37

Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.

Thanks,
Arindam D Tewary

Re: 'integrated security' error

sasan5617-Apr-09 2:47

sasan56

17-Apr-09 2:47

In ASPSpider.com (Free Learning & Training Hosting)you can add only SQL Express database and in the guide, tell you that chang your connectionstring to this :

"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=YourUserId_DatabaseName"

i change my connectionstring to above format, but it don't work yet!

Re: 'integrated security' error

Arindam Tewary17-Apr-09 3:04

Arindam Tewary

17-Apr-09 3:04

I am sure that they have advised that considering that indevidual would be working ( rather practising ) in their local system when you have SQL Express and application(which is accessed) is in the same COMPUTER.

But if you have your code(application) which you try to see using HTTP , then you have to go for SQL Server authentication unless you have the ACCESS TO DATABASE AND YOU CAN CONFIGURE THE SAME DATABASE TO ALLOW WINDOWS AUTHETICATION FOR DEPLOYED APPLICATION.

BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.

Thanks,
Arindam D Tewary

Re: 'integrated security' error

Abhijit Jana17-Apr-09 3:24

Abhijit Jana

17-Apr-09 3:24

Arindam Tewary wrote:
BUT IN MOST CASES, database never allows WINDOWS AUTHENTCATION for deployed application, i.e application which are accessed using HTTP.

Arindam, I don't understand why it will not work. If you have the access right to that database then what would be the problem ?

cheers,
Abhijit
CodeProject MVP

Re: 'integrated security' error

Arindam Tewary17-Apr-09 3:45

Arindam Tewary

17-Apr-09 3:45

Abhijit,

I just told that IN MOST CASES, but NOT for ALL CASES, and that I have seen from my experience. But surley I will try to find out some more of windows authentication in deployed server and that will help me getting much fair idea as well.

Windows Authentication is also possible. Why not? Big Grin | :-D

Thanks,
Arindam D Tewary

Re: 'integrated security' error

Colin Angus Mackay17-Apr-09 5:24

Colin Angus Mackay

17-Apr-09 5:24

Arindam Tewary wrote:
IN MOST CASES, but NOT for ALL CASES

Stop shouting. It is rude.

*Developer Day Scotland - Free community conference Delegate Registration Open

Re: 'integrated security' error

Colin Angus Mackay17-Apr-09 3:00

Colin Angus Mackay

17-Apr-09 3:00

Arindam Tewary wrote:
Windows authetication works well in local environment. But not in deployed environment. Thats whay you are getting this problem. You have to use Sql Server authentication with proper userid and password.

That is utter tripe! That statement tells me that you have little idea of how it works rather than it being a deficiency on the part of SQL Server.

*Developer Day Scotland - Free community conference Delegate Registration Open

Re: 'integrated security' error

Abhijit Jana17-Apr-09 3:03

Abhijit Jana

17-Apr-09 3:03

Arindam Tewary wrote:
Windows authetication works well in local environment. But not in deployed environment.

Why ?

cheers,
Abhijit
CodeProject MVP

Re: 'integrated security' error

Colin Angus Mackay17-Apr-09 3:06

Colin Angus Mackay

17-Apr-09 3:06

sasan56 wrote:
the project on my local system work as well.

This is because in your local environment you were using a different windows account to the one being used in the hosted environment.

When an ASP.NET application is run inside IIS it will use the ASPNET user (typically) and that user is the one used to connect to the database.

In your local environment you probably used Visual Studio's built in web server which would use your own personal credentials to authenticate against the database.

You have to modify the database to permit logon from the user that the ASP.NET application is connecting as.

*Developer Day Scotland - Free community conference Delegate Registration Open

Re: 'integrated security' error

Ashfield17-Apr-09 9:04

Ashfield

17-Apr-09 9:04

Of course it didn't. You have to be in a trusted domain for it to work, thats why its called WINDOWS AUTHENTICATION

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: 'integrated security' error

Dev S17-Apr-09 4:01

Dev S

17-Apr-09 4:01

write conn. string like this :
<pre> <add name="sasannaderi_maskan" connectionString="Data Source=.\SQLExpress;Initial Catalog=sasannaderi_maskan"
providerName="System.Data.SqlClient" />

may be this work for you.
But when u upload it on server a proper data source is required. As "." is ok for local but i dont think for server.

how to display date in gridview header

rahul.net1117-Apr-09 0:15

rahul.net11

17-Apr-09 0:15

Hello All,
I want to display dates in gridview header for eg:
If the week start on 12 (Sunday) then i want to display all the week dates in its header as follows.

S(12) M(13) T(14) W(15) T(16) F(17) S18

how can i do this?

Thanks
Rahul

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

Re: how to display date in gridview header

Ashfield17-Apr-09 2:04

Ashfield

17-Apr-09 2:04

I can't see what your problem is, if you have a start date to use then just add 1 to it to get the next date - simple with the datetime class.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: how to display date in gridview header

wasifahmad17-Apr-09 3:36

wasifahmad

17-Apr-09 3:36

If you have a data table and you are binding your grid with datatable then gridview header caption will be made by datatable.Columns(0).ColumnName property. Whatever you will assign in ColumnName property of column will become grid view header caption.

Let me know this solves your issue or not?

Regards,
Wasif Ahmad

difference between DataReader and DataAdapter??

Pradeep Shet16-Apr-09 23:28

Pradeep Shet

16-Apr-09 23:28

what is the major difference between DataReader and DataAdapter??

Re: difference between DataReader and DataAdapter??

Abhijit Jana16-Apr-09 23:33

Abhijit Jana

16-Apr-09 23:33