[modha]

Hi All

Can I create and edit stored procedures in DB Explorer.
When I right click on Procedure in DB Explorer, it just has 2 options ( Refresh, Copy Object Name).

I am using SQL Server 2005.

Thanks
Modha/-

[Haris Peco]

Modha,

MyEclipse support edit, create and running stored procedures for sql server, but you need PRO license

Best regards
Peco

[modha]

I have Pro License.

[Haris Peco]

Modha,

You have disabled sybase/sql server capabilities, probably

Check Windows-Preferences-General-Capabilities – check that ‘MyEclipse Proffesional Tools’ is enabled’

click Advanced and check that Extended SQL Server/Sybase database support

Can you send your driver details (vendor and version), please

Thanks

[modha]

Download SQLServer jdbc driver from http://msdn.microsoft.com/data/ref/jdbc/ (Microsoft SQL Server 2005 JDBC Driver). I do not see any option for Extended SQL Server/Sybase database support in Advanced.
Window->Preferences->General -> Capabilities
I see Development, My Eclipse Professional Tools, My Eclipse Standard Tools and Team checked. When I click on Advanced.. Button I see the same options as above.
Thanks

[Haris Peco]

your driver is fine

expand My Eclipse Professional Tools and enable ‘Extended SQL Server/Sybase database support ‘ or enable all features

Best
Peco

[modha]

‘Extended SQL Server/Sybase database support ‘ is enabled — no change

[Brian Fernandes]

Modha,

1) What version of ME are you using? We recommend 5.0.1GA
2) How did you upgrade to this version – did you restart eclipse with the -clean flag?
3) Try the following steps: Turn off the extended SQL Server / Sybase support and Apply. Then turn the support back on and restart your workspace.
4) If the above fails, can you see if it works in another workspace for you just as a test? That will help us to run down the issue.

Best,
Brian.

[modha]

Version: 5.0.1 GA
Build id: 20060810-5.0.1-GA

option 3 works. Now I can see.

Thanks

[Author]

Posts