OraFAQ Forum: Client Tools » Sql Developer connection with SqL server URGENT

Home » Other » Client Tools » Sql Developer connection with SqL server URGENT (2005, xp)

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

Sql Developer connection with SqL server URGENT [message #397121]

Thu, 09 April 2009 02:34

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

hi experts

I am tring to conect SQL DEVELOPER with SQL server i follow all the instruction given by user manual and download , install the JTDC-JDBC driver also. Also i add
Select Tools -> Preferences -> Database -> Third Party JDBC Drivers. add specific JAR file. to make connection for third-party database
but DOesnt work all. While when i am making odbc conection with sql server it works fine
what i am doing mistake i cant figure it out. Please help me out of this problem ..

see the image below

/forum/fa/6007/0/

thanks in advace and regards

Anwer

Attachment: 1.JPG
(Size: 123.71KB, Downloaded 2407 times)

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397123 is a reply to message #397121]

Thu, 09 April 2009 02:43

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

"10.10.0.75\famsrv" is not a hostname, like it says in the error message.

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397129 is a reply to message #397123]

Thu, 09 April 2009 02:58

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

thanks for reply
but you can see the imaage below how can i connect with ODBC connection. Its from same string which is 10.10.0.75\famsvr

/forum/fa/6008/0/

thanks and regards

Attachment: 2.JPG
(Size: 70.67KB, Downloaded 2282 times)

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397140 is a reply to message #397129]

Thu, 09 April 2009 03:33

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

An ODBC "Server" is a completely different thing than a SQLServer "Hostname".

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397158 is a reply to message #397140]

Thu, 09 April 2009 04:24

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

what to do in next, i cant able to connect sql developer with this string, any idea ??

regards

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397160 is a reply to message #397158]

Thu, 09 April 2009 04:36

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

How about putting the real hostname in the hostname field and then clicking on "retrieve database"?

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397165 is a reply to message #397160]

Thu, 09 April 2009 05:03

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

nothing happins
faliure unknown host name
see the image below
/forum/fa/6009/0/

Attachment: 3.JPG
(Size: 118.84KB, Downloaded 2239 times)

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397167 is a reply to message #397165]

Thu, 09 April 2009 05:06

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Do you know what a host is? "10.10.0.75" looks like a host, "famsrv" doesn't seem to be.

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397172 is a reply to message #397167]

Thu, 09 April 2009 05:23

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

10.10.0.75 is a sql server ip
fams its host name or machine name
famsvr is a database server name

Next what ? any idea

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397176 is a reply to message #397172]

Thu, 09 April 2009 05:31

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Basic network troubleshooting.

What does a

ping fams

tell you

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397190 is a reply to message #397176]

Thu, 09 April 2009 06:01

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

nothing return

c:\ ping fams
ping request could not find host fams. Please check the name and try again.

But ping to ip return

any idea .??

Report message to a moderator

Re: Sql Developer connection with SqL server URGENT [message #397193 is a reply to message #397190]

Thu, 09 April 2009 06:16

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

So "fams" is not a definetely NOT a host name.

You need to find someone to do it for you, who has at least some basic understanding on how computers and networks work, this is hopeless.

Report message to a moderator

Previous Topic:	How to change default editor in SQL *Plus (merged)
Next Topic:	HOW TO MONITOR JOBS IN TOAD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 00:08:36 CDT 2024