OraFAQ Forum: Client Tools » Issue in connecting from SQL Developer 3.2

Home » Other » Client Tools » Issue in connecting from SQL Developer 3.2 (SQL Server 2008 R2 and SQL Developer 3.2.20.09)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue in connecting from SQL Developer 3.2 [message #617479]

Mon, 30 June 2014 08:00

chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn

Junior Member

Hello

I am trying to connect to sql server from sql developer

I have donwloaded and using "jdtds-driver" and thus I got the 'sql server' tab on the sql developer

However I am unable to get the 'Retrieve Databases' tab when i try to set new connection

In that case I am able to connect to the local database only

What could be the reason that I am not seeing the 'Retrieve Databases' tab on the 'New Connection' settings tab?

I am using sql developer 3.2.20.09 on windows 64 bit

Note that I downloaded sql developer 'without JRE' option and then downloaded & installed JDK 1.7.1 to link java.exe with it

Thanks and Regards
Chetan

Report message to a moderator

Re: Issue in connecting from SQL Developer 3.2 [message #617480 is a reply to message #617479]

Mon, 30 June 2014 08:33

chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn

Junior Member

Kindly Note that I have tried with jtds-1.3.1 as well as jtds-1.2 and jtds-1.2.6 jar files

But still unable to see the 'Retrieve Database' button

Thanks and Regards
Chetan

Report message to a moderator

Re: Issue in connecting from SQL Developer 3.2 [message #617481 is a reply to message #617480]

Mon, 30 June 2014 09:25

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

I don't know about sql server and the client's requirement to connect to it. If it was Oracle, then this is appropriate forum.

Report message to a moderator

Re: Issue in connecting from SQL Developer 3.2 [message #617503 is a reply to message #617481]

Mon, 30 June 2014 16:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is there any special reason for you not to install the latest SQL Developer (4.0.2 currently)? Here's a tutorial which shows how to connect SQL Developer to a MS SQL Server database, perhaps it'll help.

[Updated on: Mon, 30 June 2014 16:53]

Report message to a moderator

Re: Issue in connecting from SQL Developer 3.2 [message #617529 is a reply to message #617503]

Tue, 01 July 2014 05:18

chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn

Junior Member

Hello Littlefoot

Thanks for the link

It was the very first link I referred for achieving the connectivity with no success!

Though it correctly depicts how-to-connect, it does not help me in sorting the issue I am facing currently

Of course I will try to install sql developer 4.0.2 as you have suggested all the links I am referring for 'connecting sql server using sql developer' points to sql developer 3.2

Thanks and Regards
Chetan

Report message to a moderator

Re: Issue in connecting from SQL Developer 3.2 [message #617626 is a reply to message #617529]

Wed, 02 July 2014 06:00

chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn

Junior Member

Hello Littlefoot

Thank you so much

The issue is resolved after installing sql developer 4.0.2

BTW the 'Retrieve database' button is not really necessary as after logging to sql server we can always right click databases displayed right click the correct one to select 'Default database'

Kind Regards
Chetan

[Updated on: Wed, 02 July 2014 06:01]

Report message to a moderator

Re: Issue in connecting from SQL Developer 3.2 [message #617653 is a reply to message #617626]

Wed, 02 July 2014 09:31

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Thank you for letting us know.

Report message to a moderator

Previous Topic:	query for select and update
Next Topic:	sqlplus report headers and titles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 23:26:57 CST 2025