Home » SQL & PL/SQL » Client Tools » Sql Developer connection with SqL server URGENT (2005, xp)
Sql Developer connection with SqL server URGENT [message #397121] Thu, 09 April 2009 02:34 Go to next message
annu-agi
Messages: 203
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

./fa/6007/0/
thanks in advace and regards

Anwer
  • Attachment: 1.JPG
    (Size: 123.71KB, Downloaded 1066 times)
Re: Sql Developer connection with SqL server URGENT [message #397123 is a reply to message #397121] Thu, 09 April 2009 02:43 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
"10.10.0.75\famsrv" is not a hostname, like it says in the error message.
Re: Sql Developer connection with SqL server URGENT [message #397129 is a reply to message #397123] Thu, 09 April 2009 02:58 Go to previous messageGo to next message
annu-agi
Messages: 203
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

./fa/6008/0/


thanks and regards
  • Attachment: 2.JPG
    (Size: 70.67KB, Downloaded 994 times)
Re: Sql Developer connection with SqL server URGENT [message #397140 is a reply to message #397129] Thu, 09 April 2009 03:33 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
An ODBC "Server" is a completely different thing than a SQLServer "Hostname".
Re: Sql Developer connection with SqL server URGENT [message #397158 is a reply to message #397140] Thu, 09 April 2009 04:24 Go to previous messageGo to next message
annu-agi
Messages: 203
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


Re: Sql Developer connection with SqL server URGENT [message #397160 is a reply to message #397158] Thu, 09 April 2009 04:36 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
How about putting the real hostname in the hostname field and then clicking on "retrieve database"?

Re: Sql Developer connection with SqL server URGENT [message #397165 is a reply to message #397160] Thu, 09 April 2009 05:03 Go to previous messageGo to next message
annu-agi
Messages: 203
Registered: July 2005
Location: Karachi
Senior Member

nothing happins
faliure unknown host name
see the image below
./fa/6009/0/
  • Attachment: 3.JPG
    (Size: 118.84KB, Downloaded 955 times)
Re: Sql Developer connection with SqL server URGENT [message #397167 is a reply to message #397165] Thu, 09 April 2009 05:06 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.

Re: Sql Developer connection with SqL server URGENT [message #397172 is a reply to message #397167] Thu, 09 April 2009 05:23 Go to previous messageGo to next message
annu-agi
Messages: 203
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
Re: Sql Developer connection with SqL server URGENT [message #397176 is a reply to message #397172] Thu, 09 April 2009 05:31 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Basic network troubleshooting.

What does a
ping fams


tell you
Re: Sql Developer connection with SqL server URGENT [message #397190 is a reply to message #397176] Thu, 09 April 2009 06:01 Go to previous messageGo to next message
annu-agi
Messages: 203
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 .??

Re: Sql Developer connection with SqL server URGENT [message #397193 is a reply to message #397190] Thu, 09 April 2009 06:16 Go to previous message
ThomasG
Messages: 3189
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.
Previous Topic: How to change default editor in SQL *Plus (merged)
Next Topic: HOW TO MONITOR JOBS IN TOAD
Goto Forum:
  


Current Time: Sun Dec 11 04:34:51 CST 2016

Total time taken to generate the page: 0.07924 seconds