Unanswered: How to use opendatasource of remote sqlserver ?
I(sqlserver 2000 desktop /win98) want to visit a remote sqlserver (sqlserver 7.0 / NT 4.0) which have been registered in microsoft management console of local sqlserver. And "select * from authors" in this registered sqlserver can be executed well.
but if I changed to execute following sql statement:
SELECT * FROM OPENDATASOURCE(
'Data Source=192.168.1.1;User ID=user;Password=pass'
the result is "General network error. Check your network documentation".
there is no dsn server in local network
what is wrong with me ?