Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 A question about Sql Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-11 : 07:18:26
Amir Shekari writes "Dear Sir
I installed Sql Server 2000 home edition on my pc . when i connect to internet by dial up my pc take a valid ip but I can not call my sql server in ado by ip an just I can call with my computer name.
please help me.
Thanks
amir shekari"

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2003-03-11 : 11:01:46
try creating a system or a file dsn using just the IP address instead of the connection string containing the complete information.

I tested our own db server using IP connection using System DSN and it worked. In fact, I could even use it for an instance

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-11 : 12:23:32
Why would you even want to call it by its IP address? You should always use the computer name or an alias.

Tara
Go to Top of Page
   

- Advertisement -