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 |
|
krisbg
Starting Member
5 Posts |
 Posted - 2003-11-19 : 03:32:35
|
| Can I connect to a local SQL Server through ODBC using the IP address and port number instead of "(loacl)"?Thanks in advance! |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-11-19 : 07:13:33
|
| Why not? Anyway in MS Access it works fine:SELECT *FROM books IN '' [odbc;Driver={SQL Server};Server=192.168.0.3;Database=myDB;Uid=sa;Pwd=;]; |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-19 : 08:06:01
|
| Add this to your connection string:Address=127.0.0.1,1434;The first section is the IP address, then a comma, then the port number. |
|
|
|
|
|
|
Connection to loacl server using IP address?