Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    40

    Unanswered: Cheap Enterprize Manger and Query Analyzer

    Can anyone tell me a cheap way to get this software, (Enterprize Manger and Query Analyzer). I am tyring to upsize to SQL Server with my Webhost and they are not very helpful in how to best do this.

    So I am guessing I need these to connect to my new SQL Database. I know Microsoft has a trial version but isn't there a development version that I can run on my local XP and or 2000 machine and hook up to my webhost SQL server?

    Any help would be moslty appreciated!

    Thanks,

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: Cheap Enterprize Manger and Query Analyzer

    There are free managers and querie analysiers here:

    http://www.webattack.com/freeware/we...fwdbquery.html

    Also take a look at this amazing control:

    http://www.geocities.com/scirocco_ha/DataControl.htm


    Originally posted by JimWa
    Can anyone tell me a cheap way to get this software, (Enterprize Manger and Query Analyzer). I am tyring to upsize to SQL Server with my Webhost and they are not very helpful in how to best do this.

    So I am guessing I need these to connect to my new SQL Database. I know Microsoft has a trial version but isn't there a development version that I can run on my local XP and or 2000 machine and hook up to my webhost SQL server?

    Any help would be moslty appreciated!

    Thanks,

  3. #3
    Join Date
    Jan 2004
    Posts
    31
    See this thread for my opinion of a free manager:

    http://81.130.213.94/myforum/forum_p...sp?TID=84&PN=1


    For query plans you'll need this one but it needs documenting:

    http://81.130.213.94/myforum/forum_p...sp?TID=78&PN=1


    I've listed some more managers on this thread but you'll need to register for the forum to enter it:

    http://81.130.213.94/myforum/forum_t...sp?FID=25&PN=1

    And of course you can use AdoAnywhere www.adoanywhere.com for sql even if you don't need its ADO gui features.


    You can connect to my test servers - see details in forum.

    Mike

  4. #4
    Join Date
    Jan 2004
    Posts
    40

    Angry

    My Webhost is specific as to what to use:

    Enterprisie Manger
    Query Analyzer
    MS Access 2002/XP

    And the upsizing wizard in Access is giving me issues. It goes through the entire process and at the end says,

    "The upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher) Please log into a SQL Server Data source."

    And this is my webhosts response.

    "We are running Microsoft SQL Server 2000. That is 2 generations newer than SQL Server 6.5. You might search Google or the Microsoft website to find out why Access is giving you that error. "

    There support team is so helpful aren't they..

  5. #5
    Join Date
    Jan 2004
    Posts
    31
    You might have to get the trial version of SQL server since it comes with the tools you need. I think it runs for 12 weeks.

    Can't say why Access is giving you the error , I don't use it, and no - your ISP help desk doesn't sound helpful...

    Mike.

  6. #6
    Join Date
    Jan 2004
    Posts
    40
    Thanks Mike...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •