How can we help you today? How can we help you today?

Connections to Ignore Problem

I am having trouble getting SQL Prompt to remember the connections to ignore. Having found that it won't support Sql Server 7 :( (yes - we still have servers running it) I decided to tell it to ignore those same servers.

To attempt to replicate the problem try this

1. Have QA running and SQL Prompt enabled,
2. Open the SQL Prompt options dialog from the Options... menu item in the SQL Prompt menu,
3. Add a server to the list of those to ignore on the Connections tab,
4. Exit QA,
5. Restart QA.
6. Open the SQL Prompt options dialog from the Options... menu item in the SQL Prompt menu,
7. Go to the Connections tab. You will notice that your server to ignore has disappeared.

If you open a connection to the selected server between steps 3 and 4 you will see that SQL Prompt does not attempt to get any schemas. Exectly what I wanted. If you do it after step 7 the annoying error message comes back.

I am running Windows 2000 professional service pack 4, my database servers are all remote, and my QA version is 8.00.760.

Alasdair.
akmacdonald
0

Comments

9 comments

Sort by
  • Tilman
    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
    0
  • akmacdonald
    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
    0
  • Tilman
    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
    0
  • akmacdonald
    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
    0
  • EsioN
    I'm getting same problem.
    I had deleted that file, and didn't worked too.

    Ésio
    EsioN
    0
  • akmacdonald
    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
    0
  • Tilman
    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
    0
  • akmacdonald
    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
    0
  • Tilman
    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
    0

Add comment

Please sign in to leave a comment.