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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-03-11 : 07:18:26
|
| Amir Shekari writes "Dear SirI 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.Thanksamir 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 |
 |
|
|
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 |
 |
|
|
|
|
|