facebook

SQLserver db with multiples schemas

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #235807 Reply

    atennent
    Member

    I am connecting to a sqlserver db that has multiple schemas as user5,
    once connected and I select a table and select “generate sql”.

    The sql is generated however the user is incorrect.
    -select a, b, c from “qslh1”.“user1″.”ERROR”

    -if I manually change the sql from user1 to user5 data is returned.
    – if I filter the schemas in the connection details to only show “user1”, I can connect but no tables are shown. No errors are loged in

    \workspace\.metadata log file.

    Any ideas?

    #235826 Reply

    Riyad Kalla
    Member

    Can you please post all the information we request in the [URL=http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-393.html]Posting Guidelines[/URL] thread at the top of this forum? That will give us some context so that we can determine if this is an installation issue, a configuration problem, or a bug. Thanks.

    #235840 Reply

    atennent
    Member

    What operating system and version are you running? W2K SP5
    What Eclipse version and build id are you using? (Help > About Eclipse Platform) Version: 3.1.0
    Build id: I20050627-1435
    – Was Eclipse freshly installed for MyEclipse? YES
    – Are any other external plugins installed? YES
    – How many plugins in the <eclipse>/plugins directory are like org.eclipse.pde.* 12
    -What MyEclipse version are you using? (Help > About Eclipse Platform > Features)
    Version: 3.9.310
    Build id: 20050808-4.0-Milestone-3
    -What JDK version are you using to run Eclipse? (java -version) 1.4.2_07
    Are there any exceptions in the Eclipse log file? (<workspace>/.metadata/.log) No

    -Connecting to SQLServer 2000SP3 DB

    #236938 Reply

    atennent
    Member

    Any updates? How can I help you resolve this?

    #236944 Reply

    Riyad Kalla
    Member

    Sorry for the delay, this seems to be a bug that we are still investigating. I don’t have a workaround for you at this time.

    #240032 Reply

    atennent
    Member

    Any updates on the above?

    #240038 Reply

    Riyad Kalla
    Member

    No news yet, this is the first time has been reported so verifying/targetting it for a release is a low priority for us right now in light of many other high priority items. Sorry for the delay I know it can be frustrating, unfortunately developing software is a constant balancing act of priorities and resources based on user demands.

    #241096 Reply

    atennent
    Member

    Ok I understand. We were looking to use MyEclipse as a replacement for TOAD within our QA/DEV organization at Yantra. This was the tool of preference however this is a P1 for us. We need to support DB2, Oracle and SQLServer.

Viewing 8 posts - 1 through 8 (of 8 total)
Reply To: SQLserver db with multiples schemas

You must be logged in to post in the forum log in