Blain, Can you reproduce step by step using the Northwind or Pubs databases or is the behaviour specific to the database that you are are working with?
Make sure you list what to do step by step because just following your instructions before, there were a few ambiguities. The other thing is that I'd guess that if you surveyed the majority of participants on this list that they would avoid using the designer for alot of this sort of stuff. ---------------------------------------- - Mitch Denny - [EMAIL PROTECTED] - +61 (414) 610-141 - -----Original Message----- From: The DOTNET list will be retired 7/1/02 [mailto:[EMAIL PROTECTED]] On Behalf Of Blain Timberlake Sent: Tuesday, 11 June 2002 21:08 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Super simple DataAdapter quesiton... Am I not getting a response because: A) This is a bad question and I'm just doing something idiotic B) It's a flakey behaviour no one else has seen C) There is no answer Or D) None of the above ??? =Blain -----Original Message----- From: The DOTNET list will be retired 7/1/02 [mailto:[EMAIL PROTECTED]] On Behalf Of Blain Timberlake Sent: Monday, June 10, 2002 3:57 PM To: [EMAIL PROTECTED] Subject: [DOTNET] Super simple DataAdapter quesiton... I saw a similar question on Usenet from October, but it hadn't been answered... I open a brand new project, and drag over an SQL connection. I drag over a SQLDataAdapter as well. For the Select function of the DataAdapter I point it to a stored procedure 'ListPrinters'. It looks like everything is happy but when I go to preview the data I get: "Can't create a child list for field dbo." Now of course there is no DBO field, if I look at the commandtext object it has: dbo.[ListPrinters] If I log in through QA I can run it without the dbo. Prefix, but if I take out the dbo. Prefix in the command text I get: "Invalid Property Value The Stored procedure 'ListPrinters' could not be found in the database." The user definitely defaults to the right database. The connectionstring points to the right database. He has permission to access it as it works fine through QA. What's going on here? =Blain You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
