Red Gate forums :: View topic - Visual Studio: "SQL Prompt cannot retrieve objects from ."
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

Visual Studio: "SQL Prompt cannot retrieve objects from ."

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
adam0101



Joined: 18 Jun 2013
Posts: 7

PostPosted: Wed May 28, 2014 5:50 pm    Post subject: Visual Studio: "SQL Prompt cannot retrieve objects from ." Reply with quote

"sql prompt cannot retrieve objects from ."

This is the second time I got burned by this error. For some reason my Target Connection String got cleared in Visual Studio and started causing this error. Luckily, I looked at my previous posts here. For anyone else getting this, the solution can be found here:

http://stackoverflow.com/questions/14484309/how-to-change-the-default-connection-to-a-server-in-visual-studio-2012-sql-proje

If SQL Prompt depends on this setting in Visual Studio to work correctly, shouldn't it prompt for this if it is not set instead of giving an error? Or at the very least, can we get SQL Prompt to give an error message that is more descriptive instead of just passing back what it got from SQL? I had to spend too much time tracking this solution down again.

Thanks.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 249
Location: Red Gate Software

PostPosted: Thu May 29, 2014 11:47 am    Post subject: Reply with quote

Hi Adam,

Thank you for the post - I'll make this a sticky just in case anyone else encounters this issue and we'll look into making the error more descriptive.

Ideally Prompt wouldn't need this connection string at all, but at the moment it needs an actual database to retrieve all the objects from. A better approach would be if it loaded suggestions directly from the sql files in the project. As this would be a pretty large change to implement I've added a UserVoice feature to help us gauge interest against other potential features in Prompt.

Please add your vote here.

Thanks,
Aaron.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group