GridView - SQLDatasource trouble

[Gabriel]

Hello,

I have a connection (server explorer), connected to "AdventureWorks"
database, the connection is ok.

I drop a table a page (design).

I want to configure datasource by click on "Configuire Data Source" in the
"Gridview Tasks"

Select the connection string : OK ... next
Select a table and all the columns OK (the select statement created is
SELECT * FROM [Address]) ... Next

I wan test the query by clicking "Test Query" but i receive this error :
There was an error executing query. Please check syntax of the command and
if present, the types and values of the parameters and ensure they are
connected. Invalid object name 'address'

Any idea ? The connection works, the syntax look ok.

I'm using SQL Server Express SP2 + VS 2005

Regards,

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Dean Cleaver]

[Steve Johnson]

On 3/12/07, Dean Cleaver <***@xceptionsoftware.com> wrote:
>
> I'm having a problem with client certificates - I can't get it to work.
> Below is my code - the URL is valid, as is the certificate path. I've
> viewed the certificate properties and it appears valid - yet I just get
> "403 - Forbidden" when I try to connect. My provider made client
> certificates mandatory last night, so I am very sure that this is the
> problem.
>


Funny you should ask. Troubleshooting this issue is how I've spent the last
couple of weeks.

Is the cert issued by an issuer that is trusted by the server?

Is the CRL of the certificate visible to the server?

Is the CRL valid and up-to-date?


--
Steve Johnson

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Dean Cleaver]

[Steve Johnson]

On 3/12/07, Dean Cleaver <***@xceptionsoftware.com> wrote:
>
> The cert is issued by Verisign, but I didn't create it - our suppliers
> did.
>
> As for the next 2 questions, I hae no real idea of what you're meaning.



If it's a verisign cert, then that should take care of #1 and #3. By #2,
what I mean to ask is if the CRL distribution point is reachable from the
server. You can see this by opening the certificate and clicking the
Details tab. Then scroll down to CRL Distribution Points.

When you say, regarding the cert, that "others can use it ok", do you mean
that they are able to use it as a client certificate and successfully
connect to the same URL that you're having trouble with?

--
Steve Johnson

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Steve Johnson]

On 3/12/07, Steve Johnson <***@pobox.com> wrote:
>
> If it's a verisign cert, then that should take care of #1 and #3. By #2,
> what I mean to ask is if the CRL distribution point is reachable from the
> server. You can see this by opening the certificate and clicking the
> Details tab. Then scroll down to CRL Distribution Points.
>
> When you say, regarding the cert, that "others can use it ok", do you mean
> that they are able to use it as a client certificate and successfully
> connect to the same URL that you're having trouble with?




Also (dumb question)...the certificate file you're using *does* contain the
private key, correct?

--
Steve Johnson

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Scott Dexter]

Are you accessing the URL via http://
dumb question, but bear with me:

Are you accessing the URL via http:// or https:// ?


----- Original Message ----
From: Dean Cleaver <***@XCEPTIONSOFTWARE.COM>
> "403 - Forbidden" when I try to connect. My provider made client
> certificates mandatory last night, so I am very sure that this is the
> problem.
>





===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Dean Cleaver]

[Patrick Newberry]

[Shanmugam, Kris]

[Paul van Brenk]

[Efran Cobisi]

>
> The bad news is that the page is sort of long and when I do the call
> back attached to the radio buttons the page reloads and I am back to the
> top of the page and you have to scroll back down the page to get to
> where you left off.
>
A small footnote... You could set the MaintainScrollPositionOnPostback
attribute to "true" inside your <%@ Page ... %> directive (or web.config
to have it applied to every of the pages of your project) and have this
hassle removed.

HTH,
--

Efran Cobisi
http://www.cobisi.com

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Mark Kucera]

[Efran Cobisi]

You are wrong, Mark.
MaintainScrollPositionOnPostback does work with the vast majority of web
browsers which support javascript.

Maybe you are confusing it with the SmartNavigation feature, now obsolete...
HTH,

Efran Cobisi
http://www.cobisi.com

Mark Kucera wrote:
> If you are using IE...
>
> Mark Kucera
> SQL Sentry Support
> ***@SQLSentry.net
>
> -----Original Message-----
> From: Discussion of building .NET applications targeted for the Web
> [mailto:DOTNET-***@DISCUSS.DEVELOP.COM] On Behalf Of Efran Cobisi
> Sent: Wednesday, March 14, 2007 04:46 AM
> To: DOTNET-***@DISCUSS.DEVELOP.COM
> Subject: Re: [DOTNET-WEB] radioButton and pannels
>
>
>> The bad news is that the page is sort of long and when I do the call
>> back attached to the radio buttons the page reloads and I am back to
>>
> the
>
>> top of the page and you have to scroll back down the page to get to
>> where you left off.
>>
>>
> A small footnote... You could set the MaintainScrollPositionOnPostback
> attribute to "true" inside your <%@ Page ... %> directive (or web.config
> to have it applied to every of the pages of your project) and have this
> hassle removed.
>
> HTH,
> --
>
> Efran Cobisi
> http://www.cobisi.com
>
> ===================================
> This list is hosted by DevelopMentor(r) http://www.develop.com
>
> View archives and manage your subscription(s) at
> http://discuss.develop.com
>
> ===================================
> This list is hosted by DevelopMentor® http://www.develop.com
>
> View archives and manage your subscription(s) at http://discuss.develop.com
>

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Mark Aurit]

The March 07 MSDN mag has the article *"Scalable Apps with Asynchronous
Programming in ASP.NET" *by Jeff Prosise at
http://msdn.microsoft.com/msdnmag/issues/07/03/WickedCode/
He starts off with the "The IIS sky is falling" bit, and discusses how
to *really* scale by doing this.
In my environment, even my apps that have to scale are doing fine with
IIS6/.NET thread handling. But in the future I might need to do some
much larger scaling, and like everyone else I want a robust framework;
Im a little concerned my apps tend to make pretty heavy use of SQL Server.
Is anyone doing this (asyncronous pages)? And if so, what was the
good/bad/ugly?

Thanks much, Mark

**

--
====================
Mark Aurit
***@gmail.com

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com