#21 Databased not displayed in object browsr

closed-fixed
None
5
2002-07-31
2002-02-20
Anonymous
No

I'm using the i-net opta2000 driver to access
Microsoft SQL Server. Under the 'Database' node in the
object tree, I see all the users for the database.

What I do not see, are any of the databases. They do
show up properly with SQL Query Analyzer (a sql client
that ships with sql server).

Discussion

  • Colin Bell

    Colin Bell - 2002-02-22

    Logged In: YES
    user_id=233132

    SQuirreL works with both the Microsoft and Weblogic JDBC
    drivers so it should't be too hard to get it working with
    the i-net driver.

    If you try to expand one of the user nodes in the object
    tree, what do you see? Are then any nodes below it and if
    so can they be expanded?

    Could you paste the Database MetaData into this bug report.
    To get it just click on the root or top level node (should
    be called database) and then click on the Metadata tab in
    the tabbed folder. Right click in the metadata and
    take "Select All" and then "Copy" from the popup menu and
    paste it in here.

    Thanks
    Col

     
  • Colin Bell

    Colin Bell - 2002-02-22
    • assigned_to: nobody --> colbell
     
  • Colin Bell

    Colin Bell - 2002-07-31

    Logged In: YES
    user_id=233132

    The next version of SQuirreL (1.1beta6) has a rewritten
    object tree. For MSSQL this now shows the catalogs
    (databases in MSSQL parlance) and for each catalog the
    schemas (owner in MSSQL). This should address your problem.

    Col

     
  • Colin Bell

    Colin Bell - 2002-07-31
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks