.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
!RE: Guided Tour - problem with MxDataGrid
Messages   Related Types
This message was discovered on ASPFriends.com 'aspngwebmatrix' list.


Arthur Fuller
It grows odder... I duplicated the steps with this exception: I created a
new connection, to a SQL 2000 database residing on a database server. I
supplied my user id and password, and it connected. I dragged a table onto
the page and presto, saved it and ran it, and this one works! But the
localhost one does not!

Also, in the working one, I see a list of sprocs but it seems that the IDE
won't let me drop them onto a page in the same way as a table. In addition,
what I do not see here is a node for Views.

Arthur

-----Original Message-----
From: Arthur Fuller [mailto:Click here to reveal e-mail address]
Sent: Wednesday, June 19, 2002 9:57 AM
To: aspngwebmatrix
Subject: [aspngwebmatrix] Guided Tour - problem with MxDataGrid

I'm following the guided tour step by step. I have the orders and
orderdetails open in the workspace, and can double-click them to edit them.
I dragged the orders table onto the page and saved it. When I run it, I get
a Login failed for user Tor-21\ASPNet.

No doubt because of the connection string, which is:

server='localhost'; trusted_connection=true; Database='Orders'

By why would the page fail when the Matrix connection is obviously
established and working? I'll keep mucking about and see if I can sort it
out. I'll also keep track of what I'm doing, so that if I fix it I can post
the steps. (This may happen to others following along, so maybe the tour
needs a bit about this problem.)

Arthur

| [aspngwebmatrix] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/aspngwebmatrix.asp = JOIN/QUIT
Reply to this message...
 
    
(Volt)
Have you tried adding your SQL server user name and password to the
connection string on the SqlDataSourceControl object? I believe we don't
persist them for security reasons. Also, on the remote server you tried
it with, can you log in using Windows Authentication instead of SQL
Authentication?

    -- Ryan Milligan

-----Original Message-----
From: Arthur Fuller [mailto:Click here to reveal e-mail address]=20
Sent: Wednesday, June 19, 2002 11:02 AM
To: aspngwebmatrix
Subject: [aspngwebmatrix] !RE: Guided Tour - problem with MxDataGrid

It grows odder... I duplicated the steps with this exception: I created
a
new connection, to a SQL 2000 database residing on a database server. I
supplied my user id and password, and it connected. I dragged a table
onto
the page and presto, saved it and ran it, and this one works! But the
localhost one does not!

Also, in the working one, I see a list of sprocs but it seems that the
IDE
won't let me drop them onto a page in the same way as a table. In
addition,
what I do not see here is a node for Views.

Arthur

-----Original Message-----
From: Arthur Fuller [mailto:Click here to reveal e-mail address]
Sent: Wednesday, June 19, 2002 9:57 AM
To: aspngwebmatrix
Subject: [aspngwebmatrix] Guided Tour - problem with MxDataGrid

I'm following the guided tour step by step. I have the orders and
orderdetails open in the workspace, and can double-click them to edit
them.
I dragged the orders table onto the page and saved it. When I run it, I
get
a Login failed for user Tor-21\ASPNet.

No doubt because of the connection string, which is:

server=3D'localhost'; trusted_connection=3Dtrue; Database=3D'Orders'

By why would the page fail when the Matrix connection is obviously
established and working? I'll keep mucking about and see if I can sort
it
out. I'll also keep track of what I'm doing, so that if I fix it I can
post
the steps. (This may happen to others following along, so maybe the tour
needs a bit about this problem.)

Arthur

| [aspngwebmatrix] member Click here to reveal e-mail address =3D YOUR ID
| http://www.aspfriends.com/aspfriends/aspngwebmatrix.asp =3D JOIN/QUIT

| [aspngwebmatrix] member Click here to reveal e-mail address =3D YOUR ID
| http://www.aspfriends.com/aspfriends/aspngwebmatrix.asp =3D JOIN/QUIT
Reply to this message...
 
    
Arthur Fuller
To get to the remote server running SQL 2000, I do not not have integrated
security. When I created the connection, I specified my user name and
password. That worked fine.

I couldn't remember setting a password on the local copy (since I almost
never use it). To make sure, I created an Access ADP project and specified
integrated security, and it worked fine. Now I'm _really_ confused.

Any suggestions?
TIA,
Arthur

-----Original Message-----
From: (Volt) [mailto:Click here to reveal e-mail address]
Sent: Wednesday, June 19, 2002 4:10 PM
To: aspngwebmatrix
Subject: [aspngwebmatrix] RE: !RE: Guided Tour - problem with MxDataGrid

Have you tried adding your SQL server user name and password to the
connection string on the SqlDataSourceControl object? I believe we don't
persist them for security reasons. Also, on the remote server you tried
it with, can you log in using Windows Authentication instead of SQL
Authentication?

    -- Ryan Milligan

-----Original Message-----
From: Arthur Fuller [mailto:Click here to reveal e-mail address]
Sent: Wednesday, June 19, 2002 11:02 AM
To: aspngwebmatrix
Subject: [aspngwebmatrix] !RE: Guided Tour - problem with MxDataGrid

It grows odder... I duplicated the steps with this exception: I created
a
new connection, to a SQL 2000 database residing on a database server. I
supplied my user id and password, and it connected. I dragged a table
onto
the page and presto, saved it and ran it, and this one works! But the
localhost one does not!

Also, in the working one, I see a list of sprocs but it seems that the
IDE
won't let me drop them onto a page in the same way as a table. In
addition,
what I do not see here is a node for Views.

Arthur

-----Original Message-----
From: Arthur Fuller [mailto:Click here to reveal e-mail address]
Sent: Wednesday, June 19, 2002 9:57 AM
To: aspngwebmatrix
Subject: [aspngwebmatrix] Guided Tour - problem with MxDataGrid

I'm following the guided tour step by step. I have the orders and
orderdetails open in the workspace, and can double-click them to edit
them.
I dragged the orders table onto the page and saved it. When I run it, I
get
a Login failed for user Tor-21\ASPNet.

No doubt because of the connection string, which is:

server='localhost'; trusted_connection=true; Database='Orders'

By why would the page fail when the Matrix connection is obviously
established and working? I'll keep mucking about and see if I can sort
it
out. I'll also keep track of what I'm doing, so that if I fix it I can
post
the steps. (This may happen to others following along, so maybe the tour
needs a bit about this problem.)

Arthur

| [aspngwebmatrix] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/aspngwebmatrix.asp = JOIN/QUIT

| [aspngwebmatrix] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/aspngwebmatrix.asp = JOIN/QUIT

| [aspngwebmatrix] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/aspngwebmatrix.asp = JOIN/QUIT
Reply to this message...
 
 




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification