Home » Other » 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: 239
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 3211 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 Go to previous messageGo to next message
ThomasG
Messages: 3212
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 Go to previous messageGo to next message
annu-agi
Messages: 239
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 2978 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 Go to previous messageGo to next message
ThomasG
Messages: 3212
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 Go to previous messageGo to next message
annu-agi
Messages: 239
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 Go to previous messageGo to next message
ThomasG
Messages: 3212
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 Go to previous messageGo to next message
annu-agi
Messages: 239
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 2933 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 Go to previous messageGo to next message
ThomasG
Messages: 3212
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 Go to previous messageGo to next message
annu-agi
Messages: 239
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 Go to previous messageGo to next message
ThomasG
Messages: 3212
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 Go to previous messageGo to next message
annu-agi
Messages: 239
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 Go to previous message
ThomasG
Messages: 3212
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 21 17:25:00 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.