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 |
|
Gayatri D.Patil
Yak Posting Veteran
58 Posts |
 Posted - 2008-01-21 : 05:16:32
|
| hello siri have sql sever 2000 installed on my PC which i would like to share on network.when i am trying to create ODBC connection from other pcs on network i am getting error -- specified sql server not found.pls help megayatri |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-21 : 06:03:26
|
| How are you connecting? Are you using machine name or IP Address?Can you ping the machine from another on the network? |
 |
|
|
Gayatri D.Patil
Yak Posting Veteran
58 Posts |
Posted - 2008-01-21 : 06:58:51
|
| hello siryes we are using machine name.and all machine are connected.so pls help me. |
|
|
|
sundaram_r_1984
Starting Member
11 Posts |
Posted - 2008-01-21 : 07:50:08
|
| Im not an expert.. and im not sure about this solution. but give it a try, if u feel it is okinstead of just using the machine name... i suggest you to use the ip address... i think problem is with the syntax.if you are with ASP & MS SQL.. please try this syntax... set con=server.createobject("ADODB.connection") set rs=server.createobject("ADODB.recordset")'(replace the things with in the <> with your suitable info..) con.open "Driver={SQL Server};Server=<111.199.149.93>; Database=<databasename>;UID=<userId>;PWD=<password>" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 15:15:02
|
| Did you enable tcp/ip and/or named pipes protocol on the server? |
|
|
|
|
|
|
sqlsever sharing