Connections to Ignore Problem

• 
  Hi,
  
  Sorry about the problems you're having. Could you try removing/renaming your options file
  
  C:\Documents and Settings\<user>\Local Settings\Application Data\Red Gate\SQL Prompt 3\EngineOptions.xml
  
  We're thinking that maybe it got corrupted somehow (did you install the previous beta?)
  
  Regards,
  
  Tilman

  Tilman December 12, 2006 12:27

  - 0 +
• 
  Sorry, tried that with exactly the same results.
  
  Having renamed the file I restarted SQL Prompt saw a new file with the same name get created, tried the ignore function, but with no success.
  
  It just looks like the file is not being saved correctly.
  
  Can I edit it directly?
  
  Alasdair.

  akmacdonald December 13, 2006 07:40

  - 0 +
• 
  Yes, you can edit the file by hand.
  
  As another experiment, could you remove the whole folder and then try again? This seemed to fix another problem with the snippets file.
  
  Tilman
  
  PS: did you see the develpment re: SQL Server 7 in this thread?
  
  http://www.red-gate.com/messageboard/vi ... php?t=3821

  Tilman December 13, 2006 07:46

  - 0 +
• 
  No joy there either I'm afraid. Folder re-created, files re-created but no storage of the ignore information.
  
  Yes, I did notice the activity on suport for SQL Server 7. I have already been in touch with Bart and am pleased to report a very speedy response from him.
  
  Cheers,
  Alasdair.

  akmacdonald December 13, 2006 10:33

  - 0 +
• 
  I'm getting same problem.
  I had deleted that file, and didn't worked too.
  
  Ésio

  EsioN December 14, 2006 05:09

  - 0 +
• 
  I do not know if this might cause this issue but my copy of SQL Prompt is not installed in the default directory.
  
  Also, how do I edit the file by hand?
  
  Alasdair.

  akmacdonald December 15, 2006 09:33

  - 0 +
• 
  Hi,
  

  I do not know if this might cause this issue but my copy of SQL Prompt is not installed in the default directory.

  I tried installing in a non-default directory, but no luck. Let me know if you find anything else that could affect it.
  

  Also, how do I edit the file by hand?

  It's a xml file, so just open it in a text editor and copy the schema from the existing snippets.
  
  Regards,
  
  Tilman

  Tilman December 19, 2006 06:43

  - 0 +
• 
  Problem is I don't have any snippets to compare it with. I'm trying to stop it trying to connect to some servers, but don't know the XML tags required.
  
  Alasdair.

  akmacdonald December 19, 2006 10:55

  - 0 +
• 
  Hi Alasdair,
  
  Here is what it looks like.
  
  <MetaDataCache>
  ...
  <BlacklistedDatabases>
  <BlacklistedDatabaseSet>
  <Server>server</Server>
  <IsCaseSensitive>False</IsCaseSensitive>
  <IsWholeServerBlacklisted>False</IsWholeServerBlacklisted>
  <Count>1</Count>
  <Database>db</Database>
  </BlacklistedDatabaseSet>
  <BlacklistedDatabaseSet>
  <Server>whole server</Server>
  <IsCaseSensitive>False</IsCaseSensitive>
  <IsWholeServerBlacklisted>True</IsWholeServerBlacklisted>
  <Count>0</Count>
  </BlacklistedDatabaseSet>
  </BlacklistedDatabases>
  ...
  </MetaDataCache>
  
  There are 2 entries here, one blacklisting a whole server, the other blacklisting only a specific database
  
  This needs to be added to the SQL Prompt Meta Data.cache file in the same directory as the snippets file.
  
  Hope that helps.
  
  Tilman

  Tilman December 20, 2006 06:28

  - 0 +

Add comment

Please sign in to leave a comment.